View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
OEM-Chad OEM-Chad is offline
external usenet poster
 
Posts: 1
Default Any way to hide a cell or row from printing?

I am using a header to make my multi-page worksheet look nice when it is
printed. Unfortunately, that header only shows up when I am working with the
Excel document if I have the view set to Page Layout. That view does not work
so good when I am working with the spreadsheet.

The header contains information pertinent to the worksheet I am on, but if I
am not in the Page Layout view, I don't see it. If I choose to include the
pertinent information and just put it in a cell at the top of the worksheet,
then the information is duplicated when I print. I would like to just be able
to hide that row or cell when I print. Any way to do this?

Thanks.