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

Dynamic Data Validation List What´s a dynamic data validation drop down list in Excel, you say? Well, as you add new data into your Excel Table, your drop down list automatically gets updated. That is a cool feature and it means that you do not need to update your data validation source reference each ...
Show The Percent of Parent Total With Excel Pivot ...   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF PARENT TOTAL calculation. In the example below I show you how to get the Percent of a Product Total i.e The % Sales of each Product ...
Excel Table Headers Show in Columns Before Excel Tables were introduced in Excel 2007, there were Excel Lists which had limited functionality. For example, when you had a list of data with hundreds of rows and you had to scroll all the way down to the bottom of your list, the Headers row was not visible and you ...
Find & Replace The Find & Replace feature or CTRL+H shortcut allows you to amend your data in seconds.  Imagine you had thousands of rows of data that was downloaded from an external system with the wrong date.  A simple CTRL+H will save you heaps of time!  See how below. DOWNLOAD WORKBO...