Need worksheet view without cell lines

Wanda

unread,

Jun 9, 2003, 2:35:53 PM6/9/03

to

How do you remove the cell lines that appear on all Excel
worksheets? I'm not talking abouit the borders that you
can add & remove for selected cells. I want my worksheet
to appear like a "blank" piece of white paper as I am
entering data.

Bob Phillips

unread,

Jun 9, 2003, 2:49:56 PM6/9/03

to

Tools>Options on the View tab, uncheck the Gridlines box.

--

HTH

Bob Phillips

"Wanda" <wnie...@cox.net> wrote in message
news:02fc01c32eb5$f5709420$a301...@phx.gbl...

Peo Sjoblom

unread,

Jun 9, 2003, 2:57:15 PM6/9/03

to

Click the select all button above row 1 header and to the left of column A,
(or press ctrl + A), do format>cells>patterns and select white from the
palette,
click OK.

--

Regards,

Peo Sjoblom

"Wanda" <wnie...@cox.net> wrote in message
news:02fc01c32eb5$f5709420$a301...@phx.gbl...

Peo Sjoblom

unread,

Jun 9, 2003, 3:04:33 PM6/9/03

to

Oops! Forgot about that one <embarrassed grin>

--

Regards,

Peo Sjoblom

"Bob Phillips" <bob.ph...@tiscali.co.uk> wrote in message
news:e2MUsfrL...@tk2msftngp13.phx.gbl...

pfsar...@yahoo.com

unread,

Jun 9, 2003, 3:08:54 PM6/9/03

to

Tool>Options>View Tab.
Remove checkmark from Gridlines

Paul

-------------------------------------------------------

Dave Peterson

unread,

Jun 9, 2003, 7:01:52 PM6/9/03

to

And a couple more options. Let the gridlines show up on the worksheet, but add
a button to your favorite toolbar that toggles them on/off.

Tools|Customize|Commands Tab|Forms Category
Drag the "toggle grid" icon to your favorite toolbar.

I have "insert worksheet" right next to the toggle grid icon
Tools|Customize|Commands Tab|Insert Category
Drag the Worksheet icon right next to it.

Insert a new worksheet--click on one icon, then click on the next to turn off
grid lines.

====
If you're comfortable playing in the windows registry, you can turn it off via a
registry setting.

Run Regedit.exe from Start->Run.
Navigate to:

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options
or
HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options
or
HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\Microsoft Excel

depending on your Excel version. Find the Options3 item in the right pane
and edit it to add 4000 to it. Say if it's now 40, make it 4040 (this is
all in hex). Do this with Excel closed and when you re-open it new
worksheets should not show gridlines.

(I think stolen from a Jim Rech post.)

=======
And finally, if you save two workbooks in your xlstart folder, you can base new
workbooks/worksheets on these templates.

Call one Book.xlt and the other sheet.xlt.

I created one called book.xlt (one worksheet, no gridlines, portrait,
headers/footers the way I wanted.)

Saved it as book.xlt in my XLStart folder and then used windows explorer to make
a copy of it. Then I renamed the copy to sheet.xlt.

--

Dave Peterson
ec3...@msn.com

Darren Fall

unread,

Jun 10, 2003, 1:30:55 AM6/10/03

to

Wanda,

All you need to do is go into "Tools - Options" menu and
then click on "Gridlines" near the bottom of the box.
This will clear gridlines from the screen and you'll be
left with a blank sheet.

>.
>