Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Blank Lines
If there are a number of lines on a worksheet that are blank, can they
be deleted in one operation? TIA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Blank Lines
If you can sort the rows, the blanks will sort to the bottom, and
effectively "disappear" OR, you can put in a formula outside your range, like: =IF(COUNTA(A1:Z1)=0,2,1) and fill down, then sort on this column -- puts the blanks at the bottom (they have the "2") Bob Umlas Excel MVP "Saxman" wrote in message ... If there are a number of lines on a worksheet that are blank, can they be deleted in one operation? TIA |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Blank Lines
Try this:
Select a single column range that encompasses filled cells and blank cells (whose rows will be deleted). e.g. Select from A2:A100, where blanks in that range represent rows to be deleted. Press the [F5] key.....that's the shortcut for <edit<goto Click the [Special] button Check: Blanks....(now only the blank cells will be selected) Then, from the Excel main menu: <edit<delete Check: Entire row Click [OK] Does that help? If NO....<edit<undo *********** Regards, Ron XL2002, WinXP "Saxman" wrote: If there are a number of lines on a worksheet that are blank, can they be deleted in one operation? TIA |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Blank Lines
go to bottom of sheet
put xxxxxx (or whatever) in A cell click col A, SELECTS WHOLE COLUMN f5 SPECIAL BLANKS CLICK EDIT DELETE ENTIRE ROWS ENTER THAT SHOULD DO IT then dekete xxxxxx u have 1 more row than the data list -- JOHNW "Saxman" wrote: If there are a number of lines on a worksheet that are blank, can they be deleted in one operation? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Novice: Delete blank rows | Excel Discussion (Misc queries) | |||
Delete blank rows Macro | Excel Discussion (Misc queries) | |||
I want to delete multiple blank rows from a spreadsheet | New Users to Excel | |||
blank data field shows quote in formula, how to delete it? | Excel Discussion (Misc queries) | |||
How do I delete filtered lines in Excel 2000? | Excel Worksheet Functions |