ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to make background grid lines disappear when viewing (https://www.excelbanter.com/excel-worksheet-functions/20367-how-make-background-grid-lines-disappear-when-viewing.html)

alex

How to make background grid lines disappear when viewing
 
I don't want to see the grid lines when I open up an excel worksheet. How do
I make the lines disappear, as in the templates?
Thanks.

Jennifer

ToolsOptionsView (tab) & uncheck gridlines. Hope this helps

Jennifer

"alex" wrote:

I don't want to see the grid lines when I open up an excel worksheet. How do
I make the lines disappear, as in the templates?
Thanks.


Gord Dibben

ToolsOptionsView.

Untick "gridlines".


Gord Dibben Excel MVP

On Sat, 2 Apr 2005 22:43:01 -0800, "alex"
wrote:

I don't want to see the grid lines when I open up an excel worksheet. How do
I make the lines disappear, as in the templates?
Thanks.



Gord Dibben

alex

One more suggestion.

If there are areas you do want to see gridlines but other areas where
gridlines would be preferred you can format the cells to a white pattern,
which will hide the gridlines in that area.

Also note that you can use use the formatcellsborders to outline areas.


Gord Dibben Excel MVP

On Sun, 03 Apr 2005 00:15:47 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

ToolsOptionsView.

Untick "gridlines".


Gord Dibben Excel MVP

On Sat, 2 Apr 2005 22:43:01 -0800, "alex"
wrote:

I don't want to see the grid lines when I open up an excel worksheet. How do
I make the lines disappear, as in the templates?
Thanks.




All times are GMT +1. The time now is 07:52 PM.

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