automatically fill in formula

S

Stan

I thought that this was done automatically but ...
I have a sheet with a list of customers and how much they purchased.
The sheet is to be given to the accountant to be billed. The sheet has
about 8 columns some I fill in and others with formulas. The first
column is the date, after that I have 2 seperate columns that have the
formula for the year and month. 3 more columns of data that I fill in
and then formulas...
I thought that Excel recognized that as soon as there was data in
adjacent columns it would add the formulas automatically... For some
reason I need to copy and paste or drag the formulas down the column..
Is there somewhere to make this happen automatically? I am using Excel
2000 on a terminal server...
Thanks for any help.

Stan
 
D

Dave Peterson

Maybe...
Tools|Options|Edit tab|Check "Extend data range formats and formulas"????
 
S

Stan

Thanks Dave for your help.
I checked the tab and it was checked.. What I saw happen now when I put
a new date in it added the formulas for month and year... I added the
info in the following 3 columns, but it did not add the formulas for
the next adjacent column...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top