Excel with Examples

How to insert a row in Excel with shortcuts?

How to insert a row in Excel with shortcuts?

Introduction

If you need to insert data into an Excel table, it is sometimes a good idea to add an entire row. In this tutorial, we will teach you how to do this!
So start by opening your Excel workbook and follow these steps:

Quickly insert a row in Excel

To insert a new row in Excel sheet, you click with the right mouse button at the place of insertion and then choose the Insert command. That’s it 🙂

Quickly insert a row in Excel

Quickly insert a row in Excel

Shortcut to add row in Excel

When you are in Excel, you like to work with the keyboard and avoid using the mouse to the maximum?
If you want to insert new rows in Excel you can use Shortcuts too.

  1. Select cell below the line to be inserted.
  2. Then press the shortcut key to insert rows in excel Ctrl, Caps and + keys simultaneously.
  3. Repeat this last shortcut while the row is selected if you need to insert a row with shortcuts.
Shortcut to add row in Excel

Shortcut to add row in Excel

Shortcut for deleting rows in excel

Well, it’s pretty much the same thing.
For deleting rows in Excel with the mouse you need to select the rows to be deleted and click the right mouse and choose delete row.
And if you want to use the shortcut for deleting rows in excel just select the rows and press the shortcut key to delete rows in excel Ctrl, Caps and – keys.
Be-careful its not the delete keyboard button that one is just deleting data, not the hole row.

For the columns, it’s basically the same thing with some shortcuts and you can check How to add a column in Excel?

If you like to know more useful Excel shortcut keys we have a list of more than 50+ Excel Shortcuts Keys in PDF.

Leave a Comment