ShortcutdrillInsert a column through the dialog
An Excel shortcut drill from Shortcutdrill. Solve it with a live sheet in your browser with a limit on key presses, and it is checked the moment you submit.
The task
You are in D5 with no column selected. Insert a blank column before Units using the Insert dialog, so Units moves to column E.
What this drill teaches
From a single cell, Ctrl+Shift+= opens the Insert dialog: C is Entire column, R is Entire row. With a whole column selected the dialog is skipped.
A hint if you get stuck
Windows: Ctrl+Shift+=, C, Enter. Mac: Cmd+Shift+=, then Entire column, Return. The drill allows 2 key presses.
This drill is part of Pro
Pro unlocks all 103 drills, with worked solutions and progress saved to your account. The free drills work without an account.
Annual starts with a 7-day free trial: $0 today, cancel before November 12, 2026 and you are not charged. 14-day refund on every plan, no questions. Cancel a subscription in one click. Founding price until 31 December 2026. Students: 50% off annual with a .edu or .ac email.
More drills in Grouping and structure
- Group the detail rowsPro
- UngroupPro
- Collapse all groupsPro
- Insert a sheetFree
- Rename the sheetPro
- Insert a columnFree
- Delete the blank rowFree
- Select the current regionFree
- Select to the end of the columnFree
- Extend across the row and downFree
- Delete three rows at oncePro
- Delete the scratch columnPro
- Delete a row through the dialogPro
- Expand the groupPro
- Hide the rowsPro
- Unhide the rowsPro
- Hide the column you are inPro