| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW CAN I EASILY REMOVE MULTIPLE BLANK ROWS FROM A SPREADSHEET?
-- zzzzzzz |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW CAN I EASILY REMOVE MULTIPLE BLANK ROWS FROM A SPREADSHEET?
DataFilterAutofilter to filter for blanks.
OR Select a column and F5SpecialBlanksOK EditDeleteEntire Row. Gord Dibben MS Excel MVP On Thu, 9 Mar 2006 07:40:35 -0800, sandman832 wrote: |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW CAN I EASILY REMOVE MULTIPLE BLANK ROWS FROM A SPREADSHEET
Gord, that's amazing! I used the Select column - F5 routine and immediately
removed over 1600 blank lines from a huge spreadsheet. Thanks so much! -- zzzzzzz "Gord Dibben" wrote: DataFilterAutofilter to filter for blanks. OR Select a column and F5SpecialBlanksOK EditDeleteEntire Row. Gord Dibben MS Excel MVP On Thu, 9 Mar 2006 07:40:35 -0800, sandman832 wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort (or group?) a spreadsheet by similar rows? | Excel Worksheet Functions | |||
| Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
| How do I delete blank rows at the bottom of a spreadsheet to get . | Excel Discussion (Misc queries) | |||
| How do I remove blank rows in Excel? | Excel Discussion (Misc queries) | |||
| HOW DO I REMOVE DUPLICATED NAMES ON SPREADSHEET EXCEL97 3900 ROWS. | Excel Worksheet Functions | |||
Linear Mode
