Blanketty blank rows

  • Thread starter Thread starter Dave Corbett
  • Start date Start date
D

Dave Corbett

Hi, ... computer illiterate here ... well almost.

When I import data into Excel from Quickbooks, it arrives with loads of
blank columns and rows. The blank columns I can deal with, but the blank
rows .... that's another story.

I need to get rid of them to make labels from the data.

There is no option for rows in Quickbooks, so is there an option in Excel
delete all these unwanted blank rows?

Help gratefully accepted.

Thanks
 
select the data, press F5, select special, select blanks,
click OK..
do edit>delete entire row (if you are sure the rows are empty)
or shift cells up..
 
You need to choose Edit + GoTo + Special. You can then
Choose Blanks and OK. You can then delete the rows.

Hope this helps

Judith
 
Back
Top