1
Shift + Space / Ctrl + SpaceSelect the target row or column
Clearly identify what you want to hide.
hideunhiderow column management
Practical Guide to Hiding and Unhiding Rows and Columns with Shortcuts
Thinking of hiding information temporarily rather than deleting it permanently makes report building much easier. Hide shortcuts are the entry point to that approach.
Shortcuts you will master in this article
Ctrl + 9 / Ctrl + Shift + 9 / Ctrl + 0
How you handle information you want to keep but not show determines your productivity
Helper calculation columns, internal note rows, and interim columns you want to keep but not display are surprisingly common. Using hide lets you maintain the source data while presenting a clean layout.
Learning the unhide shortcuts at the same time removes the anxiety of 'hiding something you can't get back.'
Basics of hiding and unhiding
Selecting the target first makes the operations easier to execute.
2
Ctrl + 9 / Ctrl + 0Hide a row or column
Temporarily conceal supplementary information to focus attention where it matters.
3
Ctrl + Shift + 9Unhide a row
The basic shortcut for restoring a hidden row.
4
Ctrl + Shift + 0Unhide a column with adjacent columns in mind
Select the columns on both sides of the hidden column, then unhide. If the shortcut is inactive in your environment, use the Ribbon instead.
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.
Practical uses of hide shortcuts
Ideal for submission versions where you want to hide helper columns while preserving the source data.
To avoid forgetting what is hidden, combine hiding with naming conventions or color coding for critical columns.
Mixing filters and hide can become hard to track — use each for its intended purpose.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + 9 | Hide Row |
Ctrl + 0 | Hide Column |
Ctrl + Shift + 9 | Unhide Row |
Ctrl + Shift + 0 | Unhide Column |
Shift + Space | Select Entire Row |
Ctrl + Space | Select Entire Column |
Frequently Asked Questions
Q. When should I hide versus delete?
A. Hide if there is any chance you will need the data again; delete only when you are certain it is no longer needed.
Q. I unhid but a column did not come back.
A. You may have multiple columns hidden together. Try re-selecting a wider range including surrounding columns.
Q. What happens to hidden columns when printing?
A. Normally they are not printed, which makes hiding useful for preparing submission-ready layouts.
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スキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →