Excel trouble shooting - no gridlines

K

Ken Wright

Select the entire sheet and change the white fill colour to 'no fill'. That
or the gridlines have been formatted to white.
 
G

Gord Dibben

Stumped

Tools>Options>View. Checkmark "Gridlines" in Windows Options section.

Or see Ken's post for background color.

Checking gridlines in Page Setup is only for formatting the printed page, not
the sheet itself.


Gord Dibben Excel MVP
 
S

stumped

I have "checked" gridlines in the sheet page set up. I don't know where to
find the colour fill option - tried each tool bar tab and could not find
this????
 
S

stumped

I did this. In the color box, it's autopopulated with "no color". When I
click the pattern box, it drops down a box with color and pattern options. I
don't see a "no fill" option to try. I did try clicking on the bland/white
"color" option - but that didn't work. Anything else?
 
K

Ken Wright

LOL - This is the point where I say send me a copy of the file if you can
because it's bugging me now :). Need to take the NOSPAM out of my email
addy if you do.

Just out of interest, this isn't an old Lotus 123 file that has been
converted to Excel is it?
 
D

Dave Peterson

Are you sure you selected all the cells on the worksheet first?

ctrl-a (twice in xl2003)
 
S

stumped

Nope - not a Lotus notes file. I was doing some more budget work today using
all 3 sheets in the workbook, and in each hitting "gridlines" in page set-up.
It worked just fine in sheet 1, but doesn't work in sheet 2. Very weird. I
even tried rebooting, turning the maching off/on, etc. Just too weird.
Thanks for your help and thoughts, however - I keep trying all of them!
 
K

Ken Wright

You did use Mike's response yes - Tools / Options / View / Gridlines - on
each sheet
 
Top