Master Excel tables and analyze your data quickly and easily. Learn how to create a table, sort a table, filter a table, and much more.
Below are the steps to insert a table in Microsoft Excel. Open Excel and move to the cell where you want to insert the table. Click the Table button. Once the table is inserted, adjust the table's size by moving the mouse to the bottom right corner of the table until you get a double-headed arrow.
This tutorial demonstrates how to extend a table by adding a column in Excel. When working with tables in Excel, you can resize them by using Resize Table in the Table Design tab or by simply inserting a column.
Click the Insert tab in the ribbon. Click on the Table option (it’s in the Tables group). This will open the ‘Create Table’ dialog box. Confirm the range mentioned in the dialog box. In case it has picked up the wrong range, or you want to change it manually, you can do it.