| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I remove formula but keep value with a simple command?
I use Excel for my budget. Each month has its own worksheet. I have a
overview sheet that is linked to key days of the month so I can see balance trends on a single page. Also on this page is a list of all the constant expences and then each sheet is linked that those cells so if my payment amount for something changes I only have to change 1 cell. The problem comes when I want to archive a worksheet. I have to go through it one cell at a time and type in the values so the worksheet won't be linked to other pages when I move it to my archive file. Is there a simple command I can type while a cell or cells are selected that would keep the value of that cell the same but remove the formula that links it to other places? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple question on With command | Excel Discussion (Misc queries) | |||
| Remove GETPIVOTDATA command | Excel Worksheet Functions | |||
| How to remove all instances of a command button | Excel Discussion (Misc queries) | |||
| Checking to see that a CHART exists prior to running a simple command | Excel Discussion (Misc queries) | |||
| search string command to answer simple Yes or No | Excel Worksheet Functions | |||
Threaded Mode
