Download Article
Download Article
Do you have a table in Excel that you need to add more data to, like an outdated grade sheet? This wikiHow will teach you how to add a row to a table in Excel using the "Resize Table" setting for Windows, the web version, and Mac.
Steps
-
Open your project in Excel. Double-click your .xls worksheet file in File Explorer. Alternatively, right-click the file and select Open with > Excel .
- If you already have Excel open, go to File > Open and open your project.
-
Click anywhere in the table. Once you click the table, you'll see "Table Tools" are listed as your current tab at the top of the editing space.Advertisement
-
Click Design . It's in the menu near the top of your screen.
-
Click Resize Table . This icon is listed in the "Properties" grouping to the far left in the menu.
-
Select the new range of rows and columns you want to use in the table. Start with the upper-left cell of your table, and end with the bottom-right cell, which means you can add rows at the bottom of the table. Your original data set will highlight in blue. Your new selection will be outlined with a dashed border.
- Added rows must be below your table so they can be added.
-
Click OK . Once you've selected the new rows to include in the table, select OK in the dialog window to close it. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- You can also insert a row or column in the middle of the table by right-clicking a cell in your data, selecting Insert and Table Columns to the Left/Right or Table Rows Above/Below .
Advertisement
-
Open your project in Excel. Double-click your .xls worksheet file in Finder or right-click the file and select Open with > Excel .
- If you already have Excel open, go to File > Open and open your project.
-
Right-click your table. A menu will appear at your cursor.
-
Hover your mouse over Insert and click Table Rows Above . You'll be able to specify how many rows you want to add to the table in the next step.
- If hovering your mouse over the option doesn't work, click it, then select Shift cells down .
-
Enter how many rows you want to add and press ⏎ Return . The rows will be added to the bottom of your table. [2] X Research source
- You can also insert a row or column in the middle of the table by right-clicking a cell in your data, selecting Insert and Table Columns to the Left/Right or Table Rows Above/Below .
Advertisement
-
Go to https://www.office.com/ , login, and launch Excel. Once you navigate to the login site and enter your Microsoft account information, you'll be logged in. Finally, launch Excel.
-
Click a project to open it. You'll also see all the projects you have saved to OneDrive.
-
Click anywhere in the table. Once you click the table, you'll see "Table Design" as an option in the editing ribbon above your spreadsheet document.
-
Click the Table Design tab and select Resize Table . The "Resize" option is all the way to the left of the menu in the "Table Design" tab.
-
Enter the new range for your table. For example, if you want to add one row, just increase the last number: If your current data set for the table is A1 to H13, input A1:H14 to add a row at the bottom of the table.
-
Click OK . This will close the window and change the range of the table.
- You can also insert a row or column in the middle of the table by right-clicking a cell in your data, selecting Insert and Table Columns to the Left/Right or Table Rows Above/Below .
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
References
About This Article
Article Summary
X
1. Open your project in Excel.
2. Click anywhere in the table.
3. Click Design
.
4. Click Resize Table
.
5. Enter the new range of rows and columns you want to use in the table.
6. Click Ok
.
Did this summary help you?
Thanks to all authors for creating a page that has been read 44,349 times.
Advertisement
