One of the advantages of using an Excel Table is the ability to autofill a formula all the way down your data without having to copy and paste.

When you write a formula anywhere in your Excel Table, it will automatically fill down and up within that column.

As you add extra rows to your Excel Table, the formula fills in to the extra rows added, so you do not need to copy and paste.

How efficient is that!

DOWNLOAD WORKBOOK

Formulas Fill Down

HELPFUL RESOURCE:

Excel Tables

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Excel’s Fill Handle Tips This post was inspired by Mr.Excel's new book MrExcel XL: 40 Greatest Excel Tips of All Time and in particular the 3rd tip that I read called The Fill Handle Does Know 1,2,3... Excel knows to fill down/right when you are working with dates, days, months, years and even quarter...
Excel Table: Row Calculations One of the most powerful feature of an Excel Table is the use of formulas to calculate its Column contents.  To activate this you need to click in your Table and go to the Table Tools tab in the Ribbon.  From there you simply need to activate the Total Rows check box. This wil...
Show Pivot Table Values As a Running Total In If you want to track your sales on a monthly basis and see their Year to Date totals, then you can easily do this with the Running Totals In calculation. You can activate this by Right Clicking on your Pivot Table values and choosing Show Values As and Running Total In.  You c...
How to Calculate Percentage in Excel In calculating percentages in Excel, there are a lot of ways that you could do this: What is the percentage of a number? What is the percentage change of value i.e. The percentage increase or decrease What is the proportion against a total value? Let us go over ...