Hide cell from printing, but...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some cells that I'd like to be displayed when I view the spreadsheet in Excel, but not shown when I print the spreadsheet

There have been a few previous posts with this question, but

- Some people suggest using a white font. If I do that, I won't be able to see the cell contents when I view the spreadsheet in Excel

- Some people suggest using a macro, but that's not an option--I'm not allowed to use macros because of virus concerns

Thanks in advance for your help

Jer
 
This is a less than elegant solution, but...

For the cells you want to view but not print, move them to a column you
can hide. Then create a text box where you want that cell's contents to
appear on your screen. Select the text box and in the formula bar type
= cell reference. (ie, =$A$1). Right click on the text box, select
Format Text Box... On the Properties tab, deselect the Print Object
check box.

Now hide the column than contains your non-printing information. You
can still read all the info in the text boxes on your screen, but they
will not print.
 
Try this:
Select the only the area that you would like print by
using the right mouse click. If there is addiditonal
area outside of this range that you want to print hit the
CTRL< button and highlight the other areas using the
Click to expand...
right mouse click. It is kind of tempermental but will
work. After the entire area is highlighted, from the
menu bar select FILE, PRINT AREA, SET PRINT AREA. If you
have set the area correctly it will loose the blue
highlight and have a thin broken border surrounding the
area. You can use the PRINT PREVIEW to verify the area.
Also, if you do not clear the area, the print area that
you selected will remain with the excel file.

Hope this works!

-----Original Message-----
I have some cells that I'd like to be displayed when I
Click to expand...
view the spreadsheet in Excel, but not shown when I print
the spreadsheet.
There have been a few previous posts with this question, but:

- Some people suggest using a white font. If I do that,
Click to expand...
I won't be able to see the cell contents when I view the
spreadsheet in Excel.
- Some people suggest using a macro, but that's not an
Click to expand...
option--I'm not allowed to use macros because of virus
concerns.
 
Back
Top