

The pictures in the help file obviously aren't visible, but it shouldn't matter. To add a spinner to a cell, click on the Developer ribbon at the top of Excel. If you want to hide the detail rows for April and May, you can do so by outlining the list manually.īecause the totals in this list were typed as numbers, not calculated as formulas, automatic outlining won't work. For example, you'll need to manually outline data if the rows or columns of summary data contain values instead of formulas, such as in the example below. Outlining a worksheet manually If the data is not organized so that Excel can outline it automatically, you can create an outline manually. The summary data must be adjacent to the detail data. The following image is the Excel Page Setup dialog, which uses controls extensively so that the user can choose the appropriate options for the page setup of. Outlining a worksheet automatically If you have summarized data by using formulas that contain functions, such as SUM, Excel can automatically outline the data, as in the preceding example. Inserting automatic subtotals also creates an outline If you use the Subtotal command (Data menu) to add subtotals to a list organized in rows, Excel outlines the worksheet so that you can show or hide as much detail as you need. Step 2: Choose the spin button icon from the drop down list and make sure the button you choose is under the activex controls. To create a spin button, follow the steps: Step 1: Go to the developer tab and click on the insert button. In Excel 2007, click the Microsoft Office. In Excel 2010 and subsequent versions, click File > Options > Customize Ribbon, select the Developer check box, and click OK.

To add an ActiveX control, you’ll need the Developer tab on your Ribbon. The detail rows for the West region are hidden, but you can click the + outline symbols to display the detail rows. The user uses the spin button to increase a number in the cell. Toggle buttons indicate a state between an enabled or disabled state when the button is clicked. To display only the rows for a particular level, you can click the number for the level you want to see. In the following example, the row containing the grand total of all the rows is level 1, the rows containing totals for the South and West regions are level 2, and the detail rows for the regions are level 3. An outline lets you quickly display only the rows or columns that provide summaries or headings for sections of your worksheet, or display the areas of detail data adjacent to a summary row or column.ĭisplaying and hiding detail data An outline can have up to eight levels of detail, with each inner level providing details for the preceding outer level. When data is in list form, Microsoft Excel can create an outline to let you hide or show levels of detail with a single mouse click. I'm puzzled - why recreate Excel functionality using VBA - isn't it a waste of time and effort when it's already there for you?
