Office for Mac Issues

Fix Gray Cells When Selecting a Cell in Excel for Mac

Rana GarciaRana Garcia Nov 20, 2026 868 views

Question details

Determine why multiple cells or rows appear gray when a single cell is selected in Excel for Mac.

Fix Gray Cells When Selecting a Cell in Excel for Mac
Product
Microsoft Excel for Mac
Device & OS
macOS; version not provided
Scenario
A user selects a cell in an Excel workbook, possibly created from a template, after an Office update.
Observed behavior
Multiple rows or cells appear gray when one cell is selected.
Before you start

Open the affected workbook and note whether the gray appearance occurs on every sheet or only in one template-based workbook. Have a screenshot ready that shows the selected cell and the gray area.

Solution 1Recommended

Test the Gray Cell Behavior in a New Excel Workbook

Use a blank workbook to determine whether the issue is specific to the affected file or template.

1
Create a blank workbook

In Excel, select File > New and open a blank workbook.

2
Test cell selection

Click individual cells in the new workbook and check whether surrounding cells or rows also appear gray. Repeat the test in the affected workbook.

3
Record your versions

Select Excel > About Excel to find the Excel version. On your Mac, open Apple menu > About This Mac to find the macOS version.

4
Share the results

If the issue persists, contact Microsoft Support and provide the screenshot, version numbers, and results of the new-workbook test. Share the affected workbook if possible and appropriate.

Test the Gray Cell Behavior in a New Excel Workbook
Interpret the test: If the gray appearance occurs only in the original workbook, the workbook or its template may be involved. If it also occurs in a blank workbook, the issue may affect Excel more broadly.
Free Microsoft Office alternative

Try WPS Spreadsheets as an Alternative on Mac

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets to continue working while you troubleshoot Excel; it does not repair the Excel issue itself.

Work with spreadsheets in a familiar, easy-to-use interfaceOpen and edit Microsoft Excel .xlsx and .xls filesTry viewing the affected workbook outside ExcelMove existing Office documents into a lightweight, free office suite
QA img-9

Frequently Asked Questions

How can I tell whether the problem is caused by a template?

In Excel, select File > New and test cell selection in a blank workbook. If the gray cells appear only in workbooks based on one template, that template or its contents may be involved.

Where can I find my Excel and macOS versions?

Select Excel > About Excel for the Excel version, and Apple menu > About This Mac for the macOS version.

What should I send Microsoft Support?

Provide a screenshot showing the selected cell and gray area, your Excel and macOS versions, and the results of testing a blank workbook. Include the affected workbook if you can share it.

Will creating a new template fix every workbook?

Not necessarily. A new template is a workaround for future workbooks when the behavior appears limited to the original template. Test the new workbook before saving it through File > Save As as an Excel Template.