5 Click OK The selected worksheets are printed 6. Ungroup the worksheets Referencing Cells with Names A range of cells can be referred to by a name that you assign. Names and Names for Frequencies Names and Names for Names and Numbers for Names and Definitions Range Names for Range Names and Names Tips for Assigning Names The name should be descriptive (grades is more descriptive than range1) Other characters can be letters, numbers, or periods. The name can not look like a reference (e.g., "A1", "R1C1"). To separate words, the underscore character or a period must be used instead of a space. The name.can be up to 255 characters long. The names are not case sensitive; they can contain upper and lowerercase letters. If you name one range BUDGET and a second range Budget, Excel will create the first one with the second one Creating Range Names Creating Range Names: Dialog Box Option 1. Select the range of cells. 2. On the Ribbon , select the Formula tab....ORIGINALLY WRITTEN BY FREEVIBES.COM.NG
Post a Comment