| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I shift the contents of the cells up to remove empty cells.
I have empty cells scattered throughout a row .
whenever I delete the contents of a cell it leaves it empty. I would like to consolodate the information in the row so no empty cells are apparent |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I shift the contents of the cells up to remove empty cells.
For possibly better answers, elaborate further. Show us some sample data, and
the expected results. I'm having difficulty reconciling your subject line with your description. -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- "auctioncoach" wrote: I have empty cells scattered throughout a row . whenever I delete the contents of a cell it leaves it empty. I would like to consolidate the information in the row so no empty cells are apparent |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I shift the contents of the cells up to remove empty cells.
F5SpecialBlanksOK
EditDeleteShift cell up. May or may not be what you want. Gord Dibben MS Excel MVP On Tue, 10 Feb 2009 18:04:01 -0800, auctioncoach wrote: I have empty cells scattered throughout a row . whenever I delete the contents of a cell it leaves it empty. I would like to consolodate the information in the row so no empty cells are apparent |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove Data from Empty Cells | Excel Discussion (Misc queries) | |||
| How can I program excel to shift data up to fill empty cells? | Excel Discussion (Misc queries) | |||
| how do i remove shift lock (highlighting cells) from excel? | Excel Discussion (Misc queries) | |||
| remove error value when formula exists for empty cells | Excel Worksheet Functions | |||
| how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
Linear Mode
