Microsoft Excel 2013
Tip #2
Did you know that the dollar sign ($) can be used for more than just currency in Excel?
When you need to use the same formula repeatedly, the dollar sign can help make your life easier.
As part of a formula, the dollar sign will tell excel not to shift when the formula is copied into an entirely new cell.
Here’s how it works: putting the dollar sign in front of the column marker (A,B,C,D,E,…) tells Excel not to advance along columns; putting the dollar sign in front of the row marker (1,2,3,4,5,…) tells Excel not to advance down rows. In other words, depending on where you put the dollar sign, Excel will lock in the row or column when you copy the formula.
For example:
When the formula =$A1 is used and copied, Excel will advance down rows, but not along columns
When the formula =A$1 is used and copied, Excel will advance along columns, but not down rows
And finally, when the formula =$A$1 is used and copied, neither the rows or columns will advance
If you would like to learn more about this or any Microsoft Dynamics products, please contact Complete Software by calling 410-740-1090 or by emailing support@completesoftware.net!
Based out of Columbia, Maryland, Complete Software Solutions (CSS) is proud to be a Microsoft Partner and Value Added Reseller (VAR) for Microsoft Dynamics GP 2010 and Microsoft Dynamics SL as well as a unique software developer providing solutions for businesses and non-profit organizations throughout the country. We offer a variety of services including Microsoft Dynamics consulting, system evaluation, business process analysis, system design, customizations, Enterprise Resource Planning (ERP) implementations and system upgrades.