Office
Sign in

Resize a table by adding columns and rows

Excel Online doesn’t have the Resize Table option but you can manually resize your table by adding columns and rows.

To add a new column to your table, type data in the column to the right of your table and press Enter.

type in column to the right of the last column in table to add new column

To add a new row, type data in the row below the last table row and press Enter.

Add new table row by typing data in row below the last table row

Note: New columns and rows might take a few seconds to appear inside the table.

If you need to add a large number of columns and rows, you’ll find it easier to use the Resize Table option in the Excel desktop application. If you have the Excel desktop application, click Open in Exceland use the Resize Table option under Table Tools. There are more details here.

When you save the Excel desktop workbook and reopen it in Excel Online, you'll see the changes you made. 

If you don't have the Excel desktop application, you can give it a try. Or you can buy it here, when you're ready to switch.  

For news about the latest Excel Online updates, visit the Microsoft Excel blog.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×