Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lock or Unlock cell references in a formula for auto fill purposes
Are there any tricks (control or alt + something for example) to locking or
unlocking (probably not using the correct terms) of cell references in a formula in order to set it up for the autofill scenario I want to do? For example if I have the following formula: =a1+b1 How can I easily change it to =$a$1+$b$1 or =a$1+b$1 or =$a1+$b1 I may just be crazy, but if you have any quicker command button suggestions to change these scenarios easier than having to type them every time that would be great. Thank you. -- David P. |
#2
|
|||
|
|||
Select the relevant cell references in the formula bar and press
F4 to cycle through the various reference styles. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "David P." wrote in message ... Are there any tricks (control or alt + something for example) to locking or unlocking (probably not using the correct terms) of cell references in a formula in order to set it up for the autofill scenario I want to do? For example if I have the following formula: =a1+b1 How can I easily change it to =$a$1+$b$1 or =a$1+b$1 or =$a1+$b1 I may just be crazy, but if you have any quicker command button suggestions to change these scenarios easier than having to type them every time that would be great. Thank you. -- David P. |
#3
|
|||
|
|||
If you highlight A1 in the formulabar, you can toggle between the absolute
references and relative references by hitting the F4 key. If you highlight the whole formula, then all the ranges will cycle though the different reference styles. David P. wrote: Are there any tricks (control or alt + something for example) to locking or unlocking (probably not using the correct terms) of cell references in a formula in order to set it up for the autofill scenario I want to do? For example if I have the following formula: =a1+b1 How can I easily change it to =$a$1+$b$1 or =a$1+b$1 or =$a1+$b1 I may just be crazy, but if you have any quicker command button suggestions to change these scenarios easier than having to type them every time that would be great. Thank you. -- David P. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell references change when entering new data | New Users to Excel | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
How do you copy a cell formula down a column without displaying n. | Excel Worksheet Functions | |||
using content of a cell in a formula in another cell | Excel Worksheet Functions | |||
How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions |