Convert range, sheet, file to value-only (replace all formula by value)

DigDB

Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download ^{free 15-day trial} | Purchase | FAQ | Contact

Convert range, sheet, file to value-only (replace all formula by value)

You can use Excel's Copy, and then 'Paste Special...' to get rid of formulas and links in a range, and convert it into a value-only range. DigDB allows you to do the same conversion with only 1 click.

You can also convert an entire worksheet, or several worksheets, or an entire workbook into value-only data easily. This will help you get a value-only file in a few clicks. But before you convert the file, you may want to save a copy of the original file.

Convert by Sheets

Invoke 'DigDB->File->Formula to Value...', you can then select one, several, or all sheet(s) to convert to value

Practice file - convert-value-demo.xls (16k)
Select the sheets. Use 'Add' or 'Add all'. Note that all sheets, including sheets that are hidden (if there is any), will be shown in the right-hand selection pool.

Sheets added. Click 'OK' to convert.

Convert by Range

Select a range first, then invoke 'DigDB->Selected Area->Convert->Formula to Value'

Need more?

Browse the complete list of DigDB's powerful features listed on the front page.
If you see errors or things not working, check out our error reference page.

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.