excel dragging formulae

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Train Strikes - 7th, 12th Nov 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Dragging Formulae

Excel Dragging Formulae

resolvedResolved · High Priority · Version 2003

Victoria has attended:
Excel Advanced course

Excel Dragging Formulae

When i drag a formula down a column - it is not continuously calculating the values instead it is just dragging the value of the first cell i pick. I can only get the answer to each fomula if i go into each cell and double click into it then press enter.

I'm guessing this has something to do with my settings in excel but can't work out why this has only just started to happen. never had a problem before

Some one help Please!

RE: Excel Dragging Formulae

Hello Victoria

Thank you for your question.

Perhaps Excel is set to calculate manually rather than automatically?

If you go to Tools - Options, then onto the Calculation tab, check Calculation is set to Automatic. If not, change to Automatic and click OK.

I hope this helps.
Amanda

RE: Excel Dragging Formulae

Thanks but i have just checked and this was already on Automatic. I don't know what else to do.

Vic

RE: Excel Dragging Formulae

Hi Vic

If you like (and if it's possible), you can email me a copy of the spreadsheet if you like and I'll have a look into this for you.

If you do send the spreadsheet, also let me know which column the formula is in that you are having trouble with.

You can email the file to amanda@stl-training.co.uk
I won't have an opportunity to look at this until later today or tomorrow, but if you send it through in the meantime I can look at it as soon as I'm able to.

Kind regards
Amanda

RE: Excel Dragging Formulae

thank you amanda - i have realised that your first suggestion has worked - i needed to highlight the sheet in question before going to tools. which i have now done so thank you for resolving this so quickly.

Vic

 

Training courses

 

Recommend training98.7 %
recommend us
More live stats...

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel articles

Please browse our web site to find out more about
best training excel intermediate and other training courses.

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.08 secs.