Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Exclude certain cells from printing.
I would like to exclude some cells from printing when the worksheet is printed.
Is it possible to set the worksheet up so that the cells are always visible to the user but when they print the sheet, these cells do not print? The cells in question will contain instructions for the user that they will not wish to print. |
#2
|
|||
|
|||
Three options.
1. Depending on the layout of the sheet, it may be possible to exclude the areas by setting the print area. 2. The instructions could be put into cell comments (these appear when the cursor is on the cell). 3. Write a before Workbook_BeforePrint routine to delete the instructions and use Application.OnTime within it to call a routine several seconds later to write the instructions back in. -- Ian -- "excelnewbie" wrote in message ... I would like to exclude some cells from printing when the worksheet is printed. Is it possible to set the worksheet up so that the cells are always visible to the user but when they print the sheet, these cells do not print? The cells in question will contain instructions for the user that they will not wish to print. |
#3
|
|||
|
|||
See
http://www.rondebruin.nl/print.htm#Hide -- Regards Ron de Bruin http://www.rondebruin.nl "excelnewbie" wrote in message ... I would like to exclude some cells from printing when the worksheet is printed. Is it possible to set the worksheet up so that the cells are always visible to the user but when they print the sheet, these cells do not print? The cells in question will contain instructions for the user that they will not wish to print. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exclude certain cells from printing.
I seem to recall that in 1-2-3 by Lotus there was a character which you could
start a cell with and the contents of the cell would not print, which I think it what you are looking for. I seem to think the character was | or ¦. However, neither character seems to work in Excel 2003 to keep the contents of the cell from printing. If there is a comparable character (or function) in Excel, I haven't yet found it. "excelnewbie" wrote: I would like to exclude some cells from printing when the worksheet is printed. Is it possible to set the worksheet up so that the cells are always visible to the user but when they print the sheet, these cells do not print? The cells in question will contain instructions for the user that they will not wish to print. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Help me! There is problem with cells view... | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |