Is there an easy way to toggle grid lines in Excel?
You’ll often want to change whether gridlines are displayed in a worksheet, but doing so is rather cumbersome. To do so, you probably select Tools, Options from the menu bar, switch to the View sheet, and change the Gridlines setting in the Window Options section. There’s a button you can use that toggles the gridlines, but it’s located on a toolbar you probably use only rarely–if at all. Fortunately, you can easily move the button to the Standard toolbar so that you always have quick access to the feature. To do so, select View, Toolbars, Forms from the menu bar. Then, while holding down the [Alt] key, drag the Toggle Grid button to the Standard toolbar. By default, the Toggle Grid button is the one that’s clicked in and is located in the lower-left corner of the floating toolbar. You can close the Forms toolbar at this point and the Toggle Grid button remains where you placed it on the Standard toolbar.