Press 0 (zero) to apply Increase Decimal.Select a cell or cell range containing numbers.Selecting Increase Decimal or Decrease Decimal using the keyboard Press Escape if you want to exit key tip mode.

Press the appropriate badge letter to choose the command in the active tab.

Press the appropriate badge letter to activate the desired tab.

The key tip badges appear for the active tab. Once you choose an option (a letter), then a new set of options appear. To choose commands in the Ribbon using key tips or badge letters:

You can also press F10 instead of Alt.īelow is an activated Ribbon after the user has pressed Alt:Ĭhoosing Ribbon commands using the keyboard Key tips will appear in the Ribbon as a small label or badge. Press Alt to activate keyboard control in the Ribbon. If the Ribbon is not showing, press Ctrl + F1. Recommended article: How to Delete Blank Rows in Excel (5 Ways)ĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses > Activating keyboard control in the Ribbon However, you can press Alt to access the Ribbon or Quick Access Toolbar and then use your keyboard to increase or decrease decimal places. Increase or Decrease Decimals Using Your Keyboardīy Avantix Learning Team | Updated April 7, 2021Īpplies to: Microsoft ® Excel ® 2013, 2016, 2019 and 365 (Windows)Īlthough 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.

Key shortcuts for excel 2016