Excel Tutorial For Beginners The Dollar Sign $ in Microsoft Excel 2021

Avoid having to enter formulas into each cell of a document and use the $ Dollar Sign. Simply stated the dollar sign in an Excel cell reference serves just one purpose it tells Excel whether to change or not to change the reference when the formula is copied to other cells. Some examples of what you may have seen used in an excel spreadsheet include the following A1, $A$1, $A1, and A$1. Watch my Video tutorials on #youtube to learn more!

Leave a comment