Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default shading and patterns

The shading and patterns added to my worksheet do not appear on the
worksheet. They do appear in the view mode. How can I have patterns
displayed on the worksheet itself?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,344
Default shading and patterns

Hi,
Patterns and shading work fine on my machine -

1. What version of Excel are you using?
2. When you say they don't appear in the worksheet but do in the View mode,
what exactly do you mean. What view mode - Normal, Page Layout, Page Break
Preview, Print Preview, Full Screen?
3. When you apply a pattern are you also applying a color different from the
Fill color?
4. What is the Zoom factor on your screen? 10%? 400%?, 100%?

--
Thanks,
Shane Devenshire


"Jude8761" wrote:

The shading and patterns added to my worksheet do not appear on the
worksheet. They do appear in the view mode. How can I have patterns
displayed on the worksheet itself?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default shading and patterns

Hi Shane,
I am using Excel in Office 2003, I don't know how to determine my zoom
factor. I did not zoom in or out, just normal.
I am trying to shade certain cells in my spreadsheet. The shading does not
appear on the spreadsheet but is seen when I do a preview of the page or if I
do a print preview.

Judy

"ShaneDevenshire" wrote:

Hi,
Patterns and shading work fine on my machine -

1. What version of Excel are you using?
2. When you say they don't appear in the worksheet but do in the View mode,
what exactly do you mean. What view mode - Normal, Page Layout, Page Break
Preview, Print Preview, Full Screen?
3. When you apply a pattern are you also applying a color different from the
Fill color?
4. What is the Zoom factor on your screen? 10%? 400%?, 100%?

--
Thanks,
Shane Devenshire


"Jude8761" wrote:

The shading and patterns added to my worksheet do not appear on the
worksheet. They do appear in the view mode. How can I have patterns
displayed on the worksheet itself?

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default shading and patterns

Check this out................

http://support.microsoft.com/default.aspx?kbid=833258

The fill color, the fill pattern, or the line color of a WordArt or
AutoShape object in an Office document does not change

As directed, change the High Contrast setting in Windows OS


Gord Dibben MS Excel MVP

On Sat, 9 Feb 2008 10:36:01 -0800, Jude8761
wrote:

Hi Shane,
I am using Excel in Office 2003, I don't know how to determine my zoom
factor. I did not zoom in or out, just normal.
I am trying to shade certain cells in my spreadsheet. The shading does not
appear on the spreadsheet but is seen when I do a preview of the page or if I
do a print preview.

Judy

"ShaneDevenshire" wrote:

Hi,
Patterns and shading work fine on my machine -

1. What version of Excel are you using?
2. When you say they don't appear in the worksheet but do in the View mode,
what exactly do you mean. What view mode - Normal, Page Layout, Page Break
Preview, Print Preview, Full Screen?
3. When you apply a pattern are you also applying a color different from the
Fill color?
4. What is the Zoom factor on your screen? 10%? 400%?, 100%?

--
Thanks,
Shane Devenshire


"Jude8761" wrote:

The shading and patterns added to my worksheet do not appear on the
worksheet. They do appear in the view mode. How can I have patterns
displayed on the worksheet itself?


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
Cell shading with colored patterns Eric Excel Discussion (Misc queries) 2 November 16th 06 07:06 PM
Patterns tab tomKey Excel Discussion (Misc queries) 5 November 1st 06 08:33 PM
Conditional Cell Shading (based on the shading of other cells) Tubby Excel Worksheet Functions 2 June 20th 06 10:03 PM
shading a rowwhen a time is entered but no shading when 0 is enter fomula problems Excel Worksheet Functions 7 October 23rd 05 08:44 PM
patterns DArinello Excel Worksheet Functions 4 July 27th 05 05:28 AM


All times are GMT +1. The time now is 07:11 AM.

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

About Us

"It's about Microsoft Excel"