Formatting shortcuts for beautifully and efficiently setting cell formats and table designs

Ctrl+B

Apply bold formatting

Applies or removes bold formatting from selected text.

💡 Hint: Bold

🎯 Make important data bold for visual emphasis

Ctrl+I

Apply italic formatting

Applies or removes italic formatting from selected text.

💡 Hint: Italic

🎯 Make supplementary information italic for hierarchical information display

Ctrl+U

Apply underline formatting

Applies or removes underline formatting from selected text.

💡 Hint: Underline

🎯 Add underlines to headings and key data to visualize importance

Ctrl+1

Open Format Cells dialog

Opens the Format Cells dialog box.

💡 Hint: 1 = number one formatting

🎯 Create professional tables with detailed cell formatting settings

Ctrl+9

Hide the selected rows

Hides the selected rows.

💡 Hint: 9 = hide rows

🎯 Hide unnecessary rows to organize data display

Ctrl+0

Hide the selected columns

Hides the selected columns.

💡 Hint: 0 = hide columns

🎯 Hide unnecessary columns to organize data display

Microsoft Excel