Download ArticleDownload ArticleThis article was co-authored by How.com.vn Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. How.com.vn's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards.
This article has been viewed 111,845 times.
Learn more...
This How.com.vn teaches you how to insert rows in Excel using shortcuts on a Windows or Mac computer. There are keyboard shortcuts as well as custom shortcuts that you can use in Excel spreadsheets.
Quick Steps
- Open an Excel spreadsheet.
- Click a row number to select it.
- Press CTRL + Shift + = to insert a row below.
Steps
Open an excel spreadsheet. You may use an old one or create a new one.
Select a row by clicking on the row number. You should see the row number on the far left of the sheet. The new row will appear above the selected row or rows.- Highlight the same number of rows as you want to add. So to add one row, highlight just one row, to add 2, highlight 2 rows, etc.
Advertisement
Type the Control+⇧ Shift++ keys at the same time to insert a row. Your new row should appear above the selected one.- If you have no rows selected and press Control+⇧ Shift++ then it will not work.
Open an excel spreadsheet. You can use an old or new one.
Select a row. The new row will be inserted above the selected one. This happens only if you have one row selected.- Highlight the same number of rows as you want to add. So to add one row, highlight just one row, to add 2, highlight 2 rows, etc.
Type Control+⇧ Shift++ at the same time to insert a row. The new row will appear above the selected one.- This shortcut only works if you have a row selected.
Open Excel. The icon is green with a white “X” in it.
Open an excel document. It can be an old or new document.
Click on the Home tab.
Select a row by clicking on the row number. You should see the row number on the far left of the sheet.
Click on Insert. It is located near the top right of the Excel window. This should automatically insert a new row above the row you selected. To save the insert row command as a shortcut, do the following:- Right-click on Insert Row to open up an additional drop-down menu.
- Select Add to Quick Access Toolbar. If you have nothing added to your toolbar then the next key will be assigned to F4. Press F4 whenever you want to add a new row.
Expert Q&A
Tips
About This Article
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
