![]() ![]() Each time you hit F4, Excel cycles to another option. Here’s an easy way to set the $ sign combination you want: Type a reference like =B3 in your formula bar and then tap the F4 key. That is, the $ sign “anchors” a row number or column letter when you copy it. To illustrate, suppose the following formulas are in cell D3 and you copy them to cell E4. If a dollar sign precedes a row number or column letter, the row or column doesn’t change when you copy it. I’d like more details of usages, examples, as this is a great feature that I cannot find information on.Īs I told my reader, the $ sign in a cell reference affects only one thing: It tells Excel how to treat your references when you copy the cell. Could you send me more details about using $’s like the following: =AVERAGE($6:$6) averages all data in ROW 6.
0 Comments
Leave a Reply. |