Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filled cells dont appear as filled
How do I get my cells to show up as filled on my monitor? The cells are
filled yellow and if you preview the page they are filled and if you print they are filled but they dont show as filled otherwise. What to do? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filled cells dont appear as filled
Check to see if you have high contrast turned on in windows under
startsettingscontrol panelaccessibility options -- Regards, Peo Sjoblom "SMILLS" wrote in message ... How do I get my cells to show up as filled on my monitor? The cells are filled yellow and if you preview the page they are filled and if you print they are filled but they dont show as filled otherwise. What to do? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filled cells dont appear as filled
Pressed Alt + Left shift + Print screen and that worked.
Thanks for the help "SMILLS" wrote: How do I get my cells to show up as filled on my monitor? The cells are filled yellow and if you preview the page they are filled and if you print they are filled but they dont show as filled otherwise. What to do? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filled cells dont appear as filled
Neither changing the accessibility option or the ALT + Left shift + print
screen worked for me. The data appeared the last time that I opened these document. It appears in the formula box at the top of the page, but it doesn't appear in the cell on my monitor. Also, only the data in some cells doesn't appear - I can see data in other cells. Does anyone have a clue what has caused this and more importantly how I can get all of my data to appear? -- Newbie "SMILLS" wrote: Pressed Alt + Left shift + Print screen and that worked. Thanks for the help "SMILLS" wrote: How do I get my cells to show up as filled on my monitor? The cells are filled yellow and if you preview the page they are filled and if you print they are filled but they dont show as filled otherwise. What to do? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filled cells dont appear as filled
Perhaps the cells you don't see have their font formatted to white?
If you can see the data in the formula bar but not the cell that would be my best guess. OR the cells have been custom formatted to ;;; Gord Dibben MS Excel MVP On Wed, 17 Oct 2007 15:27:00 -0700, Newbie wrote: Neither changing the accessibility option or the ALT + Left shift + print screen worked for me. The data appeared the last time that I opened these document. It appears in the formula box at the top of the page, but it doesn't appear in the cell on my monitor. Also, only the data in some cells doesn't appear - I can see data in other cells. Does anyone have a clue what has caused this and more importantly how I can get all of my data to appear? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filled cells dont appear as filled
Thanks. The white font was one of the first things I checked for. That is not
the problem. I did make sure that the cells were formatted to text. I'm not sure what formatted to ;;; is. When I opened the file today, the text appears. (Twightlight Zone) -- Newbie "Gord Dibben" wrote: Perhaps the cells you don't see have their font formatted to white? If you can see the data in the formula bar but not the cell that would be my best guess. OR the cells have been custom formatted to ;;; Gord Dibben MS Excel MVP On Wed, 17 Oct 2007 15:27:00 -0700, Newbie wrote: Neither changing the accessibility option or the ALT + Left shift + print screen worked for me. The data appeared the last time that I opened these document. It appears in the formula box at the top of the page, but it doesn't appear in the cell on my monitor. Also, only the data in some cells doesn't appear - I can see data in other cells. Does anyone have a clue what has caused this and more importantly how I can get all of my data to appear? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filled cells dont appear as filled
Glad you're sorted.
To hide the contents of a cell go to FormatCellsNumberCustom. Enter 3 semi-colons ;;; Gord On Thu, 18 Oct 2007 09:12:04 -0700, Newbie wrote: Thanks. The white font was one of the first things I checked for. That is not the problem. I did make sure that the cells were formatted to text. I'm not sure what formatted to ;;; is. When I opened the file today, the text appears. (Twightlight Zone) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filled boxes with patterns dont print | Excel Discussion (Misc queries) | |||
Want to choose last filled line, but dont know how? | Excel Worksheet Functions | |||
how use range to bottom of filled cells? | Excel Worksheet Functions | |||
Percentage of filled cells | Excel Worksheet Functions | |||
Count Rang of Filled-In Cells | Excel Worksheet Functions |