Office for Mac Issues

Fix Missing Border Line Styles in Excel for Mac Format Cells

Kushani NimanthikaKushani Nimanthika Nov 12, 2026 869 views

Question details

The user needs to restore missing border line style options in the Format Cells dialog in Excel for Mac.

Fix Missing Border Line Styles in Excel for Mac Format Cells
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
The issue may have started after moving Excel to Apple silicon hardware or after an Office or macOS update.
Observed behavior
Border line styles do not appear or render correctly in the Format Cells dialog.
Before you start

Note your Excel version and whether the Mac uses Apple silicon or Intel hardware. Test the border options in a new blank workbook to determine whether the issue is limited to one file.

Solution 1Recommended

Update Excel and macOS, then test Format Cells again

Use this first when border styles disappeared after an Office update, macOS change, or move to new Mac hardware.

Rendering problems in the Format Cells panel are often resolved by installing the latest Microsoft 365 build and macOS updates. Testing a new workbook helps separate application-wide display issues from workbook-specific problems.

1
Update Microsoft Excel

Open Excel and select Help > Check for Updates. In Microsoft AutoUpdate, install all available Office updates and restart Excel.

2
Install macOS updates

Open the Apple menu, choose System Settings > General > Software Update, and install any available macOS update. Restart the Mac afterward.

3
Test a new workbook

In Excel, select File > New Blank Workbook, select a cell, and choose Format > Cells. Open the Border tab and check whether the line style options are visible.

4
Check display conflicts

Temporarily quit utilities, screen-management tools, external-display software, or other applications that alter window rendering, then reopen Excel and check Format Cells again.

Latest builds can resolve rendering issues: If the border styles return after updating Office and macOS, keep both products current to reduce the chance of the display problem recurring.
Free Microsoft Office alternative

Switch to WPS Office for Familiar Spreadsheet Formatting on Mac

WPS Office is a free, lightweight Microsoft Office alternative with a familiar spreadsheet interface and strong Excel file compatibility. Open or migrate your .xlsx workbooks in WPS Spreadsheets to continue editing cells, borders, and formatting while avoiding the Excel for Mac rendering issue.

  1. 1. Install WPS Office: Download and install WPS Office for Mac, then launch WPS Spreadsheets from the Applications folder.
  2. 2. Open the Excel workbook: In WPS Spreadsheets, select Open and choose the affected .xlsx or .xls file from Finder.
  3. 3. Edit border formatting: Select the target cells and use the Home tab's border controls or the cell-formatting dialog to apply a line style.
Free and lightweight spreadsheet editor for MacFamiliar interface for editing cells, borders, and Format Cells settingsCompatible with Microsoft Excel .xlsx and .xls filesSupports common workbook formatting for easier migration from Excel
microsoft office alternative - wps office

Frequently Asked Questions

Why are border line styles missing in Excel for Mac?

The issue can result from an outdated Excel or macOS build, display-rendering conflicts, damaged preferences, external-monitor settings, or software that modifies window rendering.

How can I tell whether the problem affects one workbook or Excel itself?

Open Excel and create a blank workbook with File > New Blank Workbook. Check Format > Cells > Border there; if the styles appear, the original workbook may contain file-specific formatting or corruption.

Could Apple silicon cause the Format Cells border issue?

Moving to Apple silicon hardware can expose compatibility or rendering problems in older Office builds. Update Excel through Help > Check for Updates and install current macOS updates before testing again.

What should I do if updating Excel does not restore the border styles?

Quit conflicting display or window utilities, test Excel with a different display configuration, reset Excel preferences, try Safe Mode if available, and reinstall Office if the problem affects every workbook.

Can WPS Office open Excel workbooks with border formatting?

Yes. WPS Spreadsheets supports common Microsoft Excel .xlsx and .xls files and provides border and cell-formatting controls, although complex workbook features may render differently.