A range name can include up to 255 characters,
uppercase or lowercase letters (not case sensitive), numbers,
and punctuation, but no spaces or cell references. |
Select the cell or a range, or nonadjacent selections.
|
|
![Select the cell or a range, or nonadjacent selections.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vQ9ETLxRkZaf-6P3vH3B912xmohEQg5ZHdVlMyv-sj3kbHC5LzXawLVTBODwHAQd5-oy4RIsYcwlU5s3c6LKemnSN0E6SEpA9531rf7iKwzNxuwK9wtApGuiUF5s-6CXed6db3urJO5Ez12wgNr8auloWjcbfuYbZFgvo7zePjh6Br8yH_D-z66u4azEHEm6oO5Wsq4gKcyNqHNqAJ09pFbcgNE45Jxo25rYQcs9eVgw=s0-d) |
Click the Name box on the formula bar. Type a name for the range. Press Enter
|
|
![Click the Name box on the formula bar. Type a name for the range. Press Enter](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_sTmlVoykr4sxH0f1ZMJpwMq8YzdFTH6hQxWibJSCY23BgVd19IVov0EdGGQBhNs4gq4XpJRmZRzmr_HJ0RvkQDbc34njd_MparBHgjiYMhmfoDuVnl599YRJbQvLJMve2jG1gN9qplLYbdU5WydbwPNSkUEJ-Lt17NBI70bXwkx4NmRNnXfwqmPKNmeZlnYzoQIvM27bbLYe-_V--nTw4NMIbulQQm_easGrHxcRPToA=s0-d) |
The range name will appear in the Name box whenever
you select the range in the workbook.
|
|
![The range name will appear in the Name box whenever you select the range in the workbook.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_v4tjJJ6965inVPYiIbTiVVmq12svMmehGl76Af2h6DGju8fG9fopHk0lv3nfbSZFh4zPavXFFibRIRdKVhcMeAgblzuU89qJDH7DFfuDOLns6wVxwOCmKLtyqtc7FTMcyXKBGT9uulwhzIiO-7FyWybI8vXIs8FKxeuFY4lUuvHPt1KBhIKxj0xhxjV3vWagvZoADcgg5AvPZ7yWgxv4-b15OlWmZyI2bU8_anOh-W=s0-d) |
No comments:
Post a Comment