cell color problems - Excel 97

S

Spoon2001

After changing my Windows color scheme, I discovered that all the cells in
one of my spreadsheet were the background color. I wanted to restore them
to a white background. Strangely enough, only one existing spreadsheet is
effected; new spreadsheets have the default white color.

I tried all Format Cells options to restore a white color. This worked ok,
but I could no longer see gridlines displayed even though Tools / Options /
View tab / Gridlines box is checked.

Finally, I used Format / Auto Fomrat / None. This restored my gridlines but
to my amazement, my spreadsheet ballooned from 500K to 108MB. Task Manager
showed Excel using 440MB of memory and my system slowed to a crawl.

I restored a backup copy of the spreadsheet. It is now back down to 500K
but all my cells have a beige background again.

any ideas to help me get a white background back, with gridlines?
 
P

Peo Sjoblom

Use no fill colour instead for white colour, you will never see grid lines
if you have a fill colour


--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top