How to add rows in Excel

How to add rows in Excel: Recently, your manager asked you to modify a spreadsheet made with Excel: after viewing the file, you soon realized that the work, among other things, also requires the insertion of new lines.

Not being particularly familiar with Microsoft’s spreadsheet program, you asked some colleagues to explain to you how to add rows in Excel, but you didn’t find a satisfactory answer that would help you complete the task. been assigned.

So you didn’t give up and, trying to find the solution to your dilemma on the Internet, you landed on this tutorial of mine. Well, I am happy to tell you that you are in the right place! Continuing with the reading of the next paragraphs, you can in fact find out how to add one or more lines to Excel, both manually and automatically, both on PC and on smartphones and tablets. That said, there is nothing left for me to do, except invite you to continue reading the guide and wish you a good job!

Index

• How to add rows to Excel from PC
  • How to add a row in Excel
  • How to add multiple rows in Excel
  • How to insert rows automatically in Excel
• How to add rows in Excel Online
• How to add rows to Excel from smartphones and tablets
  • How to add a row in Excel
  • How to add multiple rows in Excel

How to add rows to Excel from PC

You are in front of your computer, you have already started the famous Office suite program and opened the XLS or XLSX file that you need to modify: now you just have to follow the simple instructions that I am about to give you to find out how to add rows to Excel from a PC, or from Mac (the steps to learn how to add a row on Excel Mac are in fact the same).

How to add a row in Excel

Let’s start immediately with the most common feature: if your purpose is to learn how to add a row in Excel, in this chapter you will discover that there are several ways to perform this simple operation: all you have to do is choose the one that is most convenient for you.

First of all, finding yourself in front of the table to be modified, click on any cell of the row following the one you want to insert, in order to select it. Once this is done, press on the Home menu, located at the top left, and press the Insert functionality in the toolbar below, then click on the Insert sheet rows option.

Alternatively, you can also proceed by clicking with the right mouse button on the row number (which must always be subsequent to the one you intend to add) in the left column and pressing the Insert item in the context menu. In all cases, however, a new row will be produced just above the selected one.

If you also want to transfer the formatting of the selected row, you can use the specific function on the left, which shows the symbol of a brush: by clicking on it, you will be offered the possibility of formatting the new row by choosing the one already applied in the row in bottom (or top), but also to clear the formatting altogether.

How do you say? Would you like to know how to insert row in Excel with keyboard via convenient shortcut? I’ll settle for you right away: select the row (you can also do this operation without taking your hands off the keyboard, positioning yourself on the cell using the directional arrows and pressing the Shift + Spacebar keys simultaneously), then type the combination Ctrl + [+] ( cmd + [+ ] on Mac). Easy, right?

How to add multiple rows in Excel

Is your need to insert a greater number of lines on the table you are editing? Fear not, even in this case it is absolutely not difficult to understand how to add multiple rows in Excel.

Let’s start with the most common hypothesis, that is to insert new adjacent rows: in this case the solution is particularly intuitive, as you will simply have to select a number of rows equal to those you want to add. To do this, position the cursor on the number of the row immediately following the one you want to create, then hold down the left mouse button and drag it down to highlight all the subsequent rows you want.

Next, press the right mouse button inside the selected area, then select the Insert option from the context menu or, alternatively, use the Insert> Insert sheet rows function in the Home menu: you will see that they will be automatically created as many lines.

If the rows are not adjacent, the method doesn’t change much: click on the first-row number you need to select, then hold down the Ctrl key ( cmd on Mac) and click on the next ones as well. At the end, release the Ctrl/cmd key and insert the lines following the same steps illustrated in the previous paragraph.

How to insert rows automatically in Excel

How do you say? Is the file you are working on really too long and would you like to be able to refer to an automatic procedure that allows you to add more lines in a simple and intuitive way?

I have excellent news for you: the operation, in fact, is absolutely feasible, but it is necessary to activate a special macro, that is a function that executes a set of editable instructions using special tools for developers.

In order to proceed, therefore, it is necessary to enable the Development menu in advance, which by default is not visible: to do this, click on the File> Options menu (top left), then, in the new window that appears, press on the wording Bar customization multifunction from the left column and click on the Development box on the right, in the Main Cards section.

To confirm the change, press the Ok button: you will notice that there is now the Development tab in the top menu. By clicking on the latter you will be shown new tools dedicated to the creation and recording of macros in the bar below: press on the Visual Basics function, located on the left, to open the relative screen.

First, now, double-click the sheet you want to apply the macro to in the browser section, on the left. In the central editing window that appears, instead, paste the following instructions.

Sub InsertRows()
Uriga = Cells(Rows.Count, “A”).End(xlUp).Row
For N = Uriga To 1 Step -1
Rows(N + 1 & “:” & N + 5).Insert
Next N
End Sub

Of course, you will have to adapt the instructions to the spreadsheet you are processing according to your needs: this simple example version allows you to automatically add 5 new lines under each line in the file, starting from the first.

To make the instruction start from a predetermined point, for example from the sixth line, it is necessary to edit the first value following the wording N + within the Rows instruction, inserting the starting line number (in this case, therefore, the 6). To change the number of added lines, however, you will have to edit the second value always contained in the Rows instruction (so N + 2, if you want to add two lines).

At this point, it is important to save the file, which must take place in very specific ways so that everything works properly: therefore, go to the File> Save menu and, only the first time, click the No button in the information window that is proposed to you.

In the next save screen, select the Excel Macro-Enabled Workbook option from the Save As drop-down menu and press the Save button.

Now everything is ready to run the macro: close the Visual Basic window by pressing the [ X ] symbol located at the top right and, from the Development menu, click on the Macro functionality.

In the window that opens, then, select the one called InsertRows and press the Run button: in no time at all, the script will be applied to the spreadsheet and the new rows will be generated automatically.

How to add rows in Excel Online

Are you using the online version of Microsoft Excel to edit your spreadsheet? Well, you will be pleased to know that there are no particular differences in applying the line insertion functionality compared to the computer version.

To understand how to add rows to Excel Online, just refer to the previous chapters on inserting one or more rows in the desktop version of the program. Unfortunately, however, it is not possible to run macros to create lines automatically.

How to add rows to Excel from smartphones and tablets

Your work takes place mainly on mobile devices and, therefore, are you looking for instructions on how to add rows to Excel from smartphones and tablets? No problem: as you will see in the next paragraphs, the procedure to follow is really very simple.

The only warning I want to give you before proceeding to the practical explanation is to consider that the Excel app for smartphones shows the main menu at the bottom, while the one for tablets shows it at the top as tabs, similarly to what happens in the PC version. The app is available on Android (also on alternative stores ) and iOS / iPadOS and is free for devices up to 10.1 “; for larger ones it requires the subscription of a Microsoft 365 plan (starting from 7 euros/month. ).

How to add a row in Excel

If you want to learn how to add a row on Excel mobile, you will be pleased to know that even in this case the procedure is very intuitive and the operation does not differ much from those illustrated in the previous chapters.

In essence, therefore, you must first select the row following the one you want to insert, an operation that can be easily performed on the row number indicated in the appropriate column on the left. At the same time, you will be shown a menu just above the selected row, both on smartphone and tablet and you just have to press the Insert item to complete the operation.

Alternatively, if the app is installed on a mobile phone, after selecting the row (or even a single cell within the row) you can press the arrow symbol at the bottom right and tap the Insert and delete option, then, in the next step, you will have to tap on Insert lines.

On a tablet, on the other hand, you can press on the Home menu, at the top left, and press on the symbol of a table with a green [+] and a red [X], then select the words Insert rows.

How to add multiple rows in Excel

In the mobile version of Microsoft’s powerful table processing tool, you can also insert more rows. If, therefore, you want to understand how to add more rows on Excel mobile and these are adjacent to each other, all you have to do is highlight the first row on the corresponding number in the left column and act on the dot-shaped anchors that are shown in the center. selection by dragging them up or down with a flick of your finger.

To complete the operation, press the Insert menu that is proposed to you, or press the arrow symbol at the bottom, tap the Insert and delete item from the pop-up menu and touch the Insert rows option: in this way a number will be generated of rows equal to those just selected.

If you have a tablet you can also take advantage of the integrated functionality on the Home menu: in the toolbar below there is the symbol of a table with a green [+] and a red [X] which, once pressed, will give you the opportunity to interact with the entry Insert lines.

I sincerely hope I have been helpful in this little task: if you found this guide particularly useful and interesting and you want to learn more about how this extraordinary software works, I invite you to read my most complete tutorial on how to use Excel.

Still on the subject, maybe you want to know more, for example, on how to block the lines, or explore new topics relating to ‘ use of formulas, needed to perform various operations such as sum, subtraction, multiplication, division and percentages.