| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
I want to delete multiple blank rows from a spreadsheet
I have transferred approx 2000 rows of data from a Crystal report and of
these there are approx 1000 blank rows. I want to delete these but not by selecting each one. Can anyone help |
|
#2
|
|||
|
|||
|
Add a new column A,
number it from 1 to 2000 sort by column B delete all rows below last row of column B sort by column A again "Sharon43" wrote in message ... I have transferred approx 2000 rows of data from a Crystal report and of these there are approx 1000 blank rows. I want to delete these but not by selecting each one. Can anyone help |
|
#3
|
|||
|
|||
|
Select the column and F5 SpecialBlanksOK
Then EditDeleteEntire Row. Gord Dibben Excel MVP On Fri, 7 Oct 2005 04:20:02 -0700, "Sharon43" wrote: I have transferred approx 2000 rows of data from a Crystal report and of these there are approx 1000 blank rows. I want to delete these but not by selecting each one. Can anyone help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving Multiple Rows at one time | Excel Discussion (Misc queries) | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| How to delete blank rows | Excel Discussion (Misc queries) | |||
| Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
| Blank Rows | Excel Discussion (Misc queries) | |||
Hybrid Mode
