ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Getting rid of gridlines (https://www.excelbanter.com/excel-discussion-misc-queries/101620-getting-rid-gridlines.html)

Geoff

Getting rid of gridlines
 
Is there any way that I can set it up so that when I open a new worksheet, or
insert one into an existing workbook, that the gridlines are turned off.

FSt1

Getting rid of gridlines
 
hi,
toolsoptionsview tab
uncheck gridlines.

regards
FSt1

"Geoff" wrote:

Is there any way that I can set it up so that when I open a new worksheet, or
insert one into an existing workbook, that the gridlines are turned off.


Geoff

Getting rid of gridlines
 
Thanks, but I was thinking rather of a way to make "gridlines off" the
default. I generally don't use them and turn them off about 90% of the time.

"FSt1" wrote:

hi,
toolsoptionsview tab
uncheck gridlines.

regards
FSt1

"Geoff" wrote:

Is there any way that I can set it up so that when I open a new worksheet, or
insert one into an existing workbook, that the gridlines are turned off.


Dave Peterson

Getting rid of gridlines
 
A few options....an icon on your favorite toolbar is nice for those workbooks
inherited from others.

http://groups.google.com/groups?selm...6324%40msn.com

Geoff wrote:

Is there any way that I can set it up so that when I open a new worksheet, or
insert one into an existing workbook, that the gridlines are turned off.


--

Dave Peterson


All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com