Tag Info

Hot answers tagged


When you want to create a formula that can be copied to other locations and retain the reference to the row or column, you use the $ to anchor it. In your example, you want to copy down the column and keep pointing to row 21, so you would use: =A1/A$21 If your data was horizontal and you wanted to copy across columns, you would put the $ in front of ...

Only top voted, non community-wiki answers of a minimum length are eligible