Transcription of MODULE III: NAVIGATING AND FORMULAS
{{id}} {{{paragraph}}}
Example: biology
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.
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 the Name command, then Define… 2. Use the New, Edit, or Delete buttons in the Name Manager dialog box as necessary to edit or delete a range name.
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: