Excel trouble shooting - no gridlines

Gridlines not showing up even though checked in page set up. Any clues?
Office XP.

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Stumped" <Stumped@discussions.microsoft.com> wrote in message
news:A38D59FD-4DED-4C23-9F89-76BF465CE2A7@microsoft.com...
> Gridlines not showing up even though checked in page set up. Any clues?
> Office XP.

You might also goto Tools, Options, View, and check "gridlines".

"Stumped" wrote:

> Gridlines not showing up even though checked in page set up. Any clues?
> Office XP.

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

On Mon, 10 Jan 2005 11:55:03 -0800, "Stumped"
<Stumped@discussions.microsoft.com> wrote:

>Gridlines not showing up even though checked in page set up. Any clues?
>Office XP.

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????

"Ken Wright" wrote:

> Select the entire sheet and change the white fill colour to 'no fill'. That
> or the gridlines have been formatted to white.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> "Stumped" <Stumped@discussions.microsoft.com> wrote in message
> news:A38D59FD-4DED-4C23-9F89-76BF465CE2A7@microsoft.com...
> > Gridlines not showing up even though checked in page set up. Any clues?
> > Office XP.
>
>
>

I did check this and gridlines were checked here as well. Another clue??

"Gord Dibben" wrote:

> 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
>
> On Mon, 10 Jan 2005 11:55:03 -0800, "Stumped"
> <Stumped@discussions.microsoft.com> wrote:
>
> >Gridlines not showing up even though checked in page set up. Any clues?
> >Office XP.
>
>

Format / cells / pattern tab / select no fill option

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"stumped" <stumped@discussions.microsoft.com> wrote in message
news:B2C08488-86BF-48D8-8C43-56E963D85F4B@microsoft.com...
> 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????
>
> "Ken Wright" wrote:
>
> > Select the entire sheet and change the white fill colour to 'no fill'.
That
> > or the gridlines have been formatted to white.
> >
> > --
> > Regards
> > Ken....................... Microsoft MVP - Excel
> > Sys Spec - Win XP Pro / XL 97/00/02/03
> >
>
> --------------------------------------------------------------------------
--
> > It's easier to beg forgiveness than ask permission :-)
>
> --------------------------------------------------------------------------
--
> >
> > "Stumped" <Stumped@discussions.microsoft.com> wrote in message
> > news:A38D59FD-4DED-4C23-9F89-76BF465CE2A7@microsoft.com...
> > > Gridlines not showing up even though checked in page set up. Any
clues?
> > > Office XP.
> >
> >
> >

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?


"Ken Wright" wrote:

> Format / cells / pattern tab / select no fill option
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> "stumped" <stumped@discussions.microsoft.com> wrote in message
> news:B2C08488-86BF-48D8-8C43-56E963D85F4B@microsoft.com...
> > 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????
> >
> > "Ken Wright" wrote:
> >
> > > Select the entire sheet and change the white fill colour to 'no fill'.
> That
> > > or the gridlines have been formatted to white.
> > >
> > > --
> > > Regards
> > > Ken....................... Microsoft MVP - Excel
> > > Sys Spec - Win XP Pro / XL 97/00/02/03
> > >
> >
> > --------------------------------------------------------------------------
> --
> > > It's easier to beg forgiveness than ask permission :-)
> >
> > --------------------------------------------------------------------------
> --
> > >
> > > "Stumped" <Stumped@discussions.microsoft.com> wrote in message
> > > news:A38D59FD-4DED-4C23-9F89-76BF465CE2A7@microsoft.com...
> > > > Gridlines not showing up even though checked in page set up. Any
> clues?
> > > > Office XP.
> > >
> > >
> > >
>
>
>

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?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

<snip>

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

ctrl-a (twice in xl2003)



stumped wrote:
>
> 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?
>
> "Ken Wright" wrote:
>
> > Format / cells / pattern tab / select no fill option
> >
> > --
> > Regards
> > Ken....................... Microsoft MVP - Excel
> > Sys Spec - Win XP Pro / XL 97/00/02/03
> >
> > ----------------------------------------------------------------------------
> > It's easier to beg forgiveness than ask permission :-)
> > ----------------------------------------------------------------------------
> >
> > "stumped" <stumped@discussions.microsoft.com> wrote in message
> > news:B2C08488-86BF-48D8-8C43-56E963D85F4B@microsoft.com...
> > > 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????
> > >
> > > "Ken Wright" wrote:
> > >
> > > > Select the entire sheet and change the white fill colour to 'no fill'.
> > That
> > > > or the gridlines have been formatted to white.
> > > >
> > > > --
> > > > Regards
> > > > Ken....................... Microsoft MVP - Excel
> > > > Sys Spec - Win XP Pro / XL 97/00/02/03
> > > >
> > >
> > > --------------------------------------------------------------------------
> > --
> > > > It's easier to beg forgiveness than ask permission :-)
> > >
> > > --------------------------------------------------------------------------
> > --
> > > >
> > > > "Stumped" <Stumped@discussions.microsoft.com> wrote in message
> > > > news:A38D59FD-4DED-4C23-9F89-76BF465CE2A7@microsoft.com...
> > > > > Gridlines not showing up even though checked in page set up. Any
> > clues?
> > > > > Office XP.
> > > >
> > > >
> > > >
> >
> >
> >

--

Dave Peterson

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!

"Ken Wright" wrote:

> 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?
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> <snip>
>
>
>

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
news:OEwAze29EHA.3592@TK2MSFTNGP09.phx.gbl...
> 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?
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> --------------------------------------------------------------------------
--
> It's easier to beg forgiveness than ask permission :-)
> --------------------------------------------------------------------------
--
>
> <snip>
>
>