Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
excelnewbie
 
Posts: n/a
Default 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   Report Post  
Ian
 
Posts: n/a
Default

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   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do you "select locked cells" w/o "select unlocked cells"? princejohnpaulfin Excel Discussion (Misc queries) 3 July 16th 05 03:53 AM
Help me! There is problem with cells view... :-) Excel Discussion (Misc queries) 1 April 28th 05 01:16 PM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM


All times are GMT +1. The time now is 12:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"