| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Blank Lines
I have a hunch this should not be so difficult, but I have reviewed all the
HELP stuff and am unable to locate how to delete the blank lines from an Excell spreadsheet. Very annoying doing the deletiona manually with Control -. Thanks. -- Templar |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete Blank Lines
|
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete Blank Lines
Select a column within the range that has blank cells.
F5SpecialBlanksOK EditDeleteEntire Row. If you are thinking of deleting all the unused blank rows below your data range, this cannot be done. Those you hide. Gord Dibben MS Excel MVP On Fri, 26 Dec 2008 12:11:01 -0800, Templar wrote: I have a hunch this should not be so difficult, but I have reviewed all the HELP stuff and am unable to locate how to delete the blank lines from an Excell spreadsheet. Very annoying doing the deletiona manually with Control -. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add button to bottom of spreadsheet to delete blank lines auto | Excel Discussion (Misc queries) | |||
| Delete Blank Lines | Excel Discussion (Misc queries) | |||
| How do i delete blank lines at bottom of an Excel worksheet? | Excel Discussion (Misc queries) | |||
| Is there a easy way to delete blank lines to clean up worksheets? | Excel Worksheet Functions | |||
| Delete Blank Lines | Excel Discussion (Misc queries) | |||
Linear Mode
