Fixing a cell in Excel – Absolute Cell Reference

Sometimes we want to use the same cell over and over in Excel. The way we do that is by creating an absolute cell reference. You may have come across it already when you have seen dollar signs ($) in formulas. In the video below I show you how to fix a cell. If you need to fix a row, you can read about it in this post and if you need to fix a column you can read about it in this post. As always there is a link to a file you can practise on below. Comments/suggestions always most welcome…

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/11-fixing_a_cell.m4v’]

 

You can click on this link to download an Excel file to practise on – fixed_cell_only_exercise