IBM Docs wiki
Custom Search Scope...
Installing and deploying IBM Docs 1.0.4
1.0.4 Installing and Deploying
1.0.4 Using IBM Docs
Using IBM Docs 1.0.4 documentation
You are currently viewing machine translated content. IBM translation might be available. Click
IBM Translated Product Documentation
to see what is available.
Naming a range
September 24, 2013
Make formulas easier to write and understand by naming important cell ranges and using the names in place of range addresses in formulas.
In an open spreadsheet, drag to select the range you want to name.
Enter a range name.
You must start a range name with a letter, backslash (\), or underscore (_). Do not include any spaces in the name. Do not use the letters "r" or "c" by themselves as a name, as these letters are shortcut keys in
® Docs spreadsheets. Do not create names that look like cell addresses, such as Q2 or FY98. Names are not case-sensitive and can be up to 255 characters long.
If you did not yet specify the address the range refers to, take one of the following actions:
With the New Range window still open, drag in the sheet to select the range. The range address is displayed automatically in the
Manually enter the range address in the
Managing data ranges
Edit the article to add or modify attachments.
Compare selected versions
Summary of changes
This version (1)
Sep 24, 2013 9:03:41 AM
Copy and paste this wiki markup to link to this article from another article in this wiki.