View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Troy Piggins Troy Piggins is offline
external usenet poster
 
Posts: 2
Default show rows on screen, but not print them

On a spreadsheet in excel from office xp, is it possible to
display a row on the screen, but when you print the sheet it
doesn't get printed? How do I do that?

I tried hiding the row, but the admin wants to be able to see it
on screen and complained too tedious to unhide it on screen then
hide it for printing.

I have never written macros for excel so not sure if there is a
solution there, or if it can be done another way.

I also thought we could have the data from the row in another
sheet that doesn't get printed, but she (the admin) preferred the
hide/unhide solution.

Any help appreciated.

--
Troy Piggins