Zahid Hasan
While working in Excel, we often use the Spin Button to quickly change the values of a cell. But, the minimum increment value of the Spin Button is 1. So theoretically, we can’t increment decimal using the Spin Button. In this article, we will discuss two simple yet efficient methods to use the Spin Button to increment decimal in Excel. So, let’s start this article and explore these methods.
Download Practice Workbook
What Is Spin Button in Excel?
The Spin Button is a handy feature of Excel. It allows us to quickly increase or decrease the values of a cell. So, we don’t need to click the cell and type in a new number if we use Spin Button. Using the Spin Button, we can also define a step value for increment.
2 Handy Methods to Use Spin Button to Increment Decimal in Excel
In this section of the article, we will learn two simple methods to use the Spin Button to increment decimal in Excel. Let’s say, we have the data of Daily Temperature Analysis as our dataset. But we need to add decimals to the Temperature. So, to do this we are going to use the Spin Button of Excel. Here, we will discuss the procedure to add both the decimal points and decimal places using the Spin Button in Excel.
Not to mention, we used the Microsoft Excel 365 version for this article; however, you can use any version according to your preference.
1. Using Spin Button to Increment Decimal Point
In the first method, we will learn to increment decimal point using the Spin Button in Excel. Now, let’s follow the steps outlined below to do this.
Step 01: Create Helper CellÂ
- Before creating the Spin Button, we will create a Helper Cell as shown in the following image.
Step 02: Apply Excel Formula
Now, we will formulate an Excel formula to increment decimal point. Using this formula is a must, as the Spin Button of Excel doesn’t allow incrementing decimal values.
- Firstly, apply the following formula in cell D5.
=C5+($B$16/10)Hare, cell C5 represents the first cell of the Temperature column, and cell B16 indicates the Helper Cell.
- Following that, press ENTER.
As a result, you will have the following output in cell D5. It is to be noted that, we will be able to increment the decimal point after we add the Spin Button.
- Then, use Excel’s AutoFill option to get the remaining outputs as shown in the image below.
Step 03: Construct Spin Button
- Firstly, go to the Developer tab from Ribbon.
- After that, click on the Insert option from the Controls group.
- Now, choose the Spin Button (From Control) option from the drop-down.
Subsequently, a Spin Button will be added to your worksheet.
Step 04: Set Format Control of Spin Button
- Firstly, right-click anywhere on the Spin Button.
- Following that, select the Format Control option.
As a result, the Format Control dialogue box will open on your worksheet.
- Now, in the Format Control dialogue box, type in 1 in the Incremental change field.
- Then, in the Cell link field, select cell B16, which is our Helper Cell.
- Lastly, click OK.
Now, our Spin Button is ready to use.
Step 05: Use Spin Button
- Firstly, click on the up arrow of the Spin Button to increment a decimal point.
Consequently, in the Corrected Temperature column, a decimal point will be added as demonstrated in the following picture.
You can click the up arrow of the Spin Button to add as many decimal points as you want. For demonstration, we clicked the Spin Button five times, and five decimal points were added in the Corrected Temperature column.
Read More: How to Control Multiple Cells with Spin Button in Excel
2. Utilizing Spin Button to Increment Decimal Place
In this section of the article, we will learn to increment decimal places by utilizing the Spin Button of Excel. So, let’s use the instructions mentioned in the following section to do this.
Steps:
- Firstly, create a Helper Cell as shown in the following image.
- After that, use the formula given below in cell D5.
=C5+(1/(10^$B$16))Here, cell C5 represents the first cell of the Temperature column, and cell B16 indicates the Helper Cell.
- Then, press ENTER.
As a result, you will have the following output in cell D5.
- Afterward, use Excel’s AutoFill feature to get the rest of the outputs as shown in the following image.
- Now, use the steps mentioned in Step 3, and Step 4 of the previous method to create and format the Spin Button.
Consequently, you will have the following Spin Button on your worksheet.
- After that, click on the up arrow of the Spin Button.
Subsequently, one decimal place will be added in the Corrected Temperature column.
You can click on the up arrow of the Spin Button to add as many decimal places as you want to add. For instance, we clicked the up arrow of the Spin Button three times and as a result, three decimal places were added to the cells of the Corrected Temperature column as demonstrated in the following image.
Read More: How to Create Spin Button with VBA in Excel (3 Useful Methods)
Practice Section
In the Excel Workbook, we have provided a Practice Section on the right side of the worksheet. Please practice it yourself.
Conclusion
So, these are the most common and effective methods you can use anytime while working with your Excel datasheet to use the Spin Button to increment decimal in Excel. If you have any questions, suggestions, or feedback related to this article, you can comment below. You can also have a look at our other useful articles on Excel functions and formulas on our website, ExcelDemy, a one-stop Excel solution provider.
