WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Excel Insert Shortcut

Excel Insert Shortcut

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 activity is inserting a row, column, and pivot table, insert sheets, insert workbooks, etc. These are all often performed tasks, so it is important to know what are the shortcut keys to perform these tasks quickly and increase productivity in excel. In this article, we will show you how to perform insert shortcut keys in excel.

How to Insert Shortcuts in Excel?

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

You can download this Insert Shortcut Excel Template here – Insert Shortcut Excel Template

Example #1 – Insert Rows & Columns Shortcut

Having to insert new rows and columns in excel is a common task we all do as part of the work. In order to insert new rows and columns, we can perform shortcut keys, so these shortcut keys are very helpful to us to increase efficiency and productivity.

  • For example, look at the below data table.

Insert Shortcut Example 1

In the above table, assume we need to insert a new row after row number 4, so first, we need to select the row after row number 4.

  • So to select the row, also, we can use the shortcut key, first select any of the cells in row number 5.

Insert Shortcut Example 1-1

  • Now, A5 cell is select, after the cell selection, press the shortcut key Shift + Space to select the entire row.

Insert Shortcut Example 1-2

  • Now simply press the shortcut key “Ctrl and + (Plus)” to insert a new row by pushing the currently selected row to down.

Insert Shortcut Example 1-3

There you go, a new row has been inserted.

  • Assume you need to insert three rows instead of 1, then you need to select three before pressing the shortcut key.

Insert Shortcut Example 1-4

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

Insert Shortcut Example 1-5

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

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • Similarly, we can also insert columns using shortcut keys. For example, in the same data table above, if you want to insert a column after column C, then we need to select the column after column C. So first, select any of the cells in column D.

Insert Shortcut Example 1-6

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

Example 1-7

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

Example 1-8

  • You can apply the same logic as we have applied for inserting rows here as well. In case of inserting multiple rows, select those many columns as you would wish to insert; for example, if you want to insert 4 columns, then select those many columns first.

Example 1-9

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

Example 1-10

This is the insert shortcut key to insert new rows and columns in excel.

Example #2 – Insert New Worksheet & Workbook

If you want to insert a new worksheet or workbook, it is quite easy using shortcut keys in excel. As we keep working in excel, we may need to insert a new worksheet to have some copied data, so in that case, use the below shortcut key to insert a new sheet.

#1 – Shift + F11

The above shortcut key will insert a new worksheet in excel.

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

#2 – Ctrl + N

By pressing the above shortcut key, we can insert a new workbook from the active workbook.

Things to Remember

  • The opposite of inserting rows and columns is Ctrl and – (Minus Sign).
  • To insert Pivot Table shortcut key is ALT + D + P + F.

Recommended Articles

This 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 Excel
  • Insert Page Break in Excel
  • Embed an Object in Excel
  • Insert Button in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Insert Shortcut Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More