Look Who it Was Random video

Excel - Master Excel Gridlines: Quick Tips for Excel 2003 and 2007 | MrExcel Tutorial - Episode 775

2,673 views · Published 30 January 2009 · 3:25 · Indexed 26 October 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Master Excel Gridlines: Quick Tips for Excel 2003 and 2007 | MrExcel Tutorial.

Welcome back to the MrExcel netcast! In today's episode, we have a couple of quick tips that came from Al, who attended one of my seminars at the boot camp in Dallas. The first tip is specifically for Excel 2003 users and it involves the forms toolbar. Did you know that there is a button called "Toggle Grid" in the lower left-hand corner of the toolbar? This button not only helps with drawing on-sheet controls, but it can also be used to hide gridlines in a worksheet with just one click. No more going through multiple clicks in the options menu. And the best part? You can easily add this button to any toolbar by holding down CONTROL and ALT and dragging it to your desired location. It's that simple!

Now, for those of you using Excel 2007, you may have noticed that the "Toggle Grid" button is nowhere to be found. But don't worry, Microsoft has made it easier for us. Simply go to the PAGE LAYOUT tab and you'll find a checkbox to turn gridlines on or off. However, if you prefer the single click option, there is an icon called "Show/Hide" that allows you to choose whether you want to show gridlines or the formula bar. It may be two clicks instead of one, but it's still a handy tool to have.

Moving on to our second tip, did you know that you can quickly navigate between multiple worksheets using CONTROL+PAGEDOWN and CONTROL+PAGEUP? But here's the cool part - if you have a really long worksheet and need to move across it, simply use ALT+PAGEDOWN to move one screen fold to the right. This is a great way to quickly navigate through a wide spreadsheet without having to scroll endlessly. And of course, you can use ALT+PAGEUP to go back to the left.

So there you have it, two handy tips to make your Excel experience even smoother. Don't forget to add the "Toggle Grid" button to your toolbar and use ALT+PAGEDOWN to navigate through your worksheets. Thanks for tuning in to another netcast from MrExcel. See you next time for more helpful tips and tricks!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


In Excel 2003, there is a cool button lurking in the Forms toolbar. This button gives you one click access to show/hide gridlines. I am not a big fan of hiding gridlines, but when it is only one click away, I find myself actually doing so. Also, another tip about using PgDn and PgUp to move between worksheets or between screenfuls of columns. Episode 775 shows you how.

Table of Contents:
(00:00) Introduction
(00:16) Quick Tips from Al
(00:26) Tip 1: Toggle Gridlines in Excel 2003
(01:03) Adding the Toggle Grid Button to a Toolbar
(01:13) Alternative Method: Customizing Toolbars
(01:39) Excel 2007: Using the Page Layout Tab
(01:57) Bonus Tip: Using the Show/Hide Icon
(02:16) Tip 2: Navigating Across a Worksheet
(02:48) Using ALT+PAGEDOWN and ALT+PAGEUP
(03:03) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Alt+Pagedown to move across a worksheet in Excel
Control+Pagedown shortcut in Excel
Customize Excel toolbar
Excel 2003 forms toolbar
Excel tips and tricks
Hiding gridlines in Excel
How to add buttons to Excel toolbar
Page layout tab in Excel 2007
Quick navigation between worksheets in Excel
Show/hide dropdown in Excel 2007
Toggle gridlines in Excel
Turn off gridlines in Excel 2007


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152117/

More from this channel