Why do gridlines not print in Excel spreadsheet?

I tried to format a new spreadsheet to print gridlines on all cells with page
setup. When I then click on Print Preview, gridlines do not show.

Yes.

"davesexcel" wrote:

>
> grid lines should show around the data, have you data in the
> spreadsheet?
>
>
> --
> davesexcel
>
>
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=563970
>
>

You have to have data on your sheet. Look in Tools/Options/View Tab. At
the bottom you have window options. Make sure gridlines is checked. It
will still print the gridlines if you set the Print properties to print
gridlines but you won't see them in your edit view.

Linda

"Office Newbie" <Office [email protected]> wrote in message
news:[email protected]...
>I tried to format a new spreadsheet to print gridlines on all cells with
>page
> setup. When I then click on Print Preview, gridlines do not show.

Is Draft Quality checked in Page Setup Sheet? Uncheck if it is.


Gord Dibben MS Excel MVP

On Sat, 22 Jul 2006 05:29:02 -0700, Office Newbie <Office
[email protected]> wrote:

>I tried to format a new spreadsheet to print gridlines on all cells with page
>setup. When I then click on Print Preview, gridlines do not show.

Yes. This solved my problem. Thanks to all

"Gord Dibben" wrote:

> Is Draft Quality checked in Page Setup Sheet? Uncheck if it is.
>
>
> Gord Dibben MS Excel MVP
>
> On Sat, 22 Jul 2006 05:29:02 -0700, Office Newbie <Office
> [email protected]> wrote:
>
> >I tried to format a new spreadsheet to print gridlines on all cells with page
> >setup. When I then click on Print Preview, gridlines do not show.
>
>