Name a Cell

Jan 2, 2008
One of the important tools in the Excel is cell naming. By naming a cell, we can relate the cell name with any formulae we want to make. Furthermore, in creating macros or visual basic codes in Excel, cell naming is very helpful and important particularly in identifying the corresponding cell.

To name a cell, just go to the box 0n the top left side. Write the desired name and press enter.


For example, we want to calculate the return of share prices. With the conventional method, we use formulae =(B2/B3)-1. However, since B2 has been named as "today" and B3 as "lastyear", then the formulae becomes =(today/lastyear)-1.


This handy method is useful in a big spreadsheet when the formulae contains particular parameters that need to be referred frequently. It's also good for easily remembering and quickly referencing the formulae.

Labels:



Comments:

Post a Comment

<< Home

Dutch Indonesian English
    I receive donation for premium financial model and website developments. Please contact me for any inquiries.
this tool only works in IE
Calculate Your Power
Your Energy
Your Age Now y.o.
Your after-tax Annual Income
Monthly Expenses
Desired Real Return %
Desired Retirement Age y.o.
Transcendence Ratio %
Your Power
Annual Saving
Power in 5 yrs
Power in 10 yrs
Power @ Retirement
Estate Planning
Charity
>> read Transcendence Power