Shortcut keystroke for locked cell in a formula?

[Guest]

Do you guys know if there's a keystroke I can use when I want to lock onto a single cell in a formula, instead of having to type those dollar signs every time?

i.e. If I want the cells to be divided by the total in L32, could I push something and then click on L32 directly instead of having to type in $L$32 instead?

Thanks!
Ro

 

[IML]

On 2002-02-26 14:39, Anonymous wrote:
Do you guys know if there's a keystroke I can use when I want to lock onto a single cell in a formula, instead of having to type those dollar signs every time?

i.e. If I want the cells to be divided by the total in L32, could I push something and then click on L32 directly instead of having to type in $L$32 instead?

Thanks!
Ro

Try typing in
=2+l32 and then hit f4 before enter.

This acts a little finicky sometimes. If you highlight your whole formula in the formula bar and cycle through f4 you will run through the various absoluting options.

good luck

 

[Guest]

Perfect, thanks!!!!

Couple related questions:

1) If I'm editing a formula that's already on a worksheet, and it refers to four different cells, and I want to go in and change a reference to a single cell to get that locked, is there a way to do so without going in and retyping it with dollar signs?

2) Is there a way to reference a cell and instead of locking on the individual cell, lock on only the column or only the row?

Thanks again,
Rohan

 

[IML]

On 2002-02-26 15:08, Anonymous wrote:
Perfect, thanks!!!!

Couple related questions:

1) If I'm editing a formula that's already on a worksheet, and it refers to four different cells, and I want to go in and change a reference to a single cell to get that locked, is there a way to do so without going in and retyping it with dollar signs?

Hit F2 to edit the formula. Highlight the cell of interest and hit f4.

2) Is there a way to reference a cell and instead of locking on the individual cell, lock on only the column or only the row?
A1 is relative
$a$1 is absolute
a$1 is relative column/absolute row
$a1 is abosolute column/relative row.

Hitting f4 several time will run through these options.

The help file is a great resource for this. See About cell and range references, and click on the note about relative and absolute references.

Thanks again,
Rohan

 

[Mark W.]

On 2002-02-26 15:08, Anonymous wrote:
Perfect, thanks!!!!

Couple related questions:

1) If I'm editing a formula that's already on a worksheet, and it refers to four different cells, and I want to go in and change a reference to a single cell to get that locked, is there a way to do so without going in and retyping it with dollar signs?

2) Is there a way to reference a cell and instead of locking on the individual cell, lock on only the column or only the row?

Thanks again,
Rohan

F4 toggles thru all of the combinations of absolute, mixed and relative references. While editing a formula before pressing F4 highlight the references that you want to change.

Sorry , IML didn't see your response.
This message was edited by Mark W. on 2002-02-26 15:42