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.The Options dialog box appears and In the categories on the left, Quick Access Toolbar should be selected. Click the arrow to the right of the Quick Access Toolbar and select More Commands.To rearrange buttons in the Quick Access Toolbar: 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).Īt 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.Right-click Increase Decimal on the Home tab in the Ribbon and select Add to Quick Access Toolbar from the drop-down menu.To add Increase Decimal and Decrease Decimal to the Quick Access Toolbar:
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. 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). Press 9 to apply Decrease Decimal.Īdding Increase Decimal or Decrease Decimal to the Quick Access Toolbar 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.
#KEYBOARD SHORTCUTS FOR EXCEL 2016 FILL CELL HOW TO#
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.