|
|
| Author |
Message |
Adurr
Guest
|
 Posted: Thu May 10, 2007 4:25 pm Post subject: Black Cell in Excel |
 |
|
I have an Excel spreadsheet with 1,082 rows. Row number 584 is black with
white lettering. It is not a border or fill color and I have been unable to
remove the shading. Does anyone know how to fix this without doing a paste
special (which does not work in this workbook, but if I open a new one it
does) or what has caused it? |
|
| Back to top |
|
 |
Fix your Windows Problems - FAST.
FREE Safe Scan Registry Check. Locate & Fix Errors in Minutes!
|
|
bxb7668
Guest
|
| Posted: Thu May 10, 2007 4:26 pm Post subject: Re: Black Cell in Excel |
|
|
Have you checked to see if that row has any conditional formatting? To
check, select a cell in the row and then open the menu item Format >
Conditional Formatting. If it does, highlight the entire row and go
back into Conditional Formatting. Select the Delete button and check
all three rules.
Brian Bygland
"Adurr" <Adurr@discussions.microsoft.com> wrote in message
news:35592F41-DBF7-4F34-9126-957CF0CBAF4B@microsoft.com...
| Quote: | I have an Excel spreadsheet with 1,082 rows. Row number 584 is black
with
white lettering. It is not a border or fill color and I have been
unable to
remove the shading. Does anyone know how to fix this without doing
a paste
special (which does not work in this workbook, but if I open a new
one it
does) or what has caused it? |
|
|
| Back to top |
|
|
Adurr
Guest
|
| Posted: Thu May 10, 2007 4:26 pm Post subject: Re: Black Cell in Excel |
|
|
That was it, thank you so much
"bxb7668" wrote:
| Quote: | Have you checked to see if that row has any conditional formatting? To
check, select a cell in the row and then open the menu item Format
Conditional Formatting. If it does, highlight the entire row and go
back into Conditional Formatting. Select the Delete button and check
all three rules.
Brian Bygland
"Adurr" <Adurr@discussions.microsoft.com> wrote in message
news:35592F41-DBF7-4F34-9126-957CF0CBAF4B@microsoft.com...
I have an Excel spreadsheet with 1,082 rows. Row number 584 is black
with
white lettering. It is not a border or fill color and I have been
unable to
remove the shading. Does anyone know how to fix this without doing
a paste
special (which does not work in this workbook, but if I open a new
one it
does) or what has caused it?
|
|
|
| Back to top |
|
|
|
Watched Topics
Search
Register
Log in to check your private messages
Profile
Log in
Memberlist
Usergroups