#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 109
Default Highlighted Cells

Dear all,

Having prepared a pro forma spreadsheet I would like to highlight the cells
that require data input. Is there a way in which I can format these cells
such that the they appear highlighted on screen but not when the spreadsheet
is printed?

Thanks in advance.


Regards,

Neil
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Highlighted Cells

Hello Neil,

One of the solutions that you might want to consider is to print your
spreadsheet in Black and White. To do this in Excel you have to go to Page
Setup Sheet Tab and check the Black and White option under print.

Another thing, why not use comments in order to indicate which cells require
data input? As of experience they don't print unless you specified to print
comments on the page setup.

Hope this one helps!
--
Chester C. Coronel
Junior BSIT Student
University of Asia and the Pacific, Philippines
http://msforums.ph/blogs/chestercoronel


"Neil Pearce" wrote:

Dear all,

Having prepared a pro forma spreadsheet I would like to highlight the cells
that require data input. Is there a way in which I can format these cells
such that the they appear highlighted on screen but not when the spreadsheet
is printed?

Thanks in advance.


Regards,

Neil

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What can be done with highlighted cells? jimplace Excel Discussion (Misc queries) 1 December 27th 06 12:27 AM
Sum Highlighted Cells Jenny Excel Discussion (Misc queries) 3 June 27th 06 11:02 PM
Cells get automatically highlighted Sand Dunes Excel Discussion (Misc queries) 2 April 1st 06 05:59 PM
highlighted cells Caveman Excel Discussion (Misc queries) 1 December 12th 05 08:05 PM
Why aren't my cells highlighted when I select multiple cells? TChristian Setting up and Configuration of Excel 0 January 26th 05 10:23 PM


All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"