Microsoft Office Tutorials and References
In Depth Information
Floating option buttons
There are several types of “floating” option buttons that appear as you work in Excel.
These are provided to give you instant access to commands and actions that are
relevant to the current task. Many editing actions trigger the display of an option
button. For example, copying and pasting cells causes the Paste Options button to appear
adjacent to the last cell edited. If you click the button, a menu offers retroactive editing
Floating option buttons appear in many situations, so you will hear about them in
other places in this topic. For examples, see “Tracing errors” and “Pasting selectively
using Paste Special” in Chapter 8, and “Entering a series of dates” in Chapter 15.
You can have as many worksheets in a workbook as your computer’s memory will allow
(probably hundreds of worksheets, depending on how much data each contains);
consequently, you don’t need to try to it everything onto one worksheet. The following sections
present the features you can use to organize your worksheet world.
Inserting and deleting worksheets
To insert a new worksheet into an existing workbook, click the New Sheet button, which
you can see at the left of Figure 6-14. The new sheet tab appears to the right of the last
worksheet in the workbook. You can also quickly insert worksheets by right-clicking any
sheet tab to display the shortcut menu shown at the right in Figure 6-14. Clicking Insert on
this menu opens the Insert dialog box, which contains other items you can insert besides
blank worksheets, including templates and Excel 4 macro sheets.