Chapter 17. CUSTOMIZING EXCEL
Add a Form Control to a Worksheet
You can add controls to a worksheet to make it easier to enter data into a cell. Form controls can aid users who are not familiar with Excel and can increase the accuracy of data entry by limiting the options a user has. For example, you can add check boxes to your worksheet so your worksheet looks like a paper form. You can also add a combo box from which users can select an entry.
Excel provides nine controls you can add to a worksheet. You add controls by selecting the control you want from the Form Controls menu. After you add a control, you can adjust its size by dragging the side or corner handles. When you add a control or when you right-click a control twice and then click the ...
Get Excel® Data Analysis: Your visual blueprint™ for creating and analyzing data, charts, and PivotTables, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
