Spreadsheet legibility requires properly proportioned column widths and row heights. Truncated text strings and ###### numeric overflow errors occur when column dimensions are improperly configured. Mastering manual sizing, AutoFit shortcuts, and row/column insertion keeps worksheets organized.
Adjusting Column Widths & Row Heights
Manual Dragging: Position your mouse cursor directly on the boundary line between two column headers (e.g., between B and C). The cursor transforms into a double-headed horizontal arrow. Click and drag left or right to resize.
Exact Dimension Dialog:
Right-click the column letter header and select Column Width.... Enter a specific numeric character width (default is 8.43).
Right-click row number header and select Row Height.... Enter a specific point height (default is 15.00 pt).
The AutoFit Magic (Double-Click)
Instead of manually guessing the correct column width:
1
Move your cursor to the right boundary line of the column header until the double-headed arrow appears.
2
Double-click the mouse button!
3
Excel instantly AutoFits the column width to accommodate the longest cell entry in that entire column.
4
AutoFit Entire Sheet at Once:
Click the top-left Select All triangle (above Row 1, left of Column A) or press Ctrl + A.
Double-click any column boundary. Every single column across the entire worksheet auto-fits to its contents in a fraction of a second!
Keyboard Shortcut: Press Alt + H + O + I to AutoFit column widths automatically.
Inserting and Deleting Columns & Rows
Inserting a Column: Right-click any column header letter (e.g., Column D) and select Insert. Excel inserts a new blank column to the left of the selected column. Existing columns shift right.
Inserting a Row: Right-click any row header number (e.g., Row 5) and select Insert. Excel inserts a new blank row above the selected row. Existing rows shift down.
Keyboard Shortcuts:
Select an entire row: Shift + Spacebar.
Select an entire column: Ctrl + Spacebar.
Insert row/column: With row or column selected, press Ctrl + Shift + + (Ctrl and plus).
Delete row/column: With row or column selected, press Ctrl + - (Ctrl and minus).
Hiding and Unhiding Rows and Columns
To temporarily conceal sensitive calculations or intermediate formula steps without deleting them:
Hiding: Select the columns or rows, right-click the header, and select Hide (Shortcuts: Ctrl + 0 to hide column, Ctrl + 9 to hide row).
Unhiding: Highlight the columns or rows immediately surrounding the hidden area (e.g., select columns C and E to reveal hidden column D), right-click the selection, and select Unhide.
Interactive Quiz• Knowledge Check
Multiple Choice Questions
Question 1
What happens when you double-click the boundary line between two column headers (e.g., between Column B and C)?
Question 2
Which keyboard shortcut selects the entire active row across the spreadsheet grid?
Question 3
When you insert a new column into an Excel worksheet, where does the new column appear relative to your selected column?
Question 4
Which keyboard shortcut hides the currently selected rows?
Question 5
What ribbon shortcut sequence executes "AutoFit Column Width" across selected cells without using the mouse?
Next Lesson
Understanding Formula Bar
Continue learning with hands-on practice, examples, and exercises in the upcoming topic.