Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |