Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

It is possible in Excel to create a cell reference using $ to prevent Excel from incrementing the row/column designator when the formula is copied. IE, if you fill a formula containing the reference $A$1 across a row, every pasted formula will remain referencing $A$1. However, if you do not manually add the $ prefix, the row/column designator will increment automatically.

When you enter formula entry mode and then click on another cell, that cell's reference will be insert at the cursor's position inside the formula.

Is there a modifier combo I can hold such that clicking on cell A1 will result in `$A$1' being entered into the formula, so I don't have to key in the $ after clicking?

Apologies for the circumlocution, I don't know the proper terms for these Excel features.

share|improve this question

1 Answer 1

up vote 6 down vote accepted

On Windows, you can press F4 after entering the cell coordinates to automatically toggle between relative and absolute: A1 → $A$1 → A$1 → $A1.

On OS X, the shortcut is Cmd-T.

share|improve this answer
    
I should've mentioned I'm on Excel for Mac. Your answer gave me enough info to find the equivalent Mac shortcut (cmd+T) though. Thank you! –  Alterscape Jan 8 '12 at 20:50
    
+1 I can't believe this is the first I've heard of this feature. I feel like I've been living in a cave. –  Excellll Jan 9 '12 at 18:28

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.