deleting rows in a huge spreadsheet with subtotals

E

ExcelNovice

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.
 
P

PY & Associates

If we know what rows to delete, automation is straight forward please.

Cheers
 
G

Gord Dibben

Select a column and F5>Special>Blanks>OK

Edit>Delete>Entire Row.


Gord Dibben MS Excel MVP
 
G

Gord Dibben

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
 

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 5
Subtotal by Date and Summary in Lists? 0
automatically deleting blank rows? 3
macro to delete lines based on a value - Repost 2
Subtotals including blank rows 0
Combine multiple columns and rows for one record into one row. 2
How do I make subtotals appear directly below groups with spaces b 0
Need Help on Subtotal Forumla in List Manager 4

Top