|
Excel: Work Smarter
In Excel, you can name a cell, or a range of cells.
Using names makes it easy to go to a particular place. It also
simplifies cell references when you create equations.
Try it: Name the
Range
Select cell
F1 through G5.
Go to the
Formula tab Select
Define Name.
Do you see a New Name screen?
The Name, Sales,
came from the label you typed in F1 at the start of this lesson. Refers
to: show the name of the spreadsheet, Bonus. The Range of data
can be found in Cell F1 through G5. Formula ->
Name |
|||
|
| |||
