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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate with line breaks but ignore blank cells 3
Counting NON-Blank fields 2
Need Help Deleting Blank Rows 3
Want only rows with populated data 1
Next-To-Last, Non-Blank, Rightmost Value in a Row 6
Copy rows from one worksheet automatically, ignore rows that are b 2
retrieving multiple corresponding values with variable rows/column 4
how to delet the blank rows in whole sheet at a time 1

Back
Top