Indezine Logo




Keyboard Sequences for Excel 365 for Windows

Explore keyboard sequences in Excel 365 for Windows. These Excel keyboard sequences will help you quickly complete tasks.


Author:

Product/Version: Excel 365 for Windows

OS: Microsoft Windows 10 and higher


 

 

Keyboard Sequences for PowerPoint 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

Excel Keyboard Sequences: 365 for Windows

Alignment

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.

Align options in Excel
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

Back

Merge Cells

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.

Merge menu options
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

Back

File Options

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.

Backstage view options
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.

Back

Clipboard

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.

Back

Borders

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.

Back

Rows and Columns

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).

Back

Font Formatting

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.

Back

Number Formatting

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.

Back

Cell Sizing

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.

Back

Sorting

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).

Back

Conditional Formatting

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.

Highlight Cells Rules

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:

Highlight Cells in Conditional Formatting
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...

Back

You May Also Like: First Impressions Last, by Jerry Weissman | Credit Cards PowerPoint Templates


Popular Posts

Use Safe Fonts Available on All Systems in PowerPoint
Use Safe Fonts Available on All Systems in PowerPoint
Learn about using safe fonts in PowerPoint.

10 Tips for Pecha Kucha
10 Tips for Pecha Kucha
Read 10 amazing Pecha Kucha tips that will help you create and deliver a better Pecha Kucha presentation.

Creating Slide Backgrounds in Photoshop for PowerPoint
Creating Slide Backgrounds in Photoshop for PowerPoint
Learn how to create slide backgrounds for PowerPoint in Photoshop.

Formatting Arrows (Arrowheads) in PowerPoint 2016 for Windows
Formatting Arrows (Arrowheads) in PowerPoint 2016 for Windows
Learn how to format arrowheads for lines in PowerPoint 2016 for Windows.



Ebook PowerPoint Keyboard Shortcuts

PowerPoint Keyboard Shortcuts and Sequences Ebook

PowerPoint 365, 2019, 2016, 2013, 2011, 2010, 2007 and 2003 for Windows

PowerPoint 365, 2019, 2016 and 2011 for Mac

PowerPoint for the Web on Windows and Mac

Have you ever used keyboard shortcuts and sequences in PowerPoint? Or are you a complete keyboard aficionado? Do you want to learn about some new shortcuts? Or do you want to know if your favorite keyboard shortcuts are documented?

Go and get a copy of our PowerPoint Keyboard Shortcuts and Sequences ebook.


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

Home | PowerPoint | Photoshop | PowerPoint Templates | PowerPoint Tutorials | Blog | Notes | Ezine | Media Kit | Feedback | Site Map | About Us | Contact Us

Link to Us | Privacy | Testimonials

PowerPoint Backgrounds | Christian PowerPoint Backgrounds | Business PowerPoint Presentation Templates

Plagiarism will be detected by Copyscape

©2000-2026, . All rights reserved.