MS Excel - What is the Keyboard short cut for $F$3

Posted on 2005-03-06
Medium Priority
Last Modified: 2012-05-05
When creating a formula and wanting to make a cell static you can enter a $ before the row and/or column.  Today I do this by manualy editing the formula in the edit box.  I know their must be some key combination that I can hold down while selecting/clicking on a cell that will automatically assign the $ in the forumla.  
Question by:AxeTracks
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 22

Accepted Solution

ture earned 2000 total points
ID: 13472308
Press F4 while the curosr is in or near the cell reference in the formula.
F4 toggles between four different kinds of absolute/relative references.

Best regards,
Ture Magnusson
Karlstad, Sweden

Author Comment

ID: 13472348
Sweeet... I knew it was there!
LVL 22

Expert Comment

ID: 13472385
:o)   Glad that I could be of assistance! /Ture

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
New style of hardware planning for Microsoft Exchange server.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question