Fix Missing Border Line Styles in Excel for Mac Format Cells
Question details
The user needs to restore missing border line style options in the Format Cells dialog in Excel for Mac.

- 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.
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.
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.
Open Excel and select Help > Check for Updates. In Microsoft AutoUpdate, install all available Office updates and restart Excel.
Open the Apple menu, choose System Settings > General > Software Update, and install any available macOS update. Restart the Mac afterward.
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.
Temporarily quit utilities, screen-management tools, external-display software, or other applications that alter window rendering, then reopen Excel and check Format Cells again.
Reset Excel preferences or reinstall Office for Mac
Use this when updates and display checks do not restore the border line styles across new and existing workbooks.
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. Install WPS Office: Download and install WPS Office for Mac, then launch WPS Spreadsheets from the Applications folder.
- 2. Open the Excel workbook: In WPS Spreadsheets, select Open and choose the affected .xlsx or .xls file from Finder.
- 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.

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.




