Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Digging Up the Facts
The second argument, whether it’s there or not, plays a key role in how the
CELL function works. When included, the second argument is either a cell
address, such as B12, or a range name, such as Sales. Of course, you could
have a range that is only one cell, but let’s not confuse the issue!
If you enter a nonexistent range name for the second argument, Excel returns
the #NAME? error. Excel can’t return information about something that
An interesting way to use CELL is to keep track of the last entry on a
worksheet. Say you’re updating a list of values. The phone rings, and you’re tied
up for a while on the call. When you get back to your list, you’ve forgotten
where you left off. Yikes! What a time to think “If only I had used the CELL
Figure 15-1 shows such a worksheet. Cell B18 displays the address of the last
cell that was changed.
Using CELL with the filename argument is great for displaying the workbook’s
path. This technique is common for printed worksheet reports. Being able to
find the workbook file that a report was printed from six months ago is a real
time-saver. Don’t you just love it when the boss gives you an hour to create
a report, doesn’t look at it for six months, and then wants to make a change?
Here’s how you enter the CELL function to return the filename: