From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Control gridlines: Change colors, turn them on/off, and assign to a macro button

Control gridlines: Change colors, turn them on/off, and assign to a macro button - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Control gridlines: Change colors, turn them on/off, and assign to a macro button

“

- [Instructor] The standard view of worksheets in Excel is to have grid lines present but maybe you don't want them sometimes, and it might be a situation also where you want to turn them on and off at different times, somewhat rapidly even. We control grid lines by going to the view tab in the ribbon, and there's the button for grid lines. We'll uncheck it, we have no grid lines and this is worksheet wide. Click it again, they're back on throughout the entire worksheet. Now, if you use that feature often there are a couple of shortcuts. Any button in the ribbon menu system can also exist in what we call the quick access toolbar. Typically it appears at the top of your screen, it also can appear below the menu system but by right clicking grid lines we have the option add to quick access toolbar, and there it appears at the top of the screen. So whether we're working with features on the home tab or the data tab or…

Contents