Formatting Text and Numbers – Microsoft Excel Shortcuts
200 Excel Shortcuts for PC and Mac
So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in Excel. Well, get ready to be even fancier (and more productive) because we’ve curated 200 of the best Excel keyboard shortcuts.
Formatting Text and Numbers
Simple shortcuts to help you edit your content down to the last character. Options include bold, italics, underscore, numeric options, and more.
| Shortcut | Windows | Mac |
|---|---|---|
| Open format menu Gain control of your cell formatting instantly. The menu that appears can help you edit everything from font size to text color. | Ctrl 1 | ⌘ 1 |
| Toggle bold formatting Add or remove the bold effect to or from your text | Ctrl B | ⌘ B |
| Toggle italics formatting Add or remove the italics effect to or from your text. | Ctrl I | ⌘ I |
| Toggle underscore formatting Add or remove the underscore effect to or from you text. | Ctrl U | ⌘ U |
| Toggle strikethrough formatting Add or remove the strikethrough effect to or from you text. | Ctrl 5 | ⌘ Shift X |
| Left align the content of the cell Brings all data or text within a selected cell to the left. This is the format in which Excel cells begin. | Alt H A L | ⌘ L |
| Center align the content of the cell Brings all data or text within a selected cell to the center. | Alt H A C | ⌘ E |
| Right align the content of the cell Brings all data or text within a selected cell to the right. | Alt H A R | ⌘ R |
| Indent This shortcut increases the size of the indentation within a cell each time it is used. You can repeat as many times as is necessary for your desired format. | Alt H 6 | Control Option Tab |
| Undo indent This shortcut decreases the size of the indentation within a cell each time it is used. You can repeat as many times as is necessary for your desired format. | Alt H 5 | Control Option Shift Tab |
| Increase font by one step size Use this shortcut to increase the font size incrementally for selected text, an entire cell, or even a range of cells. Initially the size jumps are small (two per shortcut use,) but they expenotally get larger as the shortcut is used. | Alt H F G | ⌘ Shift > |
| Decrease font by one step size Use this shortcut to decrease the font size incrementally for selected text, an entire cell, or even a range of cells. Initially the size changes are large if font size is Initially large, but they get smaller as the shortcut is used more. | Alt H F K | ⌘ Shift < |
| Use scientific format Working with large numbers? This shortcut changes the format within all selected cells to a scientific-based format. When used shortcut will edit all numbers within your selection to include a single digit followed by two decimal places and your exponential. (I.E. 2.20E+03) | Ctrl Shift ^ | Control Shift ^ |
| Format cell value with currency formatting In financial mode? This shortcut changes the format within all selected cells to a currency-based format. When used shortcut will add a dollar sign and a decimal point followed by two zeros to any numbers within your selection. (I.E. $100.60) | Ctrl Shift $ | Control Shift $ |
| Format cell value with percentage formatting This shortcut changes the format within all selected cells to a percentage-based format. When used shortcut will add a percentage sign and two zeros to any numbers within your selection. (I.E. 20000%) | Ctrl Shift % | Control Shift % |
| Format cell value with date formatting If you are working with multiple dates, this shortcut can help save time by changing the format within all selected cells to a date-based format. When used shortcut will add convert your numbers to a date beginning with day, then abbreviated month, then year. | Ctrl Shift # | Control Shift # |
| Format cell value with time formatting This shortcut changes the format within all selected cells to a time-based format. When used shortcut will add convert your numbers to a time in a traditional 12 hour format. | Ctrl Shift @ | Control Shift @ |
| Format cell value with number formatting This shortcut converts all adds a decimal place followed by two zeros to all numbers within your selection. | Ctrl Shift ! | Control Shift ! |
| Format cell value with general formatting Use this shortcut to revert all numbers within your selection back to normal formatting. | Ctrl Shift ~ | Control Shift ~ |