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
  • 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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

621 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