https://www.youtube.com/watch?v=HR0IOUKT01E&list=PLD14Rz0JtYhji4EqRRPEJBDFu3N2DFJ1u&index=26
Beginner
Formatting
Here’s a complete list of essential Excel formatting shortcuts for Mac, focused specifically on cell formatting, borders, number formats, alignment, font, and quick formatting tools. These shortcuts use the Mac keyboard (Command ⌘, Control ⌃, Option ⌥) conventions.
📋 GENERAL FORMATTING
| Action |
Shortcut |
| Format Cells dialog |
⌘ + 1 |
| Copy formatting (Format Painter) |
⌘ + Shift + C |
| Paste formatting |
⌘ + Shift + V |
| Bold |
⌘ + B |
| Italic |
⌘ + I |
| Underline |
⌘ + U |
| Open font tab in Format Cells |
⌘ + 1, then ⌘ + T |
| Add/Remove Outline Border |
⌘ + Option + 0 (zero) |
| Clear formatting |
Control + Space, then ⌘ + - (or use Format > Clear Formats from menu) |
🔢 NUMBER FORMATTING
| Action |
Shortcut |
| General format |
⌃ + Shift + ~ |
| Currency format |
⌃ + Shift + $ |
| Percentage format |
⌃ + Shift + % |
| Scientific format |
⌃ + Shift + ^ |
| Date format |
⌃ + Shift + # |
| Time format |
⌃ + Shift + @ |
| Number format |
⌃ + Shift + ! |
↔️ ALIGNMENT
| Action |
Shortcut |
| Center align |
⌘ + E |
| Left align |
⌘ + L |
| Right align |
⌘ + R |
| Top align |
No shortcut (use Format Cells) |
| Middle align |
No shortcut (use Format Cells) |
| Bottom align |
No shortcut (use Format Cells) |
| Wrap Text |
⌘ + Option + Return |
| Merge and Center |
No direct shortcut (use toolbar or customize ribbon) |
🖼️ BORDERS (some are limited on Mac)
| Action |
Shortcut |
| Add outline border |
⌘ + Option + 0 (zero) |
| Remove border |
⌘ + Option + - |
| Open border options |
⌘ + 1 → Borders tab |