| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print area across the freeze panes area | Excel Worksheet Functions | |||
| When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
| How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) | |||
Linear Mode
