Explore keyboard sequences in Excel 365 for Windows. These Excel keyboard sequences will help you quickly complete tasks.
Author: Geetesh Bajaj
Product/Version: Excel 365 for Windows
OS: Microsoft Windows 10 and higher
Many users are familiar with keyboard shortcuts for Excel 365 for Windows, yet there are no real shortcuts for tasks users need to perform all the time. This includes center-aligning cell content.
Thankfully, there are many keyboard sequences that work for these tasks in Excel 365 for Windows. Most sequences require that you press two keys together, release them, and then press the next key.
So, if the keyboard sequence is listed as Alt + H > B, then you must press the Alt and H keys together, let go of those two keys, and then press the B key.
If you discover a keyboard sequence not listed here, please get in touch with us through our feedback form.
Alignment
Merge Cells
File Options
Clipboard
Borders
Rows and Columns
Font Formatting
Number Formatting
Cell Sizing
Sorting
Conditional Formatting
Do note that cell content will align within the cell itself. Select cell(s) and use these options:
Alt + H > A
Highlights the Align options.

Figure 1: Align options in Excel
Next, choose any of these options, as shown highlighted in red within Figure 1, above. The last key is what you need to press because you have already pressed the first three (Alt + H > A).
Alt + H > A > L
Left-align cell contents
Alt + H > A > C
Center-align cell contents
Alt + H > A > R
Right-align cell contents
Alt + H > A > T
Top-align cell contents
Alt + H > A > M
Middle-align cell contents
Alt + H > A > B
Bottom-align cell contents
Select cells that you want to merge or unmerge and use these sequences:
Alt + H > M
First, open the Merge menu, as shown highlighted in red within Figure 2, below.

Figure 2: Merge menu options
Next, continue by clicking on any of these options. The last key is what you need to press because you have already pressed the first three.
Alt + H > M > C
Merge & Center selected cells.
Alt + H > M > A
Merge selected cells into one larger cell.
Alt + H > M > M
Merge selected cells row by row, and not as one block.
Alt + H > M > U
Unmerge existing merged cells.
Alt + H > W
Wrap text within cells
Yes, Excel provides many keyboard shortcuts for essential file operations such as open, save, print, etc. But there are some operations that not served by keyboard shortcuts. Fortunately, they have keyboard sequences listed below.
Alt + F
First, bring Backstage view.
You will now see the options highlighted in red within Figure 3, below.

Figure 3: Backstage view options
Next, choose any of these options. The third (and fourth) key is what you need to press because you have already pressed the first two (Alt + F).
Alt + F > A
Save as option.
Alt + F > Z
Share option.
Alt + F > I
Brings up the Info pane.
Alt + F > I > F
Open File location.
Alt + F > E
Brings up the Export pane.
Alt + F > D
Brings up the Account pane.
Alt + F > T
Brings up the Excel Options dialog box.
Copy content to the clipboard and then use any of these:
Alt + H > V
Open the Paste gallery.
Alt + H > V > V
Paste clipboard content as values ignoring any formulas.
Alt + H > V > A
Paste clipboard content as values retaining number formatting.
Alt + H > V > F
Paste clipboard content as formulas.
Alt + H > V > K
Paste clipboard content retaining source formatting.
Alt + H > V > T
Paste clipboard content and transpose data.
Alt + H > V > U
Paste clipboard content as a picture.
Alt + H > F > P
Format Painter picks up attributes of the selected cell. Click on any other cell to apply those attributes.
Alt + H > B
Open the Borders menu.
Alt + H > B > A
Apply all borders.
Alt + H > B > N
Remove borders.
Alt + H > B > S
Apply outside border.
Alt + H > B > T
Apply thick outside border.
Alt + H > B > B
Apply bottom double border.
Alt + H > B > H
Apply thick bottom border.
Alt + H > B > D
Apply top and bottom borders.
Alt + H > B > C
Apply thick top and bottom borders.
Alt + H > I > R
Insert row after selected row or cell(s).
Alt + H > I > C
Insert column after selected column or cell(s).
Alt + H > D > R
Delete selected row or row containing selected cell(s).
Alt + H > D > C
Delete selected column or column containing selected cell(s).
Select text or cell(s) containing text, and use these keyboard sequences:
Alt + H > F > G
Increase font size.
Alt + H > F > K
Decrease font size.
Alt + H > H
Bring up the Fill color drop-down gallery.
Alt + H > F > C
Bring up the Font color drop-down gallery.
Alt + H > N
Open the Number Format gallery.
Alt + H > A > N
Apply the Currency format.
Alt + H > P
Apply the Percentage format.
Alt + H > O
Increase decimal places.
Alt + H > 9
Decrease decimal places.
Alt + H > O
Bring up the drop-down gallery for Cell Size and other parameters.
Alt + H > O > I
AutoFit column width.
Alt + H > O > A
AutoFit row height.
Alt + H > O > W
Bring up the Column Width window where you can type in a value.
Alt + H > O > H
Bring up the Column Height window where you can type in a value.
Alt + H > O > D
Set default width of cells.
Select contiguous cells, and then use:
Alt + H > S
Bring up the Sort and Filter drop-down gallery.
Alt + H > S > S
Sort Smallest to Largest (or Oldest to Newest, or A to Z).
Alt + H > S > O
Sort Largest to Smallest (or Newest to Oldest, or Z to A).
Alt + H > S > F
Toggles the AutoFilter option on and off for contiguous cells.
Alt + H > S > U
Custom Sort (opens the Sort dialog box).
Do note that cell content will align within the cell itself. Select cell(s) and use these options:
Alt + H > L
Bring up the Conditional Formatting drop-down gallery.
Alt + H > L > H
First, select cells, and open the Highlight Cells Rules submenu.
Next, choose any of these options, as shown highlighted in red within Figure 1, below:

Figure 1: Highlight Cells in Conditional Formatting
G
Greater Than...
L
Less Than...
B
Between...
E
Equal To...
T
Text That Contains...
A
A Date Occurring...
D
Duplicate Values...
You May Also Like: First Impressions Last, by Jerry Weissman | Credit Cards PowerPoint Templates



Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.