When I use a formula and select a cell or a couple of them, I see that there are dollar signs put before and inside the cell index. What is it done for and can formulas be used without them?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Why are dollar signs put between and before the cell number?
0
Answers
0
Selected Answer
Jayden
The purpose of the $ sign is to "fix" or "anchor" what follows it in a formula (column or row). For example $F4 would fix only the column (F), whereas F$4 would fix only the row (4). $F$4 would fix both row and column. F4 would have neither row nor clumn fisxed (for the purposes of copying).
This is very helpful when you copy cells containing a formula to other cells (or use Fill) since you can keep the appropriate bits fixed. E.g if cell J4 is:
=$F4=F4This old Microsoft blog may help: Making sense of dollar signs in Excel.
Hope this is what you mean / makes sense.
Discussion
Thank you very much, this was exactly what I've wanted to hear
Jayden Smith (rep: 10) Oct 1, '21 at 3:20 pm
Thanks for selecting my answer, Jayden. Incidentally if you select a cell reference in a formula and press the F4 function key, C3 becomes $C$3 (and F4 again restores it) . Have a play with the cursor in different parts of the cell ref.
John_Ru (rep: 6142) Oct 1, '21 at 5:09 pm