deleting rows in a huge spreadsheet with subtotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use Peachtree which is an accounting package to run a small business. I
export Accounts Payable data from this package into Excel. When the data is
exported, it is subtotaled by each vendor with a blank row before and after
the vendor total.

I am looking for a way to easily delete rows from this report. The report
is updated daily and has over 600 rows. Any ideas or recommendations would
be greatly appreciated.
 
If we know what rows to delete, automation is straight forward please.

Cheers
 
Select a column and F5>Special>Blanks>OK

Edit>Delete>Entire Row.


Gord Dibben MS Excel MVP
 
You do not delete each row individually.

Select an entire column by seleting the column header.

After the F5>Special>Blanks>OK all blank rows are selected.

With them still selected just Edit>Delete>Entire Row


Gord
 
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

Deleting blank rows 4
% of subtotal in pivot table 1
Changing row color for each change in col A 3
automatically deleting blank rows? 3
Pivot table subtotals 2
Subtotals 3
Subtotals - show all columns? 2
IF Statement Problem 4

Back
Top