Using Spin Button to Increment Decimal in Excel (2 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.


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.


How to Use Spin Button to Increment Decimal in Excel: 2 Handy Methods

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.

excel spin button increment decimal

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.

Create Helper Cell to Increment Decimal Point in Excel

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.

Apply Excel Formula to use the Spin Button to increment decimal in Excel

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.

Constructing Spin Button to use the Spin Button to increment decimal in Excel

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.

Setting Format Control of Spin Button to use the Spin Button to increment decimal in Excel

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.

Using Spin Button to use the Spin Button to increment decimal in Excel

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.

Final output of method 1 to use the Spin Button to increment decimal in Excel

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.

Utilizing Spin Button to Increment Decimal Place in Excel

  • 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.

Consequently, you will have the following Spin Button on your worksheet.

Creating Spin Button to use the Spin Button to increment decimal in Excel

  • 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.

Final output of method 2 to use the Spin Button to increment decimal in Excel

Read More: How to Use Spin Button in Excel 


Practice Section

In the Excel Workbook, we have provided a Practice Section on the right side of the worksheet. Please practice it yourself.

Practice section to use the Spin Button to increment decimal in Excel


Download Practice Workbook


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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Zahid Hasan
Zahid Hasan

Hello and welcome! Thank you for visiting my profile. I am currently employed as an Excel & VBA Content Creator at ExcelDemy. My most recent academic qualification is a BSc (Eng) from the Bangladesh University of Engineering and Technology. Industrial and Production Engineering was my major. I constantly attempt to think creatively and find a simple answer.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo