G
Guest
Gridlines not showing up even though checked in page set up. Any clues?
Office XP.
Office XP.
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.
or the gridlines have been formatted to white.
G
Guest
You might also goto Tools, Options, View, and check "gridlines".
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
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
G
Guest
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????
find the colour fill option - tried each tool bar tab and could not find
this????
G
Guest
I did check this and gridlines were checked here as well. Another clue??
K
Ken Wright
Format / cells / pattern tab / select no fill option
G
Guest
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?
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?
because it's bugging me now
. Need to take the NOSPAM out of my emailaddy 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)
ctrl-a (twice in xl2003)
G
Guest
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!
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
each sheet