How to create sheet without gridlines?
 

Many times, I see the excel sheets prepared by others which do not contain
Gridlines. In these sheets the Gridlines option in ToolsOptionsViewWindows
Options is also enabled. Gridline colour is also Automatic. There is no sheet
background as well. Can anybody tell how to create such sheets?

How to create sheet without gridlines?
 

Sandeep Parkhi wrote:
Many times, I see the excel sheets prepared by others which do not contain
Gridlines. In these sheets the Gridlines option in ToolsOptionsViewWindows
Options is also enabled. Gridline colour is also Automatic. There is no sheet
background as well. Can anybody tell how to create such sheets?

Cells have a white fill.

Ken Johnson

How to create sheet without gridlines?
 

And what a waste when you can turn gridlines off!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ken Johnson" wrote in message
ps.com...

Sandeep Parkhi wrote:
Many times, I see the excel sheets prepared by others which do not
contain
Gridlines. In these sheets the Gridlines option in
ToolsOptionsViewWindows
Options is also enabled. Gridline colour is also Automatic. There is no
sheet
background as well. Can anybody tell how to create such sheets?

Cells have a white fill.

Ken Johnson

How to create sheet without gridlines?
 

Where/How is this achieved from the menu?


"Ken Johnson" wrote in message
ps.com:

Sandeep Parkhi wrote:
Many times, I see the excel sheets prepared by others which do not contain
Gridlines. In these sheets the Gridlines option in ToolsOptionsViewWindows
Options is also enabled. Gridline colour is also Automatic. There is no sheet
background as well. Can anybody tell how to create such sheets?

Cells have a white fill.

Ken Johnson

How to create sheet without gridlines?
 

Format/ Cells/ Pattern
--
David Biddulph

"JMay" wrote in message
...
Where/How is this achieved from the menu?

"Ken Johnson" wrote in message
ps.com:

Cells have a white fill.

Sandeep Parkhi wrote:
Many times, I see the excel sheets prepared by others which do not
contain
Gridlines. In these sheets the Gridlines option in
ToolsOptionsViewWindows
Options is also enabled. Gridline colour is also Automatic. There is no
sheet
background as well. Can anybody tell how to create such sheets?

How to create sheet without gridlines?
 

Thanks David, the word "Fill" was throwing me..

"David Biddulph" wrote in message
:

Format/ Cells/ Pattern
--
David Biddulph

"JMay" wrote in message
...
Where/How is this achieved from the menu?

"Ken Johnson" wrote in message
ps.com:

Cells have a white fill.

Sandeep Parkhi wrote:
Many times, I see the excel sheets prepared by others which do not
contain
Gridlines. In these sheets the Gridlines option in
ToolsOptionsViewWindows
Options is also enabled. Gridline colour is also Automatic. There is no
sheet
background as well. Can anybody tell how to create such sheets?

How to create sheet without gridlines?
 

Tools | Option; open Edit tab; in lower half (Windows Options) unselect
Gridline box
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sandeep Parkhi" <Sandeep wrote in message
...
Many times, I see the excel sheets prepared by others which do not contain
Gridlines. In these sheets the Gridlines option in
ToolsOptionsViewWindows
Options is also enabled. Gridline colour is also Automatic. There is no
sheet
background as well. Can anybody tell how to create such sheets?

How to create sheet without gridlines?
 

Thanks David. Thats the correct answer from all other posts.

"David Biddulph" wrote:

Format/ Cells/ Pattern
--
David Biddulph

"JMay" wrote in message
...
Where/How is this achieved from the menu?

"Ken Johnson" wrote in message
ps.com:

Cells have a white fill.

Sandeep Parkhi wrote:
Many times, I see the excel sheets prepared by others which do not
contain
Gridlines. In these sheets the Gridlines option in
ToolsOptionsViewWindows
Options is also enabled. Gridline colour is also Automatic. There is no
sheet
background as well. Can anybody tell how to create such sheets?

How to create sheet without gridlines?
 

Thats offcourse one of the ways of doing it but I had ruled that out in my
initial question itself. David has given me the correct answer. Thanks
anyways. This is how we keep learning.

"Bernard Liengme" wrote:

Tools | Option; open Edit tab; in lower half (Windows Options) unselect
Gridline box
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sandeep Parkhi" <Sandeep wrote in message
...
Many times, I see the excel sheets prepared by others which do not contain
Gridlines. In these sheets the Gridlines option in
ToolsOptionsViewWindows
Options is also enabled. Gridline colour is also Automatic. There is no
sheet
background as well. Can anybody tell how to create such sheets?

How to create sheet without gridlines?
 

Sandeep Parkhi wrote:
Many times, I see the excel sheets prepared by others which do not contain
Gridlines. In these sheets the Gridlines option in ToolsOptionsViewWindows
Options is also enabled. Gridline colour is also Automatic. There is no sheet
background as well. Can anybody tell how to create such sheets?

Could be PageSetup/Sheet/Gridlines is 'unchecked'.