how do I drag formulas from one column to the next

  • Thread starter Thread starter Miles
  • Start date Start date
M

Miles

I have 20 columns or more of data that I want to perform the same
calculations on but when I drag the first box sometimes I can get it to drag
the formula but more times than not it just drags the result of the first
column to all subsequent comumns. I don't understand Excell much but I'm
curions as to why this works sometimes and not others?
 
Hi Miles

It maybe that you Tools>Options>Calculation set to Manual instead of
Automatic
 
You must log in or register to reply here.

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

Drag formulas, not formating 2
Dragging/Copying Formulas in Excel 2007 3
Problem dragging formulas 1
Excel Drag autofill only part of formula 3
Fill-in formula which calculates automatically 3
Excel not recognizing formula 1
Dragging formula 8
Dragging/copying formulas 4

Back
Top