When you enter a formula into a cell, you have the option to copy that formula down your entire column. This is really nice when you want Excel to change the cell letter and number each time. For example, Excel knows to change “A1 + B1” to “A2 + B2” in each adjacent row.
But what if you don’t want Excel to automatically change the formula information? What if the data in cell A1 is the same for each row? You would simply add a $ before each character: “$A$1 + B1”.
For example, let’s say you have a field in Excel that contains the price of an item, $100. You want to multiply this price by a column of different numbers that represent quantity. You would use the $ symbol in front of both the letter and the number in the field that the price resides in and then multiply it by each field that contains quantity. This formula may take some practice, but it can be very helpful once you get it down!
Note: You can also create a static column or row by putting the $ symbol in front of only the letter or the number.
We love feedback from our customers and implement suggestions often. What shortcut do you use the most? If you have a question or idea for a Microsoft Windows or Excel tip that you would like to see, let me know and I might write about it!
Training Specialist