Nonprintable cells in Excell?
Nonprintable cells in Excell?
(OP)
Hi everybody!
I have a cell in my spreadsheet that I want to see during the work on it but not to print. What I must to do to hide it during the printing?
Thanks
Zmei
I have a cell in my spreadsheet that I want to see during the work on it but not to print. What I must to do to hide it during the printing?
Thanks
Zmei





RE: Nonprintable cells in Excell?
I, personally, would use a Command Button macro but you could also do it manually to:
Set text colour to background colour in selected cell/s
Print sheet
Set text colour back to visible.
I think that should work! - - - bjt.
RE: Nonprintable cells in Excell?
RE: Nonprintable cells in Excell?
The easiest is if you had a whole column or row you want to hide when printing. This can be done by saving views. You can save a view with specific hidden rows and columns and print areas.
For single cells here is a way to get a non-printing cell (kind of) that doesn't have to be updated with a macro (I hate having to run macros to do things).
1. You will need a cell with the data you want to be able to see somewhere on a worksheet in the nonprint area - you could just do this, but then you have to always go find that cell instead of having it right where I assume you enter data and want someone to be able to see it easily (and not forget to check it).
2. Draw a control (text box is what I use) over the cell you want the data (use alt to snap to grid).
3. When you have the text box selected you should see =embed(something) in the formula bar. Make this point to the cell containing your value. (for some reason you can link it to a cell, but not enter a formula).
4. Click the right button so the pop up menu comes up and select format picture (the text box is now a picture). On the properties menu select move and resize with cells and unselect the print object.
RE: Nonprintable cells in Excell?
In Excel, you can define a specific section of a sheet to be printable in Page Setup|Sheet|Print Area, and anything outside of that section is therefore not printed normally.
TTFN
RE: Nonprintable cells in Excell?
If select an area, then remove a cell from the middle of it and set that area with a hole as the print area, excel will print it in four chuncks (left, right, above, below the cell) on separate pages.
RE: Nonprintable cells in Excell?
Since you can operate on any cell anywhere on the sheet, couldn't you simply move the offending cell out of the print area?
TTFN
RE: Nonprintable cells in Excell?
Most of the time if one of my checks went off, it meant the report wasn't going out, so I could make a cell on the report say Error or turn red (or both).
If you have checks, they should NOT be able to be overlooked, whether it is a tech or secretary or general data entry personnel, because at some point it will be you, the engineer, rushing to get a report out, doing it yourself instead of the regular personnel (who has of course become used to scrolling over and checking that little cell), and it is going to cause a problem.