Now look in the right-hand panel, check the Developer checkbox, and click OK.Ĭlick the Developer tab on the Ribbon, and select Insert (within the Developer tab–don’t click the Ribbon’s Insert tab) to view the Form Controls collection. To display the Developer tab, choose File > Options > Customize Ribbon. The Form Controls are on the Developer tab on the Ribbon, which isn’t visible by default and must be enabled.The key to utilizing these features lies in Excel’s Form Controls, which are accessible only from the Developer tab–and that tab isn’t visible in Excel by default. Read on, and I’ll show you how to accomplish these and several other cool Excel tricks. Or, if you wish to limit a spreadsheet user to selecting from a few preset choices, a set of option buttons will do.
If you’re developing a spreadsheet that you’ll use over and over again, inserting a spin button or scrollbar will allow you to choose from a predefined range of values using your mouse, instead of typing numbers in with the keyboard. Looking to become an Excel power user? Excel has a number of features that will make it easier for you and your colleagues to enter data into your spreadsheets.
0 kommentar(er)
