Microsoft Office Tutorials and References
In Depth Information
Assigning names to groups of cells
2
Delete a named range
1 Click the Formulas tab.
2 Click Name Manager.
3 Click the named range that you want to delete.
4 Click Delete.
5 Click OK to clear the confirmation dialog box that appears.
6 Click Close.
1
4
3
5
Rename a named range
1 Click the Formulas tab.
2 Click Name Manager.
3 Click the named range that you want to rename.
4 Click Edit.
5 Type a new name for the range.
6 Click OK.
7 Close the Name Manager dialog box.
6
2
7
1
CAUTIoN The name that you give your named range
shouldn’t duplicate a potential cell address. For example, typing
DAY1 in a formula would reference cell DAY1. To avoid this problem,
either ensure that your ranges have names that begin with at least four
letters (the last column is XFD) or use an underscore to separate the
letters from the rest of the name. The name DAY1 isn’t valid, but the
name DAY_1 is.
5
3
4
6
Search JabSto ::




Custom Search