Increase or Decrease Decimals Using Your Keyboard

by Avantix Learning Team | Updated April 7, 2021

Applies to: Microsoft® Excel® 2013, 2016, 2019 and 365 (Windows)

Although there are shortcuts to apply number formatting in Microsoft Excel using the Ctrl key, there are not comparable keyboard shortcuts to increase or decrease decimal places for numbers. However, you can press Alt  to access the Ribbon or Quick Access Toolbar and then use your keyboard to increase or decrease decimal places.

Recommended article: How to Delete Blank Rows in Excel (5 Ways)

Do you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses >

Activating keyboard control in the Ribbon

If the Ribbon is not showing, press Ctrl + F1.

Press Alt to activate keyboard control in the Ribbon. Key tips will appear in the Ribbon as a small label or badge. You can also press F10 instead of Alt.

Below is an activated Ribbon after the user has pressed Alt:

Microsoft Excel Tibbon with key tips or bades.

Choosing Ribbon commands using the keyboard

To choose commands in the Ribbon using key tips or badge letters:

  1. Press Alt. Key tips or badges appear on the Ribbon. One layer of badges appear at a time. Once you choose an option (a letter), then a new set of options appear. The key tip badges appear for the active tab.
  2. Press the appropriate badge letter to activate the desired tab. Do not press Shift.
  3. Press the appropriate badge letter to choose the command in the active tab.
  4. Press Escape if you want to exit key tip mode.

Selecting Increase Decimal or Decrease Decimal using the keyboard

To increase or decrease decimals:

  1. Select a cell or cell range containing numbers.
  2. Press Alt. Key tips appear in the Ribbon.
  3. Press H to access the Home tab. Do not press Shift.
  4. Press 0 (zero) to apply Increase Decimal. Press 9 to apply Decrease Decimal.

Adding Increase Decimal or Decrease Decimal to the Quick Access Toolbar

You may want to display the Quick Access Toolbar below the Ribbon and add buttons to it (it’s displayed above the Ribbon by default). To display the Quick Access Toolbar below the Ribbon, click the arrow to the right of the Quick Access Toolbar and select Show Below the Ribbon.

To add Increase Decimal and Decrease Decimal to the Quick Access Toolbar:

  1. Right-click Increase Decimal on the Home tab in the Ribbon and select Add to Quick Access Toolbar from the drop-down menu.
  2. Repeat for Decrease Decimal.
  3. Press Alt and note that numbers appear on the buttons in the Quick Access Toolbar (so if you press Alt and then 1, you would access the first command).

At this point, you may want to move your most frequently-used buttons to the beginning of the Quick Access Toolbar so that Alt and 1 would access the first button, Alt and then 2 would access the second button and so on.

To rearrange buttons in the Quick Access Toolbar:

  1. Click the arrow to the right of the Quick Access Toolbar and select More Commands. The Options dialog box appears and In the categories on the left, Quick Access Toolbar should be selected.
  2. On the right, under Customize Quick Access Toolbar, click the button you wish to move and click the up arrow to move the button up. or the down arrow to move the button down. Continue clicking the up or down arrows until the button is in the desired position.
  3. Repeat for other buttons.
  4. Click OK.

Below is the Microsoft Excel Options dialog box where you can rearrange buttons:

Microsoft Excel Options dialog box for the Customize Quick Access Toolbar category.

Note that the Increase Decimal and Decrease Decimal buttons have been placed at the beginning of the Quick Access Toolbar in the following example:

Customized Quick Access Toolbar with Increase and Decrease Decimal buttons.

It’s definitely a good idea to rearrange the buttons in the Quick Access Toolbar so your most frequently-used buttons appear in the first nine positions.

Subscribe to get more articles like this one

Did you find this article helpful? If you would like to receive new articles, join our email list.

More resources

How to Fill Blank Cells in Excel with a Value from a Cell Above

How to Use Flash Fill in Excel to Clean or Extract Data (Beginner’s Guide)

Automatically Sum Rows and Columns Using the Quick Analysis Tool

Related courses

Microsoft Excel: Intermediate / Advanced

Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools

Microsoft Excel: Introduction to Visual Basic for Applications (VBA)

VIEW MORE COURSES >

Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada (some live classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if you'd like to arrange custom training on a date that's convenient for you.

Copyright 2021 Avantix® Learning

You may also like

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

You can apply strikethrough to text or values in Excel to cross out or create a line through a cell or part of a cell. There are 3 common ways to apply strikethrough in your Excel worksheets – using a built-in keyboard shortcut, using the Font dialog box, or by adding a command to the Quick Access Toolbar.

How to Lock the Position of a Slicer in Excel

How to Lock the Position of a Slicer in Excel

Slicers are a great tool in Excel to filter tables or pivot tables. You can lock the position of a slicer in an Excel worksheet using a two-step process. First, select the slicer or slicers and Disable resizing and moving in the Format Slicer task pane (and choose other options based on your preferences). Second, protect the sheet using the Review tab in the Ribbon. There are a few important options you’ll need to select to get this to work.

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca

Summary
How to Increase or Decrease Decimal Places in Microsoft Excel Using Keyboard Shortcuts
Article Name
How to Increase or Decrease Decimal Places in Microsoft Excel Using Keyboard Shortcuts
Description
Although there are shortcuts to apply number formatting in Microsoft Excel using the Ctrl key, there are not comparable keyboard shortcuts to increase or decrease decimal places for numbers. However, you can press Alt  to access the Ribbon or Quick Access Toolbar and then use your keyboard to increase or decrease decimal places.
Author
Publisher Name
Avantix Learning

Pin It on Pinterest

Share This