printing and groups

  • Thread starter Thread starter Locachica
  • Start date Start date
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!!!!
 
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
 
Back
Top