| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Removing formulas but keeping formula totals.
I need to delete some columns that are part of other cell formulas. How do I
go about deleting one column but keep the results of the formulas in other cells? Ex. I need to delete column G, but need to keep the result in column H. When I do delete column G I get the #REF! error. I need to remove formula and keep number 10.3. G H 10 =G1*1.03 Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula works in some cells, doesn't in other | New Users to Excel | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| what is the formula to add totals from two different worksheets | Excel Discussion (Misc queries) | |||
| What formula can I use to get daily totals from list | Excel Worksheet Functions | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Threaded Mode
