Excel Bad Habit #14: Filling Cells with White Instead of Turning Off Gridlines
Sometimes, you may want to remove the gridlines from your Excel sheet to have a simple white background.
Often, people will accomplish this by selecting all and then formatting the cells with a white fill.
Why is this the wrong way? Because it erases any colored fill that already exists in the sheet.
You can find a better way to remove the gridlines on the View tab of the Ribbon. As you can see, there's a checkbox for Gridlines that you can check or uncheck to turn the gridlines on or off.
The gridlines are turned off for the sheet that is currently selected, not the entire workbook. You can choose to turn the gridlines on or off for EACH sheet.
The keyboard shortcut to toggle the gridlines on or off in Windows is Alt + W V G.
What's your favorite Excel tip or shortcut? Let me know in the comments.