Transcription of MODULE III: NAVIGATING AND FORMULAS
{{id}} {{{paragraph}}}
Example: bankruptcy
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.
8 Navigating and Formulas, continued EXCELiii Jumping to a Named Range You can use the Name Box (next to the formula bar) to jump to a named range. If the formula bar is not displayed, on the View tab in the Show/Hide group, you can select the Formula Bar check box (or use the View menu to check the Formula Bar check box to display it). Steps: 1. Click the arrow for the Name …
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: