Fill down formula not cell content

G

Guest

This is really frustrating! When I use ctrl D to fill a formula down several
rows, the formula does NOT repeat - only the value of the originial cell is
filling down. It ahs always worked correctly in the past. I'm sure this is
a simple setting, but I have tried looking for it for about an hour on the
web and elsewhere. Please help! I am using Excel 2003.

Thanks,

Kevin
 
G

Guest

Byron:

Thanks for the suggestion, but I don't have use of the Paste Special for
some reason. Anyone other ideas? Typing these 300 rows would take
forever..... I did discover I had a macro within another unopened workbook.
I deleted the workbook and still have the same problem. Do macros even work
globally?

Thanks,

Kevin
 
R

Roger Govier

Hi Kevin

Perhaps your calculation setting has altered.
Tools>Options>Calculation>Automatic
 

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

Similar Threads

Excel 2003 - fill down error 1
Fill formula down for cells 74 rows apart 3
filling down a formula using =TEXT() 4
"Fill" Conditional Formatting? 5
Formula fill across workbooks 3
Fill formula down using macro 2
Fill down visible cells only 4
Fill handle fill down alternative methods question 2

Top