Tips on how to Insert A number of Rows in Microsoft Excel


Inserting a number of rows into your Microsoft Excel spreadsheet is not troublesome. Merely use a fast context menu possibility or keyboard shortcut so as to add a number of traces without delay. We’ll present you do it.

associated: Tips on how to Shortly Add Rows and Columns to a Desk in Microsoft Phrase

Insert A number of Rows with Proper-Click on Menu Possibility in Excel

One technique to concatenate a number of rows in Excel is to make use of an possibility in Excel’s context menu.

To make use of this methodology, first, open your spreadsheet with Microsoft Excel.

In your spreadsheet, choose the variety of rows you wish to add. For instance, if you wish to add 4 new rows, choose the 4 rows in your spreadsheet above which the brand new rows might be added.

Select Rows in Excel.

Proper-click on one of many chosen rows, and from the menu that opens, choose “Insert”.

You will see a small “Insert” field seem in your display screen. On this field, allow the “Total row” possibility and click on “OK.”

And instantly, Excel will add the required variety of rows to your spreadsheet.

tip: To shortly delete newly added rows, press Ctrl+Z on PC or Command+Z on Mac.

New rows added to Excel.

you are all set.

Insert A number of Rows in Excel with One Keyboard Shortcut

Should you want to make use of Excel keyboard shortcuts, there’s a shortcut you need to use to shortly add a number of rows to your Excel spreadsheet.

associated: All of the Greatest Microsoft Excel Keyboard Shortcuts

To make use of the shortcut, first, open your spreadsheet with Microsoft Excel.

Within the spreadsheet, choose the variety of rows you wish to add. For instance, if you wish to add three new rows, choose three rows in your present spreadsheet. Excel will add new rows on prime of the chosen rows.

Select Rows in Excel.

When the rows are chosen, press Ctrl+Shift+Plus (+ signal) on the similar time on a PC, or Command+Shift+Plus (+ signal) on a Mac. This may open an “Insert” field. On this field, choose “Total row” and click on “OK.”

Excel will add the chosen variety of rows to your spreadsheet.

Rows added to Excel.

And that is the way you make room for brand spanking new knowledge in your spreadsheet by including a number of rows without delay. very useful!


Should you work with tables typically, you’ll be able to add and take away columns and rows in a desk simply as simply in Excel.

associated: Tips on how to add or take away columns and rows in a desk in Microsoft Excel?



Supply hyperlink

Previous post New Supplier Brings Nanaimo Simple, Enticing Dwelling-Web Companies at Reasonably priced Costs – Nanaimo Information Bulletin
Next post Save 50% on dwelling web + 1 month freebie in Vodafone Black Friday sale