Hide Grid Lines [Quick Tip]
I like to hide grid lines on my spreadsheets and charts whenever possible. I think removing gridlines makes the charts and worksheets more presentable. In case you are wondering how to remove (or hide) gridlines,
To hide grid lines on an excel worksheet:
Excel 2007 and greater: Go to View Ribbon and uncheck the “Gridlines” option. You can also press ALT + WVG
Excel 2003 and earlier: Click on Tools > Options and then in the View tab uncheck “grid lines” option.
To hide grid lines when you are printing an excel sheet:
Excel 2007 and greater: Go to Page Layout Ribbon and uncheck the “Print” option under Gridlines area. You can also press ALT + PPG
Excel 2003 and earlier: Go to “Print Preview” and uncheck “gridlines” in “Print” tab.
To Remove grid lines from a chart:
Select the gridlines in the chart and hit delete.
What do you think about gridlines ?
Do you like them or do you try to remove then whenever you can?
Sign-up for our FREE Excel tips newsletter:
Here is a smart way to become awesome in Excel. Just signup for my FREE Excel tips newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:
Your email address is safe with us. Our policies
Leave a Reply
|Member of month, Excel links and Cooked HDD||Only 2 more days to get prizes worth $425, Hurry|