First post here, so apologies if its been discussed before.
When entering a forumula: Does anyone know a way you can highlight a cell in excel, and instruct the forumale input to have the dollor signs?
e.g. I am entering a formulae, I click on cell C10; and in the formula bar I want $C$10 to appear, to lock the cell position.
Cheers
Huzza
Bookmarks