Transcription of MODULE III: NAVIGATING AND FORMULAS
{{id}} {{{paragraph}}}
Example: marketing
MODULE III: NAVIGATING AND FORMULAS
MODULE III: NAVIGATING ANDFORMULASC opyright 2012, National Seminars Training2 NAVIGATING and FormulasEXCELiiiUsing Grouped WorksheetsWhen multiple worksheets are selected, the worksheets are grouped. If you type, edit, createformulas, or format entries in one of the grouped worksheets, entries in the same cell in all thegrouped worksheets change at the same time :1. Select the first worksheet you want to Hold down the [Ctrl]key if the other worksheets you want in the group are not adjacent,or the [Shift]key if they are, and select any additional worksheets you want to add to the Select the cells or range you want to enter information into, type the desired entry, andpress the [Enter] Select the cell or range to which you want to apply formatting and apply the desired : Be sure to ungroup the sheets before proceeding. You can do this by clicking one of theungrouped sheet tabs or right-clicking one of the grouped sheet tabs and select theUngroup caution: Do not save the file while grouped unless you reallyintend and FORMULAS , continuedMoving and Copying Data Between WorksheetsInstead of cutting and pasting, you can move data between worksheets using drag-and-dropediting by holding down the [Alt]key as you :1.
7 EXCELiii Navigating and Formulas, continued Editing and Deleting Range Names Steps: 1. On the Formula tab in the Defined Names group, click the Name Manager button as shown in Fig. 4-4 (or select the Insert menu, then …
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: