Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting empty rows automatically
Hi to all
I have a spreadsheet which has lots of rows of data. It also has lots of empty rows in between the rows of data. Is there any way of deleting the empty rows automatically, instead of highlighting each of them one at a time and deleting them that way? Maybe theres an option within Excel somewhere where Excel deletes empty rows within a selection? All help most appreciated Thanks Bigweed |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting empty rows automatically
Here are some easy ways for you to do it manually.
Select all the data where you want to remove blank rows. Sort by one of the columns that has blanks in it. Now all the blanks rows are together. Now select the blank rows and delete them all at the same time using CTRL- (control-minus) - or - Select all the data where you want to remove blank rows. Data Filter Autofilter Filter for (blank) on one of the columns Now select all the blank rows that are showing. Do CTRL- (control-minus) to remove these lines. Note that this may take a bit longer, especially if you have a lot of formulae. You may or may not get a few posts suggesting macros for this. Whether or not you go to the trouble of setting those up really depends how often you are likely to have to do this. -- Allllen "Bigweed" wrote: Hi to all I have a spreadsheet which has lots of rows of data. It also has lots of empty rows in between the rows of data. Is there any way of deleting the empty rows automatically, instead of highlighting each of them one at a time and deleting them that way? Maybe theres an option within Excel somewhere where Excel deletes empty rows within a selection? All help most appreciated Thanks Bigweed |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting empty rows automatically
Select a column.
F5SpecialBlanks EditDeleteEntire Row Gord Dibben MS Excel MVP On Wed, 13 Sep 2006 04:00:01 -0700, Bigweed wrote: Hi to all I have a spreadsheet which has lots of rows of data. It also has lots of empty rows in between the rows of data. Is there any way of deleting the empty rows automatically, instead of highlighting each of them one at a time and deleting them that way? Maybe theres an option within Excel somewhere where Excel deletes empty rows within a selection? All help most appreciated Thanks Bigweed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I globally delete empty cells or rows in different places | Excel Discussion (Misc queries) | |||
Delete empty rows with cell type 2 | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Delete empty rows from print in Excel | Excel Worksheet Functions | |||
Remove empty rows in excel? | Excel Discussion (Misc queries) |