This article was written by Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for wikiHow. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
This article has been viewed 1,063 times.
There are ways in Excel to use your keyboard to add rows. You can use shortcuts on a PC/Mac or tablet, as long as you have a keyboard. This wikiHow will show you how to use shortcuts to insert rows in Excel.
Steps
-
1Open an Excel worksheet. You can open a saved document or start a new one.
- This method works with any keyboard, either using the computer program or mobile application, on Mac or PC.
-
2Select the cell you want to add a row above. This can be any cell within a row.
- You can use your mouse to select a cell, or press Ctrl+G (Windows) or ⌘ Cmd+G (Mac) to pull up a cell-selection window.[1]
-
3Press ⇧ Shift+Spacebar to select the entire row.
- If you want to add multiple rows, press and hold ⇧ Shift as you use the arrow keys to select nearby rows.
-
4Press ⇧ Shift+Ctrl++ (Windows) or ⇧ Shift+⌘ Cmd++ (Mac). New rows will be inserted above your selection.
References
About This Article
1. Open your Excel document.
2. Select a cell and press Shift+spacebar to select the row.
3. Press Ctrl/Cmd+Shift++.
