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! |
#2
|
|||
|
|||
Select the cell with the formula, edit - paste special - values. HTH
-- Sincerely, Michael Colvin "cowboyeti" wrote: 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! |
#3
|
|||
|
|||
Michael,
When I go to the cell with the formula in it I don't get the option of paste special. It's shaded out. I also right clicked in the cell, and it (paste special) is not avaliable also. c "Michael" wrote: Select the cell with the formula, edit - paste special - values. HTH -- Sincerely, Michael Colvin "cowboyeti" wrote: 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! |
#4
|
|||
|
|||
On Mon, 18 Jul 2005 09:16:09 -0700, cowboyeti
wrote: When I go to the cell with the formula in it I don't get the option of paste special. It's shaded out. I also right clicked in the cell, and it (paste special) is not avaliable also. Do you have the cell locked/protected? MP- -- "Learning is a behavior that results from consequences." B.F. Skinner |
#5
|
|||
|
|||
You must copy first:
- Copy the cell(s) - Edit - Paste Special - Values with the same cell(s) selected HTH Anders SIlven "cowboyeti" wrote in message ... Michael, When I go to the cell with the formula in it I don't get the option of paste special. It's shaded out. I also right clicked in the cell, and it (paste special) is not avaliable also. c "Michael" wrote: Select the cell with the formula, edit - paste special - values. HTH -- Sincerely, Michael Colvin "cowboyeti" wrote: 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! |
#6
|
|||
|
|||
Sorry, cowbyeti. First you have to copy the cell and then do the edit -
paste special -values on the same cell. -- Sincerely, Michael Colvin "cowboyeti" wrote: Michael, When I go to the cell with the formula in it I don't get the option of paste special. It's shaded out. I also right clicked in the cell, and it (paste special) is not avaliable also. c "Michael" wrote: Select the cell with the formula, edit - paste special - values. HTH -- Sincerely, Michael Colvin "cowboyeti" wrote: 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! |
#7
|
|||
|
|||
Thanks a bunch guys!!!
"Anders Silven" wrote: You must copy first: - Copy the cell(s) - Edit - Paste Special - Values with the same cell(s) selected HTH Anders SIlven "cowboyeti" wrote in message ... Michael, When I go to the cell with the formula in it I don't get the option of paste special. It's shaded out. I also right clicked in the cell, and it (paste special) is not avaliable also. c "Michael" wrote: Select the cell with the formula, edit - paste special - values. HTH -- Sincerely, Michael Colvin "cowboyeti" wrote: 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! |
Reply |
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) |