Iam just starting to learn about MS XL and the way it does things. I would like to place a column of numbers based on a single number in a single cell. I.e. if cell b2 has a value of 2, then cells d4 to d12 should also equal 2. If I change the value in b2 to 3, the d column should change to all 3s. I cannot fathom how to stop the column equaling b2,b3,b4, etc. In other words, the number reference should not change! How do I formulate this column?
Just to expand on what VoG™ has said, and he is the undisputed master of Excel, the $ sign makes the cell address "absolute" rather than "relative". An absolute cell address will always refer to the same cell rather than 'incrementing' when dragging as you have found. Hope that goes a little way into helping you understand Excel which is an incedible application.