Add the function buttons Up and Down in Excel
TipsMake.com - In the following article, we will introduce you some basic steps to assign the Up and Down function buttons in Excel spreadsheet. To do this, we need to enable the ribbon Developer - operating mode, which is a function tab that has been set up according to certain standards and is available in the default mode. Activating and using this tab is often simpler and much faster than the self-setup tab, the steps below are applied on Microsoft Outlook 2010, but for Excel or Word 2010 , the steps are taken. same.
First, open Office 2010, then click the File menu > Options:
Add the function buttons Up and Down in Excel Picture 1
Options window displays, select Customize Ribbon and then tick the Developer box below the Main Tabs section. Click OK to save the changes:
Add the function buttons Up and Down in Excel Picture 2
And the Developer tab will display in the toolbar in the form of ribbon as shown below:
Add the function buttons Up and Down in Excel Picture 3
Here, you click Insert> Spin Button:
Add the function buttons Up and Down in Excel Picture 4
Next, select the data line to set these buttons:
Add the function buttons Up and Down in Excel Picture 5
Select Spin Button and click Properties :
Add the function buttons Up and Down in Excel Picture 6
The corresponding options for this function button will display, you press Control and enter data as required. This link value section will display in the spreadsheet and be applied directly via this value increase or decrease button:
Add the function buttons Up and Down in Excel Picture 7
Good luck!
You should read it
- MS Excel 2007 - Lesson 1: Start Microsoft Excel 2007
- How to Use Office 2003 Menus and Toolbars in Microsoft Office 2007 and 2010
- How to hide and show the Ribbon toolbar in Word and Excel
- MS Word - Lesson 1: Start with Microsoft Word 2007
- Microsoft launched Office 2010
- Hide the Ribbon toolbar in Word 2013
- 4 essential tips for managing Excel Ribbon
- Office 2013 preliminary assessment: Many new features
- Guide to full Excel 2016 (Part 2): Learn about OneDrive
- Complete guide to Excel 2016 (Part 13): Introduction to formulas
- Instructions on how to use Outlook from AZ for beginners
- Microsoft Office Web Apps: Not as expected