Google Answers Logo
View Question
Q: Microsoft Excel shortcut ( Answered 5 out of 5 stars,   0 Comments )
Subject: Microsoft Excel shortcut
Category: Computers > Software
Asked by: jaceventura-ga
List Price: $2.00
Posted: 24 Nov 2004 17:41 PST
Expires: 24 Dec 2004 17:41 PST
Question ID: 433713
When using Microsoft Excel I regularly choose to use the same sell
three or four times in different formulas.  So, I enter the cell
reference with a dollar symbol (e.g. $E$21) so that when I copy the
formula to another cell, the reference to the cell I want constant is

I'm almost certain there is a keyboard shortcut so that when I'm
writing a formula (e.g. =B20+E21) and I select the E21 cell with my
mouse, as opposed to typing the cell reference into the formula, the
reference will automatically add the dollar symbols (e.g. =B20+$E$21).
 I've tried Control and Alt, but they don't seem to do the trick.
Subject: Re: Microsoft Excel shortcut
Answered By: answerguru-ga on 24 Nov 2004 17:53 PST
Rated:5 out of 5 stars
Hi jaceventura-ga,

This is a simple yet very useful trick for the purpose you've
described in your question. Here are the simple steps:

1. Go to the cell you want to enter the formula into
2. Enter the plain cell reference (either by typing the reference or
clicking a cell)
3. Hit the function 4 key (F4)

This will turn the adjacent cell reference from something like A1 -->
$A$1. You can also get to different types of references by hitting F4
multiple times. Examples of this would be $A1 and A$1.

Hope that helps!

jaceventura-ga rated this answer:5 out of 5 stars
That is exactly what I needed.  Thank you.

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy