$ in Formulas

Mike E Golding · May 3rd, 2002, 03:25 AM

I know that there is a quick key method to put the dollar sign into a formula (A1 becomes $A$1) but for the life of me I cannot remember it. Please knock me on the head. Thanks in anticipate. Mike

Mudface · May 3rd, 2002, 03:29 AM

Press F4.

Barrie Davidson · May 3rd, 2002, 06:55 AM

Also, you can press F4 more than once and cycle through absolute references. Example:

Press F4 once, $A$1
Press F4 twice, A$1
Press F4 three times, $A1
etc.

May 3rd, 2002, 06:55 AM	#3
Barrie Davidson MrExcel MVP Join Date: Feb 2002 Location: Winnipeg Posts: 2,330	Also, you can press F4 more than once and cycle through absolute references. Example: Press F4 once, $A$1 Press F4 twice, A$1 Press F4 three times, $A1 etc. __________________ Barrie Davidson "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 03:25 AM	#1
Mike E Golding Board Regular Join Date: Mar 2002 Location: Mike Golding Posts: 71	I know that there is a quick key method to put the dollar sign into a formula (A1 becomes $A$1) but for the life of me I cannot remember it. Please knock me on the head. Thanks in anticipate. Mike

May 3rd, 2002, 03:29 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Press F4.