Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Click in Your References

Friday, December 21st, 2007 by | Filed Under: MS Excel, MS Office Help

Click in Your References

Did you know you don’t have to type cell locations into formulas in MS Excel?

I don’t know about you, but I think it’s a pain to have to verify all my cell locations just so I can type them into a formula somewhere else in the worksheet!

Wouldn’t it be much easier to simply click on cell B26, for example, instead of looking for the cell location and then typing B26 into the formula?

Yeah, I thought so too and luckily, Excel lets you do just that!

No longer do you have to scroll through your worksheet, looking for the cell you need, just to scroll back to your formula to add that address and then start all over again with the next one.

Excel allows you to start your formula (with the equal sign and any other beginning information) and when you get to a cell (or range of cells) that must be inserted, just simply scroll and click (or highlight for multiple cells). Excel will automatically insert the cell location for you.

Next, enter whatever is left of the formula by clicking at any other juncture where a cell reference is needed. Then just hit the Enter key when you’re done.

For example, to add cells A1 and B1, you could type =, click on cell A1, type the +, click on cell B1 and finally, hit the Enter key.

The formula =A1 + B1 will be your end result. (Obviously, that one is too simple to bother with the clicking, but whenever you’re not sure of the exact cell location of the data, the click method is just the thing you need).

I’m sure if you have complicated or large worksheets, it can be a real timesaver when you don’t have to resort to scrolling all the time. Give it a try!

~ April

Leave a Reply

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.

Enter Email Address:


Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup

Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive