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.

Do you have a specific function question?

Post a question in the Excel community forum

Help us improve Excel

Do you have suggestions about how we can improve the next version of Excel? If so, please check out the topics at Excel User Voice

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×