The Dollar symbol is no longer just a currency indicator! It can also be used to save a significant amount of time when working with tables in Excel©. How? Read on for the step-by-step guide that will have you using the “$” symbol to improve spreadsheet e iciency in no time.
The Scenario
The example below sets the stage for a common situation when using Excel©. In this case, there is a need to automatically calculate a cumulative total for the remaining months (March through May). Basic spreadsheet users will simply use “SUM” and manually update the columns in each formula so that it calculates correctly.
An Easier Road
Rather than go the traditional route this is a case where the road less traveled makes a lot of sense. When using a Dollar sign in an Excel© formula the program assumes that the Column or Row number does not change, regardless of copying and pasting activities. So in our example, simply using “$B:$2” in the formula allows an easy copy and paste of cell C:3 across D:3 through F:3. Or, an even easier solution is to grab the bottom right corner of cell C:3 and pull it over to F:3.
And it’s as simple as that! If you have questions about this tip don’t hesitate to contact our team and we’ll walk you through it.
コメント