MODULE III: NAVIGATING AND FORMULAS

← Back to document page

MODULE III: NAVIGATING ANDFORMULASCopyright 2012, National Seminars Training2Navigating 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.

  Formula, Navigating, Navigating and formulas