printing and groups

L

Locachica

Hello!
I have searched the forum but didn't find an answer.. so here it goes.

I have a quite long balance sheet with different totals. I have grouped
what each total contains so the sheet appears shorter on the screen. I
would like to print the grouped "look" as well, but when I hit "print"
the whole sheet is printed out.

I have got a file long long ago with a macro that was doing exactly
this, but can't find the file.. does anybody know how to manage this?

Thanks!!!!
 
D

Dave Peterson

Sometimes when you're making changes, you extend the used range of the worksheet
way past what you think it should be.

If you hit ctrl-End, are you close to what you think it should be?

If not, you can use some techniques at Debra Dalgleish's site to reset that last
used cell:

http://www.contextures.com/xlfaqApp.html#Unused

Then try ctrl-end to see if that helped. And then print preview to double
check.

If that failed, you can specify exactly what you want to print via:

Selecting your range
File|print area|set print area

(and if you really want to limit your printing to a specific area without
changing too much in the worksheet:
select the range you want to print
File|Print
Print What:
check selection
 
Top