An Issue with sub-total

A

arcticale

What is the best way to do this :
I have several columns in my spreadsheet, I sub-totaled every change in Sta
tement. When i compress the file, of course, the only visible rows are the
sub totals which says:
statement1 total xxx
statement2 total xxx
statement3 total xxx

is there a way for me to see the column contents so that my spreadsheet will
look like this :

Account Statment Amount
1000 Statement1 total xxxx
2000 Statement2 total xxxx
3000 Statement3total xxxx

I tried data fill. But wont work

thanks and have a great new year everyone

del
 
A

arcticale

I have two columns with values in my worksheet. is there a way I can put this
side by side when I do the pivot table. Usually, it is one over the other.

thanks a lot
 
R

Ron Coderre

Try this:

Using the Pivot Table.....
Left-Click and hold on the column heading for the amounts.
Drag it to the right until it covers the "Total" column heading.
Release.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
A

arcticale

THANKS RON!!!!!!!!!!!!!!!!!!!!

Ron Coderre said:
Try this:

Using the Pivot Table.....
Left-Click and hold on the column heading for the amounts.
Drag it to the right until it covers the "Total" column heading.
Release.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
Click to expand...
 
R

Ron Coderre

You're very welcome...I'm glad that worked for you.

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top