Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ian40Ian
 
Posts: n/a
Default how do i turn off the gridlines

Could anyone please tell me how to turn the gridlines off on my spreadsheet,
I know it can be done I just cant work out how Thanx very much....Ian
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

To turn off the gridlines, choose ToolsOptions
On the View tab, under Window options, remove the
checkmark from Gridlines
Click OK

You can also add a button to your toolbar, to make it easier to hide or
show the gridlines.

Choose ToolsCustomize
Select the Commands tab
From the Categories list, select Forms
Scroll down through the list of commands, to find 'Toggle Grid'
Drag the Toggle Grid button to one of your existing toolbars
Click the Close button.

Click the Toggle Grid button when you want to hide or show the gridlines



Ian40Ian wrote:
Could anyone please tell me how to turn the gridlines off on my spreadsheet,
I know it can be done I just cant work out how Thanx very much....Ian



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
gridlines Sewells Excel Worksheet Functions 1 February 15th 05 10:59 PM
How do you add gridlines? greenwood Excel Worksheet Functions 1 January 14th 05 08:21 PM
How to display gridlines at irregular intervals? Jason Weiss Charts and Charting in Excel 2 January 3rd 05 07:30 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM
re-install gridlines Janice Excel Worksheet Functions 0 November 11th 04 03:24 PM


All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"