Mark specific cells
with large sheets, there can be are many cells that need weekly or monthly updating.
these can be formatted differently to identify them, but that does not look good in print or reporting.
So, like the red comments triangles, or the green attention triangle, it would be great if a label could be put to a cell, preferably like a vertical colored bar on the left side of the cell, that would not be printed. This way, it is always clear which cells need to be updated.
Inayat ullah Khan commented
How to find specific text (like name, date etc) in a worksheet
Yeah, gotta say it would be nice. I've always had to use workarounds like coloring (Lord... ok... "filling") the cells for input light yellow, but then the printing... (Sigh...)
Yeah, "proper practice" and all... but people (bosses especially) don't seem to like going from the page they see the nice output on to a different one to enter some data, then back to see it, then go back to enter or change data. So they don't do it and don't care to be lectured on how "they are wrong."
I even tried setting up Ranges that cycle between data entry cells (though be sure to put the cell you want landed on first when they Ctrl-G (go to) LAST in the Range — weird Windows issue it seems — or the landing spot will be the last cell in the set of cells you put in the Range.
But same thing: they always want to add a bit, then see the current values, then go back to adding. Even when that's useless! And hated being dropped back on the Range's landing cell and having to cycle back and forth with Enter for further addng or changing. And the moment they mouse or hit an arrow key...
Data entry boxes that float above the output page...
It's got to be solvable at the program level. Maybe a new type of conditional formatting, one that you set and it marks the data entry cells, but only to the monitor (intercepting the data stream headed to a monitor, but does not intercept anything going to a printer). Something...
That might get confusing.... I would prefer very distinct marking of cells like in Outook with categories.
Or, more generically what about having non-printing options for formatting on cells? Or being able to set two formats for each cell, one for printing and one for the screen?
Generally it is better to separate input sheets from output sheets, which avoids the problem although this is not alway,s practical and adds to maintenance issues.