"Fill Down Formulas in Columns Adjacent to Data" option in Excel 2010?

Kendario

New Member
Joined
Apr 5, 2011
Messages
1
I have a table in Excel from an MS Query and I have formulas in adjacent columns referencing the table data. I want those formulas to fill down when the table is refreshed. This option was available in previous versions of Excel but I can't find it in 2010. Was this removed? Is there a way I can get this to work in Excel 2010?
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
I'm sure that there are some 2010 users on here that can help out ... unfortunately I only have 2007.
 

johnnyjoe1076

Board Regular
Joined
Jan 18, 2012
Messages
77
Kendario,

Did you find a resolution or answer to this question? I also am trying to figure this out. Thanks!

John
 

Watch MrExcel Video

Forum statistics

Threads
1,108,789
Messages
5,524,885
Members
409,609
Latest member
Channingz

This Week's Hot Topics

Top