6/25/2023 0 Comments Shift f4 in excel![]() ![]() There are other times when you need only part of the reference to be locked. Pressing F4 while the insertion point is touching the F1 reference is a fast way to add both dollar signs. The $F$1 says that no matter where you copy this formula, that part of the formula always needs to point to F1. Two dollar signs are added to the final element of the formula. The solution? Edit the original formula and press F4. But unfortunately, the reference to the sales tax in F1 is changing as well. As you copy the formula down the column, the B2 reference automatically changes to B3, B4, and so on. ![]() In the following figure, the tax in C2 is B2 times F1.īut when you copy this formula down, none of the sales tax calculations are working. Illustration: Cartoon Bob D‘Amico Make a Reference Absolute
0 Comments
Leave a Reply. |