HAN.xlsx [Read-Only] - Excel at Microsoft Excel!
Home
Introduction
Excel
101
So, you're new to spreadsheet huh.. Check this out!
Excel
Formula
How to write an excel formula!
New Posts
Love
Meter
Who is Your Crush's Big Time Crush?
Unprotect
Sheet
Remove password from protected worksheets and workbooks!
Dictionary
Attack
Open password-protected excel file using a dictionary attack!
Projects
Gag
Love
Meter
Who is Your Crush's Big Time Crush?
Other
Gag
Coming soon!
Social Network
Excel
Facebook
Coming soon!
Excel
Twitter
Coming soon!
Games
Formulas
Financial Modeling
Developer
Passwords
Password Recovery
Unprotect
Sheet
Remove password from protected worksheets and workbooks!
Dictionary
Attack
Open password-protected excel file using a dictionary attack!
Brute-force
Attack
Learn how to open password protected Excel File! Coming soon!
About
HANxlsx
About
Me
A little intro..
Privacy
Policy
Privacy Policy!
Disclaimer
Disclaimer!

[back to top!]

Coming up next!

Chatting and updating status using excel spreadsheet like a boss!

Our next excel project is to create a facebook-like excel spreadsheet that works like facebook. You don't say.. :D

Stay tuned, people! More cool stuff is coming!

Friday, November 9, 2012

Naming Cells

Another way to make an absolute reference to the cells is to put a name on them. By naming the specific cells, you can easily use those names in your formula. For example, instead of typing =$A$1*B1, you can name cell A1 to any name that you want (let's say we name it "pung") and change the formula to =pung*B1. See the following embedded excel file:



In the Name box, (the box immediately above the row headings), type in "pung" and then press enter. The cell reference will change to "pung" accordingly. Please note that you can always continue to use A1 as a reference to that cell.



If you go to another cell, but then you want to go to the name box, drop down and click on pung, the
selected cell will switch back to cell A1. This will definitely help you find a cell quickly.

Similarly, if you click on a random cell, and type in =10*pung , Excel will calculate the cell value as 10 times whatever number you put in A1.