Drag the border of the spin button to resize it.You can move it by dragging and dropping. If this case, we want to place it at the left side of the "Quantity" cell. Click the location where you want to place the spin button to create it. In the "Form Controls" section, click "Spin Button" (the forth in the list).In the "Controls" ribbon group, pull down "Insert".Now Excel shows the "Developer" ribbon.In the "Customize the ribbon" section, check the "Developer" option.Right-click an empty area on Excel ribbon, choose "Customize the ribbon".If this tab is not available in your Excel, do the following to make it visible. Switch to Excel "Developer" ribbon tab.Push down "Design Mode" button on the "Invoice" ribbon tab.As always, backup your invoice template.Now let's see how we can add the spin buttons to "c4020 Invoice Template with Long Product Description". On the other hand, in a hotel receipt template where the number of guests is always an integral number that changes in a small range, a spin number is suitable for the situation. For example, in the invoice templates based on hours and rates, where the decimal part could appear on the number of hours, a spin button is not suitable. If your products are always sold in a whole part and thus don't use the decimal part in the "Quantity" field, a spin button could be applied. It is suitable for adjustment integral numbers in a small range.
![add spin button excel add spin button excel](https://i.ytimg.com/vi/oYKMGTIHVTU/maxresdefault.jpg)
The spin button is used to add one or subtract one from a number. ActiveX controls are small piece of programs outside Excel (and Office), where form controls could be seen an integrated / built in component of Excel (and Office). The difference between form controls and ActiveX controls is that, besides the appearance, they are in fact two completely different technologies. For example, the "Taxable" checkbox could be either implemented using ActiveX control, or a form control - in the standard invoice template shipped with Invoice Manager for Excel setup program, it use checkbox in the form control category. Here on we've already published samples on using form controls. The spin button we'll use here one of the control in the "Form Controls" toolset, which is available in all the major apps in the Microsoft Office product family, like Excel (".xls" or ".xlsx"), Word (".doc" or ".docx"), Visio, Publisher, PowerPoint. They are pure-Excel templates with no macro, and no password-protection.
#ADD SPIN BUTTON EXCEL FREE#
Just like what you'll see from this example, our free templates are customizable.
#ADD SPIN BUTTON EXCEL HOW TO#
This customized invoicing format is based on c4020 Invoice Template with Long Product Description, which describes how to reduce the number of lines on the detail section, so that each line can hold longer description text. The spin button allows you add one or subtract one from a number.
![add spin button excel add spin button excel](https://i.ytimg.com/vi/RWgySRg8_bk/maxresdefault.jpg)
With this sample invoice template we demonstrates how to spin button, which is one of the Microsoft Forms Controls.