Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I merge cells into one then delete the original cells?
I'm trying to merge Name cells into one - got it done, but then I need to
delete the cells I merged - keep getting the reference error, as I delete the cells that are in the formula |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I merge cells into one then delete the original cells?
Highlight the cells where the formula is and then fix the values by
clicking <copy, then Edit | Paste Special | Values (check) | OK then <Esc. You can now safely delete the original columns of data. Hope this helps. Pete On Mar 7, 1:36*pm, LLR wrote: I'm trying to merge Name cells into one - got it done, but then I need to delete the cells I merged - keep getting the reference error, as I delete the cells that are in the formula |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I merge cells into one then delete the original cells?
And don't call them "merged cells".
You have "combined" the contents of two cells into one. That is not "merging" which is combining the contents of one cell into two or more cells. Gord Dibben MS Excel MVP On Fri, 7 Mar 2008 05:36:07 -0800, LLR wrote: I'm trying to merge Name cells into one - got it done, but then I need to delete the cells I merged - keep getting the reference error, as I delete the cells that are in the formula |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep original cells embedded in merged cell | Excel Discussion (Misc queries) | |||
How to delete all the blanc cells in a worksheet and shift cells l | Excel Discussion (Misc queries) | |||
hide original cells after creating chart | Charts and Charting in Excel | |||
How do I delete the line between 2 cells and merge them into one . | Excel Discussion (Misc queries) | |||
How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) |