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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

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 ...
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...
Find Blank Cells In Excel With A Color In Excel you can have a data set that comes from an external source which isn't always formatted to your liking.One of the most common things you may encounter are blank cells in your Excel data which can hinder your analysis, especially if you are using a Pivot Table to anal...
Drop Down List with Data Validation One of the coolest features of Excel is to create a drop down list with your data.  It is one of the first things that I learned and use on a daily basis.You can create a drop down list to eliminate manual entry and re-entry of data, as well as reduce data entry mistakes if y...