ExcelBanter - Suppress printing of row shading

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Suppress printing of row shading (https://www.excelbanter.com/excel-discussion-misc-queries/183833-suppress-printing-row-shading.html)

Bob Arnett

Suppress printing of row shading

For ease of reading on screen, I have a worksheet that shades every other
line in a light green. This emulates "green bar" paper. When I print the
sheet, I print it on "real green bar" paper so I don't want the worksheets
"green bars" to print. Is there any way to instruct Excel to NOT print these
shadings?

Jim Thomlinson

Suppress printing of row shading

File - Page Setup | Sheet Tab ... Check off Black and White
--
HTH...

Jim Thomlinson

"Bob Arnett" wrote:

For ease of reading on screen, I have a worksheet that shades every other
line in a light green. This emulates "green bar" paper. When I print the
sheet, I print it on "real green bar" paper so I don't want the worksheets
"green bars" to print. Is there any way to instruct Excel to NOT print these
shadings?

All times are GMT +1. The time now is 10:48 PM.