How do I only show print area in excel?

J

Jeffro

I cant figure out how to only show the printable area in excel, and have all
other cells greyed out? Can anybody help.
 
E

Earl Kiosterud

Jeffro,

View - Page Break Preview will sort of do that, though you can still see the
cells that are outside the print area. I think a macro could make it
totally invisible, if you want to go that route. We can write you one.
 
J

Jeffro

What is a marco?

Earl Kiosterud said:
Jeffro,

View - Page Break Preview will sort of do that, though you can still see the
cells that are outside the print area. I think a macro could make it
totally invisible, if you want to go that route. We can write you one.
Click to expand...
 
R

Ragdyer

This is not a macro, but ... might this be what you're looking to
accomplish?

Open a new sheet, and select *all* of Column G by clicking on G in the
column header.
Then, do <Ctrl> <Shift> <RightArrow>.
This selects all the columns, out to the last column, IV.
Right click in the selection and choose "Hide".

Is that the effect you're looking for?

If it is, you can do the same thing with the rows, by simply using the down
arrow in place of the right arrow.
 
R

RagDyer

Thanks for the feed-back.

--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Ragdyer,

That is what I was looking for. Thanks for your help
Jeffro
 
Top