1
Shift + SpaceSelect the entire row
The prerequisite for inserting or deleting a row.
insert rowsdelete columnsstructural changes
Speed Up Row and Column Insertion/Deletion with Ctrl+Shift++/Ctrl+-
Inserting or deleting rows and columns mid-table is a constant task. Leaving this mouse-dependent slows down your entire reorganization workflow.
Shortcuts you will master in this article
Ctrl + Shift + + / Ctrl + - / Shift + Space / Ctrl + Space
Learn structural changes together with selection shortcuts for maximum speed
The insertion or deletion itself is instant, but selecting the target row or column beforehand is where time gets lost. That is exactly why you need to learn selection shortcuts alongside insert/delete shortcuts.
Row and column operations have wide impact, so confirming the target is just as important as acting quickly.
Basic flow for inserting and deleting rows and columns
Chaining selection through execution eliminates the need for the mouse entirely.
2
Ctrl + SpaceSelect the entire column
Use this before adjusting column width or deleting a column.
3
Ctrl + Shift + +Insert a row or column
Quickly adds an empty space where you need it.
4
Ctrl + -Delete an unnecessary row or column
Confirm the target before executing.
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Tips for avoiding accidents during structural changes
Deleting rows while a filter is active can affect data beyond what you intend — proceed with caution.
In tables with many formula references, verify that nothing breaks after deletion.
Always confirm the result while Undo is still available.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Shift + Space | Select Entire Row |
Ctrl + Space | Select Entire Column |
Ctrl + Shift + + | Insert Cells/Rows/Columns |
Ctrl + - | Delete Cells/Rows/Columns |
Frequently Asked Questions
Q. Is inserting a cell the same as inserting a row?
A. The behavior can differ depending on what is selected. Selecting an entire row or column first keeps the intent unambiguous.
Q. My formulas break after deletion.
A. You may be deleting a column or row that other cells reference. Always check immediately after deleting in important tables.
Q. Is it really faster than using the mouse?
A. When you keep the entire flow on the keyboard — including selection — the difference becomes significant in repetitive work.
Q. How do I memorize Excel shortcuts faster?
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →