Written by Allen Wyatt (last updated May 10, 2025)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, 2021, 2024, and Excel in Microsoft 365
Most people using Excel leave the gridlines visible so that they can easily see where the various cells are. By default, the gridlines are a light gray. You can easily change the gridlines to a different color by following these steps:
Figure 1. The Advanced options of the Excel Options dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6210) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, 2021, 2024, and Excel in Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: Changing the Color of Worksheet Gridlines.
Best-Selling VBA Tutorial for Beginners Take your Excel knowledge to the next level. With a little background in VBA programming, you can go well beyond basic spreadsheets and functions. Use macros to reduce errors, save time, and integrate with other Microsoft applications. Fully updated for the latest version of Office 365. Check out Microsoft 365 Excel VBA Programming For Dummies today!
Need to create a large number of worksheets using specific names? If so, you'll love the ideas presented in this tip.
Discover MoreNeed to make a copy of one of your worksheets? Excel provides a few different ways you can accomplish the task.
Discover MoreExcel, by default, recalculates your worksheets as you make changes in those worksheets. If you want to limit the number ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2025-06-05 19:23:35
Kevin H
On Mac, this is under Excel > Preferences > View
2025-05-12 05:02:35
DaveS
@Ray
Two ways of doing that are:
(i) Under the Borders dropdown (Home tab of the ribbon), select Draw Border Grid, then select the range of cells you want and it infills the borders. Default is black but if you select Line color first to set another colour.
(ii) Select the range of cells and then under the Format dropdown (Home tab of the ribbon) select Format Cells to open the Format Cells dialog, and then select the Border tab on the dialog. This approach enables whole rows or columns to be selected whereas I think (i) only works on blocks of cells.
2025-05-10 06:36:20
Ray McAllister
Can I change the color of grid lines in different parts. Of a worksheet? That is, can I make grid lines red for some rows (or columns) and blue for others?
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments