Donate SIGN UP
Home > Technology > Transposing a formula in excel

Transposing a formula in excel

Avatar Image
AllYourBase | 11:53 Sat 30th Sep 2006 | Technology
5 Answers
I have just got a new PC, with MS Excel on it. For some reason, if I put a formula on a cell, and use the little tag at the bottom right of the cell to copy the formula all the way down the column, all that is copied is the number that was in the original cell, not the formula. I suspect it's just a setting that needs changed, but have no idea which one. Can anyone give me a pointer? This does not happen in the Excel on my other computer.
prev HTML Video Codes
  
next Microsoft Word
Gravatar

Answers

1 to 5 of 5rss feed

Best Answer

No best answer has yet been selected by AllYourBase. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image treacle-tart
What is the formula ?

Bekki
13:49 Sat 30th Sep 2006
Avatar Image gen2
Yes, it sounds as if you are on 'Manual Calculation'

Go to Tools / Options / Calculation and change it to 'Automatic'
14:25 Sat 30th Sep 2006
Avatar Image gen2
Did that work AllYourBase ?

or do we have to think of another solution?
01:26 Mon 02nd Oct 2006
Avatar Image AllYourBase
Question Author
I checked the calculation option, and it was already on auto. However I have not had the opportnity to do another sheet just yet. Big brother will have to get back to you tomorrow!
22:54 Mon 02nd Oct 2006
Avatar Image treacle-tart
Do you have the string symbol ($) in the formula???

Bekki
02:18 Tue 03rd Oct 2006

1 to 5 of 5rss feed

Do you know the answer?

Transposing a formula in excel

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.