Remove Alternating Row Colors from an Excel Table on Mac
Question details
The user needs to remove alternating row colors from a selected Excel table or formatted range on a Mac.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user selects a colored range and wants to remove the alternating row shading, but cannot find the table controls.
- Observed behavior
- The Table Design tab is not visible when the colored range is selected, so the Banded Rows setting cannot be changed.
Click a single cell inside the colored range and check whether Excel displays the Table Design tab. This confirms whether the colors come from an Excel table style or from ordinary cell formatting.
Turn off Banded Rows in the Excel Table Design tab
Use this method when the alternating colors come from an Excel table style.
Excel displays table-specific controls only when the active cell is inside the table. Selecting the entire colored range may hide the Table Design tab.
Click any cell inside the colored Excel table on your Mac.
Select the Table Design tab that appears in the Excel ribbon.
In Table Style Options, clear the Banded Rows checkbox. You can also choose a plain style from the Table Styles gallery.
Clear ordinary cell formatting from the colored range
Use this method when the alternating colors are regular cell formatting instead of an Excel table style.
Replace Excel table shading with a clean WPS Spreadsheet table
WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface and strong Excel compatibility. Open the workbook in WPS Spreadsheet, select the table, and adjust its style or clear cell formatting without changing the overall .xlsx workflow.
- 1. Open the workbook: Launch WPS Spreadsheet and choose Open from the Home screen to load the Excel .xlsx file.
- 2. Select the table: Click a cell inside the table so WPS Spreadsheet displays the table and formatting controls.
- 3. Change the table style: Use the table style options to select a plain style or turn off alternating row formatting.
- 4. Clear direct formatting if needed: If the colors are ordinary cell formatting, select the range and use the Home tab's Clear or formatting reset command.

Frequently Asked Questions
Why can’t I see the Table Design tab in Excel for Mac?
The tab appears only when the active cell is inside an Excel table. Click one cell within the table instead of selecting only the colored range or cells outside the table.
How do I remove alternating row colors without deleting table data?
Click inside the table, open Table Design, and clear Banded Rows under Table Style Options. This changes the appearance without removing values or formulas.
What if Banded Rows is already turned off but the colors remain?
The colors may be ordinary cell formatting. Select the affected range, choose Home > Clear > Clear Formats, and then apply any needed number or text formatting again.
Can I keep the table but use a plain appearance?
Yes. Select a cell in the table, open Table Design, and choose a plain table style from the Table Styles gallery, or disable the applicable style options.




