Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete blank rows (rows alternate data, blank, data, etc
I am looking for a shortcut to delete multiple blank rows (rows alternate as
follows: data, blank, data, blank, etc.) Is there a way to delete the blank rows between the data rows without having to select each row individually using CNTRL-C? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete blank rows (rows alternate data, blank, data, etc
On Jun 26, 1:10 pm, ncochrax
wrote: I am looking for a shortcut to delete multiple blank rows (rows alternate as follows: data, blank, data, blank, etc.) Is there a way to delete the blank rows between the data rows without having to select each row individually using CNTRL-C? Selecting all of your data and sorting it by any of your columns should move all of the blank rows to the bottom. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete blank rows (rows alternate data, blank, data, etc
you could also use the autofilter to filter for blanks, then delete the
filtered rows, turn off autofilter. or, select one of your columns, Edit/Goto/Special - blanks, which will select the blank cells and then delete the rows. be sure to keep a backup before you try any suggestion that is new to you (if your data is important, you should already have it backed up). "ncochrax" wrote: I am looking for a shortcut to delete multiple blank rows (rows alternate as follows: data, blank, data, blank, etc.) Is there a way to delete the blank rows between the data rows without having to select each row individually using CNTRL-C? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting alternate blank rows in Excel | Excel Discussion (Misc queries) | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
Get number of rows that data uses, including blank rows | Excel Discussion (Misc queries) | |||
Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | Excel Discussion (Misc queries) |