space after subtotal in report

L

LindaB@work

is there a way to add a line or space after a subtotal?

I am new at Excel, so be gentle. I can do it in a heartbeat in Word or
Access...
I'm in a whole new world.

thank you...
 
J

Jonathan Cooper

Assuming you are not using Excel's build in subtotals routine, and that you
are just manually adding up a bunch of cells, this is a simple fix.

lets say your subtotal is on row 10. with your mouse, right click on row 11
(literally, I want you to right click on the '11' at the extreme left hand
side of Excel). Then left click on INSERT. This will insert a blank row.
 
L

LindaB@work

I was using the subtotals routine, and cannot find a way to automatically add
the line after the total. In this way, I will have the line without the extra
cells on my spreadsheet. Thank you.
Linda
 
J

Jonathan Cooper

You can still insert a row manually. There is no pedestrian way to
automatically insert a blank row.

If you want to go the macro route, I suggest you repost in this forum. But
provide more description on what you specifically are looking to do. I'm
could almost help, but still learning VBA.
 
Top