How to add multiple rows in excel how to#

Because we want three rows to appear, we select cells in three rows, starting from 6. We will need to select a cell in row 6, because we want our new rows to appear immediately above it. You then right click and then choose Insert> Entire Row.įor example, let’s insert three rows in our example spreadsheet between rows 5 and 6. To specify the number of rows that are to be added, you need to select the same number of rows on your spreadsheet. The same thing happens when we add multiple rows. We learnt while adding a single new row that it appears immediately above the location we’ve selected.

How to add multiple rows in excel how to#

Do you keep pressing the F4 key 10 times if you wanted to add 10 rows in Excel? No, you don’t! Inserting Multiple Rows in Excelįinally, let’s learn how to add multiple rows in excel. The only problem is that it’s tedious to keep pressing the F4 key for adding a single row. If you need to insert multiple single rows (or columns) in your spreadsheet at different locations, using the F4 key is much quicker than doing Insert > Entire Row all the time. The F4 shortcut key repeats the last action you’ve performed in Excel. You can also use the Insert button at the top- but this time you choose the Insert Sheet Columns option. A new column will always appear to the immediate left of where you’re clicking. If you wanted to insert a column between column B and column C, you click on any cell in C and choose Insert> Entire Column. Just undo the changes you’ve made to your worksheet (Ctrl + z) and try it out for yourself: For example, if you wanted a new column to be placed between Column A and Column B, click on any cell in Column B and click Insert, and then select “Entire Column”. To insert a blank column, click on a cell in the column to the immediate right of where you want the new column to be placed in. The process is similar if you want to insert a single column in Excel. If you wanted to add a row between 4 and 5, you would select a cell in 5 and then insert… and so on and so forth. If you wanted to add a row between 3 and 4, you would select a cell in row 4 and insert a new row. You can also use the prominent Insert button (Insert Sheet Rows) that is on the Home menu at the top for the same result: That’s all there is to it:Īnd there you go- a new blank row has popped up. You then choose add “Entire Row” and click ok. You can do that by clicking on any cell in row 6, right clicking and choosing the insert option. Suppose we wanted to create a new blank row between rows 5 and 6 in our example spreadsheet. Sounds complicated and somewhat convoluted? Let’s work with our example spreadsheet to help you understand better. And there you go- your new row has been created. You then right click and select insert in the drop down menu that appears.

Now, to add a single row, you need to select any cell in the row below the row where you want the new row to be created. You can create a sample spreadsheet for the purpose of this exercise (any spreadsheet with some data will do). Let’s start out small, first, before we learn how to insert multiple rows. The ability to insert multiple rows and columns should help you edit and manage your spreadsheets far better than before. We’ll be using Excel 2010 for the demonstration, but you can do this on Excel 2007 and Excel 2013 too – the process is exactly the same for those versions. If you’re new to it, we strongly recommend you first try out an easy beginners course to get a feel of Excel. Excel is really by and far the best data management tool out there. In this tutorial, we’re going to learn how to insert multiple blank rows (and columns) quickly in an Excel spreadsheet.