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
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
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" <[email protected]> wrote in message
news:[email protected]...
> 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
Select the column and F5 Special>Blanks>OK
Then Edit>Delete>Entire Row.
Gord Dibben Excel MVP
On Fri, 7 Oct 2005 04:20:02 -0700, "Sharon43"
<[email protected]> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks