#1   Report Post  
Jeff
 
Posts: n/a
Default Shading Cells

When I highlight the cells on the spreadsheet and change the shading (color)
it will not appear on the screen. When it is printed out however, it prints
the shaded areas.

Can someone tell me how to correct this so I can see the shading on screen?
  #2   Report Post  
SabrinaN
 
Posts: n/a
Default

If you right click on the highlighted cells, choose Format Cells, then click
on the Patterns tab. Once you choose the color, click OK, and the color
should automatically appear on the sheet. Either that, or highlight your
cells, then choose Format from the menu bar, and then choose Cells. Once
you've chosen your color, again, it should appear on the sheet.
These are the most common way to shade cells, but if you are using a
different method, try this one and see if it works.
If the problem still exists, you may have formatted your cell color in
another way that does not allow you to see the shading.

"Jeff" wrote:

When I highlight the cells on the spreadsheet and change the shading (color)
it will not appear on the screen. When it is printed out however, it prints
the shaded areas.

Can someone tell me how to correct this so I can see the shading on screen?

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
When shading cells using the 'pattern' option, they print in grey. Todd Excel Discussion (Misc queries) 0 March 11th 05 07:37 PM
Blink a cell's shading dharris Excel Discussion (Misc queries) 1 January 26th 05 11:05 PM
Help adding text values Texas-DC_271 Excel Worksheet Functions 7 January 16th 05 12:14 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM


All times are GMT +1. The time now is 06:06 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"