Inside The Web
    Facebook Twitter Instagram
    Inside The Web
    • Office
      • Excel
      • Ms Word
      • Gmail
    • Productivity
      • Time Management
      • Task Automation
    Inside The Web
    Home»Excel»How to Extend a Table in Excel

    How to Extend a Table in Excel

    jabinBy jabinMarch 13, 2023 Excel 3 Mins Read

    By default, tables are dynamic in nature. So, you can just start entering new data next to its immediate last row or column, and the table should expand automatically to include them in the new row/column.

    However, what if you realize later that you need to insert some data somewhere in the middle of the table body? Or, you may sometimes need to leave certain rows or columns blank to fill them in later.

    In both cases, you need to extend the table manually. But, the good part is you can do so without deleting/modifying the existing table data.

    Using the Resize Handle

    This is perhaps the quickest method to extend a table. Here, you just drag the resize handle to add new rows or columns.

    1. Hover over the last cell of the table. However, don’t select that cell.
      Expand-table-Using-Resize-Handle
    2. Once it turns into a double-arrow icon,
    • Drag across: Add new column (s)
      Extend-table-across-columns
    • Drag below: Add new row (s)
      Extend-table-with new row
    Note: You cannot drag the cursor diagonally to extend the table, both row-wise, and column-wise at once. So, extend the table in one direction at a time.

    Using the Resize Table Option

    With the Resize Table option, you can add the desired number of multiple rows and columns at once. 

    1. Select a cell inside the table which you want to extend. 
    2. Then, click the Table Design tab that appears at the top.
      Table-Design
    3. Click Resize Table at the top left corner.
      Resize-table
    4. Enter the new cell range to extend the table. Or, click the little Up arrow icon to drag across a larger cell area. Also, make sure you start selecting from the upper-leftmost cell of the table body and the selection is larger than the initial table.
      Drag-to-extend-table

    Using the Insert Option

    If you ever need to insert a new row or column in the middle of your table data, you can extend the table using the Insert option. Alternatively, you can also use it to contract the table and exclude a row/column.

    To add new rows

    1. Select the cell above which you want to insert a new row. 
    2. To add multiple rows, select the number of cells accordingly. Meaning, if you want to insert 6 rows, select six cells. 
    3. Then, right-click and select the Insert > Table Rows Above option. Here, we are only inserting one row above Row 4.
      Insert-rows-above-Extend-table
    4. Additionally, you can insert a new row first and then press the F4 key to start adding another row.

    To add new columns 

    1. Select the cell where you want to insert the new column to the left or right side.
    2. Then, right-click, and hover over Insert.
    3. Next, select the Table Columns to the Left or the Table Columns to the Right option depending upon where you want to insert the new column.
      Expand-table-with-new-columns

    Why Is My Table Not Expanding Automatically?

    With the default Excel settings, your table should expand automatically. However, if it’s not the case, you must enable a setting in the Excel option.

    1. Launch the Excel app.
    2. Navigate to File > Options.
    3. Select the Proofing tab from the sidebar.
    4. Now, on the right pane, click the AutoCorrect Options button.
      Excel-Proofing-options
    5. Under the AutoFormat As You Type tab, make sure the Include new rows and columns in table checkbox is enabled.
      Enable-new-rows-and-columns-Excel-table
    6. Click OK.
    Excel Basics
    jabin

      As a tech content writer, Jabin covers Excel-related articles at InsideTheWeb. His articles mainly involve helping new users to quickly familiarize themselves with the Excel interface and explaining various essential features. While he got introduced to Excel in his early school days, he developed a keen interest in it after working on a college project. He was impressed at how quickly one could accomplish several tasks with built-in functions like the filter function and user-friendly tools like the power query. Keeping beginner audiences in mind, he loves to explain even the most fundamental Excel concepts in detail and break down complex topics with a step-by-step approach. As an avid Excel user, he believes every task can be done a lot quicker if you know the right tools and techniques. When he’s not behind a keyboard, he loves to listen to interesting audiobooks and podcasts.

      Add A Comment
      Table of Contents
      • Using the Resize Handle
      • Using the Resize Table Option
      • Using the Insert Option
        • To add new rows
        • To add new columns 
      • Why Is My Table Not Expanding Automatically?
      Recent Posts
      • How to Calculate Discount Percentage in Excel
      • How to Create a Progress Bar in Excel
      • What is VSTACK in Excel
      • How to Separate Dates in Excel
      • How to Lock a Cell in Excel Formula
      • Home
      • Privacy Policy
      © 2023 Inside The Web

      Type above and press Enter to search. Press Esc to cancel.