Apple M9057 User Manual - Page 159
Assigning names to cells, Editing and deleting names, Edit Names
UPC - 718908500040
View all Apple M9057 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 159 highlights
Spreadsheet 7-13 Assigning names to cells To name cells, choose commands from the . menu in the entry bar To Do this Example Name a cell or cell range Select the cells to name and choose Define Name from the menu. Type a name in the dialog box, and then click Define. Name cells or ranges using row and column titles you've already typed Select all of the cells to name (include both row and column headings in the selection) and choose Auto Name from the menu in the entry bar. Select a name, then click Define. You can assign more than one name to a cell or range. Cell A1 is unnamed Cell A1 is named Revenue Cells B3 and C3 are named Shares Cells B4 and C4 are named Price Cells B3 and B4 are named January Cells C3 and C4 are named February In the Help index,* see: E named cells and ranges Note Some characters, such as operators (like + or ÷ ) and punctuation marks cannot be included in a cell name. For complete information about naming a cell, see onscreen Help. Editing and deleting names If you change your mind about the name or location of a named cell or range, or if you want to delete a name, choose Edit Names from the menu in the entry bar. Then, make changes in the Edit Names dialog box. To Select a name from the scrolling list, and then Rename a cell or range Type a new name, and then click Modify Change the cell address referenced by a name Type a new address for the cell or range, and then click Modify Delete the name of a cell or range Click Remove. If the name you want to delete is used in a formula, you must first replace the names in the formula with cell references. (See "Replacing cell references with named cells" on page 7-14.) * Choose Index from the or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.