How do I use pop-up panels?

Pop-up panels appear when you click certain commands in the action bar. These panels let you enter additional information to complete a command or to set properties for a range or worksheet. For example, you use a pop-up panel to set the font for data in a selected range.

A pop-up panel in spreadsheet

Pop-up panels provide a variety of methods for entering and choosing your options:

Item To select an option...
Option buttons Click one option, which overrides any previous setting.
Palette Click one option, which overrides any previous setting.
Checkbox Click one or more options.
Click an option, then optionally press SHIFT while clicking each additional option. If a scroll bar appears next to the list (as shown), click the down arrow to display each additional option.
Drop-down list box Click the box and enter information, orclick the arrow and then click one option in the list; the new option overrides any previous setting.
Edit box Click the box and enter information. Replace an existing entry by double-clicking it and then typing new information.


To make choices in pop-up panels

  1. Use the mouse or the arrow keys to move to the option you're interested in.

    Note Pressing TAB does not move the mouse pointer.

  2. Make your choices as described in the table above.

  3. Do one of the following:

Note Pressing ENTER does not close the pop-up panel.



See also
What's on my screen?