I am relatively new with preparing accounting reports. In the spreadsheet I
am working with, I saw that except the print areas, the entire spreadsheet
was grayed out. I wonder how that was done. I know how to gray out a range of
cells, but don't know how to do it for the entire spreadsheet. The other
thing I noticed was that within the printed area, there was the nice
information painted at the background indicating page numbers. This page
number will not be printed out if I select print. And I don't know how that
was done either. Hope someone will help me with these questions. Thanks,

You're seeing at the spreadsheet in Page Break view, which can be selected by
clicking on View command at the top of your screen. You're probably more
accustomed to working with spreadsheets in Normal view, which doesn't show
the gray areas and the page numbers.

"Lily" wrote:

I am relatively new with preparing accounting reports. In the spreadsheet I
am working with, I saw that except the print areas, the entire spreadsheet
was grayed out. I wonder how that was done. I know how to gray out a range of
cells, but don't know how to do it for the entire spreadsheet. The other
thing I noticed was that within the printed area, there was the nice
information painted at the background indicating page numbers. This page
number will not be printed out if I select print. And I don't know how that
was done either. Hope someone will help me with these questions. Thanks,

Hi Lily

There are two options on the "View" toolbar called "Normal" and "Page Break
Preview". I think you are looking at the "Page Break Preview" option. Play
around with these two options and you'll see the differences.

--
XL2002
Regards

William



"Lily" wrote in message
...
| I am relatively new with preparing accounting reports. In the spreadsheet
I
| am working with, I saw that except the print areas, the entire spreadsheet
| was grayed out. I wonder how that was done. I know how to gray out a range
of
| cells, but don't know how to do it for the entire spreadsheet. The other
| thing I noticed was that within the printed area, there was the nice
| information painted at the background indicating page numbers. This page
| number will not be printed out if I select print. And I don't know how
that
| was done either. Hope someone will help me with these questions. Thanks,

Exactly, thank you!

"garfield-n-odie" wrote:

You're seeing at the spreadsheet in Page Break view, which can be selected by
clicking on View command at the top of your screen. You're probably more
accustomed to working with spreadsheets in Normal view, which doesn't show
the gray areas and the page numbers.

"Lily" wrote:

I am relatively new with preparing accounting reports. In the spreadsheet I
am working with, I saw that except the print areas, the entire spreadsheet
was grayed out. I wonder how that was done. I know how to gray out a range of
cells, but don't know how to do it for the entire spreadsheet. The other
thing I noticed was that within the printed area, there was the nice
information painted at the background indicating page numbers. This page
number will not be printed out if I select print. And I don't know how that
was done either. Hope someone will help me with these questions. Thanks,