Set Print Area causes Shapes to disappear
In Excel 2007, I have a spreadsheet with a Rectangle covering some of the
cells so that when I print the worksheet, text that I add to the rectangle
will print, but the text in the cells behind the rectangle remains hidden.
As soon as I "SET PRINT AREA" to the spreadsheet, the rectangle isn't
viewable anymore, though the rectangle is still there. When I print the
spreadsheet, the rectangle successfully hides the information and the text
within the rectangle prints properly, but if I need to change that text, I
can't because I can't see the rectangle any more. I know it's there, but I
don't know how to edit the text within it.
Any suggestions?
|