Lock A Value On Excel How To Assign F4

Normally, if you drag them, all cells will change accordingly.

In order to do it, you have to use something called absolute cell references.

The dollar sign before the column and row number mean that the reference should be constant both in columns and in rows.

You can also click inside the formula bar, inside D2 and press the F4 button on Windows or Command T on Mac.

In Excel for Mac the F4 key is assigned to the Paste command, which is driving me crazy so I decided to do something about it.

For instance the above procedure was done in Excel 2011, but my Excel 2008 version of Excel for Mac wasnt affected and has to be done separately.

Lock A Value On Excel How To Assign F4

The Command Y function is not quite the same as redo (which the above process outlines how to assign F4 to Redo).

I often use the F4 key (Repeat Command) in the Windows version to quickly delete rows and columns.

The Command Y function (I believe Repeat Command) is not customizable cannot be assigned using the Tools Customize Keyboard.

I wrote a new post showing how to put the the Repeat command icon on the toolbar, which works even better.

YOU HAVE SAVED MY LIFE I am in the process of setting up some excel sheets for a client of mine that includes hundreds and hundreds of rows of information and changing this has saved me loads of time adding in hundreds of new information Thank you again so much.

Or use the Switch Reference on the Formulas tab of the Ribbon.