Insert Shortcut in Excel

One of the key elements in becoming an expert in Excel is using shortcut keys. So there is no rocket science to work quickly and productively in Excel. For almost all the tasks in Excel, we have shortcut keys, and one of the often performed activities is inserting a row, column, PivotTable, insert sheets, insert workbooks, etc. These are all often performed tasks, so it is important to know the shortcut keys to perform these tasks and increase Excel productivity quickly. This article will show you how to perform shortcut keys in Excel.

How to Insert Shortcuts in Excel?

Below is how to insert shortcut keys in Excel with examples.

Example #1 – Insert Rows & Columns Shortcut

Inserting new rows and columns in Excel is a common task we all do as part of the work. To insert new rows and columns, we can perform shortcut keys. So these shortcut keysShortcut KeysAn Excel shortcut is a technique of performing a manual task in a quicker way.read more are very helpful to us to increase efficiency and productivity.

  • For example, look at the below data table.

  • Assume we need to insert three rows instead of 1. Then we need to select three before pressing the shortcut key.

  • Now, we must press the shortcut key “Ctrl and + (Plus)” to insert as many rows as selected above.

We have three new rows, so the inserted shortcut key may insert as many rows as we have selected when using the shortcut key. After performing the insert row option, if we press the F4 key again, it will repeat the last action of inserting rows and inserting three more rows.

  • First, we must select any of the cells in row number 5. We have selected the A5 cell. After the cell selection, press the shortcut key “Shift + Space” to select the entire row. We need to press “Ctrl and + (Plus)” to insert a new row by pushing the selected row down. As a result, we can see a new row has been inserted.

We have selected the A5 cell.

As a result, we can see a new row has been inserted.

  • Similarly, we can also insert columns using shortcut keys. For example, in the same data table above, if we want to insert a column after column C, we must select the column after column C. So first, we must choose any of the cells in column D.

  • Now, cell D3 has been selected, so to select the entire column of the active cell, we need to use the shortcut key “Ctrl + Space.”

  • Once the entire column has been selected, we can press the “Ctrl and + (Plus)” shortcut key to insert a new column.

  • We can apply the same logic as we have applied for inserting rows here. If we need to insert multiple rows, we must select the many columns we would wish to insert. For example, if we want to insert four columns, we must choose those many first.

  • Now, press the insert shortcut key “Ctrl and + (Plus)” to insert four columns.

The insert shortcut key is to insert new rows and columns in excelRows And Columns In ExcelA cell is the intersection of rows and columns. Rows and columns make the software that is called excel. The area of excel worksheet is divided into rows and columns and at any point in time, if we want to refer a particular location of this area, we need to refer a cell.read more.

Example #2 – Insert New Worksheet & Workbook

If we want to insert a new worksheet or workbook, it is easy using shortcut keys in Excel. However, as we keep working in Excel, we may need to insert a new worksheet to have some copied data. So, in that case, we can use the below shortcut key to insert a new sheet.

#1 – Shift + F11

The above shortcut key will insert a new worksheet in excelInsert A New Worksheet In ExcelTo add a new worksheet, go to the bottom of the screen and press the ‘+’ button. You can also navigate to ‘Home’, ‘Insert,’ and then ‘Insert Sheet’ to add a new sheet.read more.

Similarly, if we want to insert a new workbook instead of a new worksheet, then the below shortcut key will insert a new workbook.

#2 – Ctrl + N

Things to Remember

  • The opposite of inserting rows and columns is Ctrl and – (Minus Sign).To insert Pivot Table shortcutPivot Table ShortcutA Pivot Table is an Excel tool that allows you to extract data in a preferred format (dashboard/reports) from large data sets contained within a worksheet. It can summarize, sort, group, and reorganize data, as well as execute other complex calculations on it.read more key is ALT + D + P + F.

This article has been a guide to Excel Insert Shortcut. Here, we learn how to insert rows and columns in Excel by using shortcut keys along with examples and downloadable Excel templates. You may learn more about Excel from the following articles: –

  • Shortcut to Select Row in ExcelInsert Page Break in ExcelEmbed an Object in ExcelInsert Button in Excel