View Single Post
  #2   Report Post  
Excel_Geek
 
Posts: n/a
Default


Here's one way to accomplish that effect:

1) Fill all cell outside the print area as grey.
2) Hide the row/column headers.
3) Lock the scroll area of the worksheet to just the print area.

Let me know if you need help with any of these steps.


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=476278