How do I only show print area in excel?

[Guest]

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

 

[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.

 

[Guest]

What is a marco?

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.

 

[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.

 

[Guest]

Ragdyer,

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

 

[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