I have a cell in the middle of a spreadsheet. It just has comments for how
to use the sheet but I do not want it to print in the end product.
Unfortunately the traditional methods of excluding it (page break preview,
right click cells and choose add to print area) dont work because since it's
in the middle of the sheet, it splits the document into two pages. Any
ideas? I'm using Excel 2002. Thanks!

Place your comments in a text box instead. Then in the properties of
the text box, uncheck the "print object" option. A text box can be
inserted into your spreadsheet from the "Drawing" toolbar, under
Views/Toolbars.


--
bakes1
------------------------------------------------------------------------
bakes1's Profile: http://www.excelforum.com/member.php...o&userid=31965
View this thread: http://www.excelforum.com/showthread...hreadid=517945

You can move the comments to an actual comment in the cell (right click the
cell and select "insert comment"). Comments are not printed unless you
specificly tell excel to print them.

You can also change the text color to match the background color (usually
white). This will change the cell to look like a blank cell.

"brodiemac" wrote:

I have a cell in the middle of a spreadsheet. It just has comments for how
to use the sheet but I do not want it to print in the end product.
Unfortunately the traditional methods of excluding it (page break preview,
right click cells and choose add to print area) dont work because since it's
in the middle of the sheet, it splits the document into two pages. Any
ideas? I'm using Excel 2002. Thanks!

That worked great!! Hadn't thought of that. Pays to think outside the box
(or inside as this case may be). Thanks!

"bakes1" wrote:


Place your comments in a text box instead. Then in the properties of
the text box, uncheck the "print object" option. A text box can be
inserted into your spreadsheet from the "Drawing" toolbar, under
Views/Toolbars.


--
bakes1
------------------------------------------------------------------------
bakes1's Profile: http://www.excelforum.com/member.php...o&userid=31965
View this thread: http://www.excelforum.com/showthread...hreadid=517945