Resize an Excel Table and Add Rows or Columns on Mac
Question details
The user needs to resize an Excel table and add rows or columns on a Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user is following Windows instructions that refer to Table Tools, but Excel for Mac shows a Table tab instead.
- Observed behavior
- The user wants to expand the table to include additional rows or columns.
Click a cell inside the table to reveal the contextual Table tab and confirm that the range is an Excel table. Check that the adjacent cells are available before expanding the table into them.
Insert Table Rows or Columns with the Right-Click Menu
Use the table’s context menu to add a row or column at a specific position.
Click a cell near where you want to add a row or column.
Right-click the selected cell and choose Insert. Look for the table row or table column option in the menu.
Choose the appropriate table row or column command, such as Table Rows Above or Table Columns to the Left. Enter your data in the new cells.

Expand the Table with Its Resize Handle
Drag the table’s lower-right handle to include adjacent rows or columns.
Test Table Resizing in a New Workbook
Use a new table to check whether the issue is specific to the original workbook or related to the Excel and macOS setup.
Edit Spreadsheet Tables with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface for editing tables. It supports Excel formats, making it easy to move existing workbooks into WPS. It does not change the Excel for Mac interface.

Frequently Asked Questions
Why do I see a Table tab instead of Table Tools on my Mac?
Excel for Mac can use different ribbon labels from Excel for Windows. Click inside the table to display its contextual Table tab and table-related commands.
How do I add a column to an Excel table on Mac?
Right-click a cell inside the table, choose Insert, and select the available table column command. You can also drag the table’s lower-right handle to the right.
Can I add several rows to a table at once?
You can drag the table’s lower-right handle downward across the number of adjacent rows you want to include. Check that those cells are available first.
What should I do if the resize handle does not work?
Create a new workbook using File > New Workbook, make a sample table with Insert > Table, and test its handle. If the issue occurs there too, check your Excel and macOS versions against Microsoft’s system requirements.




