| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Easily convert all formulas in 3d spreadsheet to values?
I have a large Excel 3-D workbook with 40 sheets, each with multiple complex
formulas. At the end of each month I archive the sheet and would like to convert the formulas into values to reduce the size of the workbook. Can this be done in a few easy steps, as I don't want to copy and special paste as values 40 times over? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Easily convert all formulas in 3d spreadsheet to values?
Hi
Group the sheets first, then select all of the cells on the visible sheet (Ctrl+A) and Paste Special/Values. Don't forget to ungroup the sheets after! Andy. "Jazza" wrote in message ... I have a large Excel 3-D workbook with 40 sheets, each with multiple complex formulas. At the end of each month I archive the sheet and would like to convert the formulas into values to reduce the size of the workbook. Can this be done in a few easy steps, as I don't want to copy and special paste as values 40 times over? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Easily convert all formulas in 3d spreadsheet to values?
Record a Macro (ToolsMacroRecord...) that copies and PasteSpecials each
sheet. Add a hot key (like Ctrl-V) to convert them all to values. Then all you have to do is press your hot key. "Jazza" wrote: I have a large Excel 3-D workbook with 40 sheets, each with multiple complex formulas. At the end of each month I archive the sheet and would like to convert the formulas into values to reduce the size of the workbook. Can this be done in a few easy steps, as I don't want to copy and special paste as values 40 times over? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| simplify procedure to get rid of 0 error values in a spreadsheet | Excel Worksheet Functions | |||
| Copy Values in a cell (derived from formulas) | Excel Worksheet Functions | |||
| changing formulas to values so that they will be recognized by Find and Replace | Excel Discussion (Misc queries) | |||
| I created a spreadsheet in excel & trying to convert it to micros. | Excel Discussion (Misc queries) | |||
| delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
Hybrid Mode
