Formatting Issues

Remove Alternating Row Colors from an Excel Table on Mac

Maira MehtabMaira Mehtab Nov 12, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Activate the table

Click any cell inside the colored Excel table on your Mac.

2
Open Table Design

Select the Table Design tab that appears in the Excel ribbon.

3
Disable alternating shading

In Table Style Options, clear the Banded Rows checkbox. You can also choose a plain style from the Table Styles gallery.

Check the active cell: If Table Design does not appear, click inside the table again rather than selecting only the surrounding colored range.
Free Microsoft Office alternative

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. 1. Open the workbook: Launch WPS Spreadsheet and choose Open from the Home screen to load the Excel .xlsx file.
  2. 2. Select the table: Click a cell inside the table so WPS Spreadsheet displays the table and formatting controls.
  3. 3. Change the table style: Use the table style options to select a plain style or turn off alternating row formatting.
  4. 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.
Control table styles and alternating row shading in WPS SpreadsheetFree, lightweight interface with familiar spreadsheet menusOpen, edit, and save Microsoft Excel .xlsx files with broad format compatibilityMigrate existing Excel workbooks without rebuilding the table structure
microsoft office alternative - wps office

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.