Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete all the blanc cells in a worksheet and shift cells l
There are a lot of blanc cells in a worksheet, and now I want to select all
of them, delete and shift cells left. is there a function to realize it? or macro? Thank you~ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete all the blanc cells in a worksheet and shift cells l
Select the range
edit|goto|special|blanks Edit|delete (shift left) If you need a macro, you can record one when you do it manually. tiramisu wrote: There are a lot of blanc cells in a worksheet, and now I want to select all of them, delete and shift cells left. is there a function to realize it? or macro? Thank you~ -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete all the blanc cells in a worksheet and shift cells l
Hit function key F5
SpecialBlanksOK This will select all blank cells in the used range. Then: EditDeleteShift cells leftOK Biff "tiramisu" wrote in message ... There are a lot of blanc cells in a worksheet, and now I want to select all of them, delete and shift cells left. is there a function to realize it? or macro? Thank you~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error 1004: Cannot shift nonblank cells off the worksheet | Excel Discussion (Misc queries) | |||
delete coumns - shift non-blank cells message | Excel Discussion (Misc queries) | |||
embedding worksheet cells in another worksheet | Excel Discussion (Misc queries) | |||
What function can make cells shift up when they are blank? | Excel Worksheet Functions | |||
Excel cannot shift nonblank cells | Excel Discussion (Misc queries) |