contador web Saltar al contenido

How to insert row in Excel | Productivity

Inserting rows into an Excel spreadsheet is already simple, but novice users may have difficulty exploring the features of the Microsoft program. The software allows you to insert blank lines anywhere in the file using an easy mouse shortcut. To learn how to add more rows to an existing Excel document, follow the tutorial below. The walkthrough was done in Office 2016, but applies to previous versions of the tool.

10 Advanced Excel Tips and Tricks

Excel the Office program for professional spreadsheets Photo: Carolina Ochsendorf / TechTudoExcel the Office program for professional spreadsheets Photo: Carolina Ochsendorf / TechTudo

Excel the Office program for professional spreadsheets Photo: Carolina Ochsendorf / TechTudo

Want to buy a cell phone, TV and other discounted products? Meet the Compare TechTudo

How to insert individual line

Step 1. To open a pre-filled spreadsheet, go to Open, then Browse. When the File Pane opens, look for an existing Excel document and press Open;

Create a new file or open an existing Excel file Photo: Playback / Gabrielle FerreiraCreate a new file or open an existing Excel file Photo: Playback / Gabrielle Ferreira

Create a new file or open an existing Excel file Photo: Playback / Gabrielle Ferreira

Step 2. With the document open, select the cell above which you want to insert a blank line;

  You can easily add or delete rows in Excel. Photo: Playback / Gabrielle Ferreira  You can easily add or delete rows in Excel. Photo: Playback / Gabrielle Ferreira

You can easily add or delete rows in Excel. Photo: Playback / Gabrielle Ferreira

Step 3. With the row selected, right-click the selected cell. Then go to Insert and press the Rows from Table Above option. The new blank line appears in the worksheet above the selected line.

By adding white lines, new data can be inserted in the middle of the table. Photo: Reproduction / Gabrielle FerreiraBy adding white lines, new data can be inserted in the middle of the table. Photo: Reproduction / Gabrielle Ferreira

By adding white lines, new data can be inserted in the middle of the table. Photo: Reproduction / Gabrielle Ferreira

How to insert multiple lines

Step 1. Select the number of cells equivalent to the number of rows you want to add. For example, if you want to add three lines, select three cells above which you want to insert blank lines;

Unlimited white lines can be added to documents Photo: Reproduction / Gabrielle FerreiraUnlimited white lines can be added to documents Photo: Reproduction / Gabrielle Ferreira

Unlimited white lines can be added to documents Photo: Reproduction / Gabrielle Ferreira

Step 2. With the lines selected, right-click on the cells. Then press Insert from the context menu and then Table Rows Above. New blank lines will appear in the spreadsheet above the selected cells.

The new lines will appear in the spreadsheet. Photo: Reproduction / Gabrielle FerreiraThe new lines will appear in the spreadsheet. Photo: Reproduction / Gabrielle Ferreira

The new lines will appear in the spreadsheet. Photo: Reproduction / Gabrielle Ferreira

What is the best way to convert a PDF file to Excel? Give your opinion on the TechTudo Forum.

Spreadsheets ready in Microsoft Excel to enjoy the cold

Spreadsheets ready in Microsoft Excel to enjoy the cold

Rate this post