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

excel intermediate

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel intermediate

Excel intermediate

ResolvedVersion 2003

Corinne has attended:
Excel Introduction course
Excel Intermediate course

Excel intermediate

If I start doing a formula in a cell but then change my mind and click out of it in a bit of a panic rather than going to X I seem to get myself in all sorts of problems and can't seen to undo so that it returns to normal. What can I do in this situation to stop this and get back to where I was before I tried to enter the formula?
Thanks,
Corinne

RE: excel intermediate

Hi Corinne,

Thank you for your question.

The next time it happens just press the Escape key and then you can start again. Alternatively, click the red cross button at the beginning of the formula bar.

I hope this answers your question.

Regards

Simon Khan

Excel tip:

Adding up rows or columns without seeing formulas

Highlight a column or row and click the Autosum button. This gives you your answer without showing the formula.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.