Excel 2010 - External Data Properties

G

geekette

Board Regular
Joined
Sep 12, 2006
Messages
120
Does anyone know where the "Fill down formulas in columns adjacent to data" option has moved to in Excel 2010?

I have a sheet with data linked to an Access database. In older versions I was able to go to the data properties and select this option so formulas in adjacent columns would expand to the same number of rows.

I have a number of spreadsheets that are dependent on this working but cannot find it in Excel 2010...

Any pointers greatly received as have googled and researched but cannot find an answer to this question????

Thanks in advance!
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
You must log in or register to reply here.

Similar threads

A
  • Solved
Alternative to FILTER function in Excel 2010?
Replies
3
Views
580
Fluff
Fluff
R
  • Question Question
Data Model Error - Effecting all versions of the same workbook
Replies
0
Views
389
Rollnation3
R
B
  • Question Question
Auto Fill values in cells with items in Data Validation or a List/range
Replies
2
Views
312
Skyybot
Skyybot
C
  • Question Question
Dependent Drop Down Help, Excel 2010
Replies
5
Views
693
Akuini
Akuini
A
  • Question Question
Take screenshots & simultaneously capture the link, place it into an Excel file which is linked to a FileMaker/Claris db.
Replies
3
Views
413
Dan_W
D

Forum statistics

Threads
1,224,550
Messages
6,179,463
Members
452,915
Latest member
hannnahheileen

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top