1
Ctrl + SpaceSelect the entire column
Select the target column in one keystroke.
column widthrow heightauto-fit
How to Auto-Fit Column Width and Row Height Using Only the Keyboard
Unreadable tables are more often caused by cramped column widths than by the volume of data. Learning auto-fit makes readability improvements instant.
Shortcuts you will master in this article
Alt + H, O, I / Ctrl + Space / Shift + Space
Manual column width adjustment has no clear endpoint
Dragging to micro-adjust column widths in a table with many columns eats up time on its own. Auto-fit based on content is both faster and produces a more consistent appearance.
The same applies to row height — combined with text wrap, it can dramatically improve readability.
How to think about auto-fit
Rather than adjusting individually, use auto-fit first to establish a baseline.
2
Alt + H, O, IAuto-fit the column width
Quickly aligns width to match the content.
3
Shift + SpaceSelect the entire row
The starting point when you want to adjust row height.
4
Alt + H, W → auto-fitMake long-text cells readable
Enable text wrap first, then auto-fit row height. Comments and notes columns will fit neatly.
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.
Tables that benefit most from auto-fit
Great for lists right after import where column widths are irregular.
Useful before submission to check for truncated text or #### display errors.
For forms requiring fixed widths, auto-fit first and then fine-tune where needed.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + Space | Select Entire Column |
Shift + Space | Select Entire Row |
Frequently Asked Questions
Q. Can I auto-fit all columns at once?
A. You can, but for formatted submission documents it may disrupt the layout — limiting the scope is safer.
Q. What causes #### to appear?
A. The column is too narrow to display the value, typically a date or number.
Q. Does row height auto-fit work well too?
A. Yes, especially effective when combined with text wrap.
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スキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →