Office for Mac Issues

Fix Missing Resize Table Option in Excel for Mac

Huma Ashraf ChHuma Ashraf Ch Oct 22, 2026 870 views

Question details

The user needs to resize an existing Excel table to include existing data located to its left, but the Resize Table option is missing.

How to Resize an Excel Table on Mac When the Option is Missing
Product
Microsoft Excel for Mac
Device & OS
Mac
Scenario
Attempting to incorporate adjacent existing data into a formatted table without copying data and breaking dependent formulas or lookups.
Observed behavior
The Resize Table feature available on Windows is absent in Excel for Mac, preventing users from directly expanding the table boundary to the left.
Before you start

Create a backup copy of your spreadsheet before manually shifting columns or altering table structures to prevent accidental formula errors.

Solution 1Recommended

Insert a Table Column and Relocate Data

Manually add a new column to the left of your table and update your dependent formulas to reflect the change.

Since the direct resize feature is unavailable, you must create a new column inside the table boundaries, migrate your data, and manually update any references.

1
Insert Column

Right-click any cell in the leftmost column of your existing table, select Insert, and choose 'Table Columns to the Left'.

2
Move Data

Select the existing data located outside the table that you wanted to include, copy it, and paste it into the newly created table column.

3
Update Formulas

Review your workbook for any lookups or formulas that referenced the old data location and manually update their range addresses to the new table column.

Insert a Table Column and Relocate Data
Formula Warning: This method may break existing exact-range formulas like VLOOKUP. Double-check your dependent worksheets after pasting your data.
Free Microsoft Office alternative

Switch to WPS Office for a Seamless Spreadsheet Experience

If missing features in Excel for Mac disrupt your workflow, consider switching to WPS Office. It offers a highly compatible, feature-rich spreadsheet application that runs perfectly on macOS without the heavy subscription costs.

  1. 1. Download WPS Office: Visit the official WPS Office website and download the macOS version.
  2. 2. Install the Application: Open the downloaded installer and follow the on-screen instructions to install it on your Mac.
  3. 3. Open Your Spreadsheet: Launch WPS Spreadsheets, click 'Open', and select your existing Excel file to continue working without formatting loss.
Fully compatible with Microsoft Excel (.xls, .xlsx) and CSV formats.Lightweight application that runs smoothly and efficiently on Mac devices.Free to use with a familiar tabbed user interface, ensuring zero learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I resize my table to the left in Excel for Mac?

Excel for Mac lacks some features present in the Windows version. The dedicated Resize Table dialog used to manually redefine a table's data range in all directions is one of these missing features.

Can I resize an Excel table to the right or bottom on a Mac?

Yes. You can click and drag the small sizing handle located at the bottom-right corner of the table to expand it to the right (adding columns) or down (adding rows).

How do I add a completely new column to my table?

You can select a cell in the table, go to the Home tab, click the Insert dropdown, and select 'Table Columns to the Left' or 'Table Columns to the Right'.

Will manually copying data into a new table column affect my formulas?

Yes, if your other worksheets have formulas or lookups pointing to the original cells outside the table, copying and deleting that original data might return reference errors. You will need to manually update those formulas.