ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Non Prinatble fill (https://www.excelbanter.com/excel-worksheet-functions/201075-non-prinatble-fill.html)

Levon

Non Prinatble fill
 
I need to make a form for people to fill in. I want to either highlight the
fillable areas or black out everything but the fillable form areas. I do not
want this highlight or blackout to print out on the final printout though.
Any ideas?

Gord Dibben

Non Prinatble fill
 
Select the cells to fill-in and give them a distinctive background color.

ToolsOptionsView.........uncheck gridlines.

After your users do the fill-in of the colored cells and before you print go
to FilePage SetupSheet and select "Black and White".


Gord Dibben MS Excel MVP

On Tue, 2 Sep 2008 14:36:25 -0700, Levon
wrote:

I need to make a form for people to fill in. I want to either highlight the
fillable areas or black out everything but the fillable form areas. I do not
want this highlight or blackout to print out on the final printout though.
Any ideas?




All times are GMT +1. The time now is 02:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com