tag:blogger.com,1999:blog-6638043.post376712012087739904..comments2023-05-12T01:11:23.747+10:00Comments on Mokalus of Blog: Excel extremely auto-fillJohnhttp://www.blogger.com/profile/03388453194546051041noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-6638043.post-73648768098533933492012-05-18T14:36:36.852+10:002012-05-18T14:36:36.852+10:00Two years after noticing this problem, I finally h...Two years after noticing this problem, I finally have an answer! In Excel 2010, highlight a cell in the data import, go to the Data tab, click the Properties button and at the bottom of the dialogue box there is a checkbox labelled "Fill down formulas in columns adjacent to data". Tick it. Formulas should now copy down automatically when imported data grows.Johnhttps://www.blogger.com/profile/03388453194546051041noreply@blogger.com