Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
When shading cells using the 'pattern' option, they print in grey. | Excel Discussion (Misc queries) | |||
Blink a cell's shading | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |