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

track changes

ResolvedVersion 2003

Helen has attended:
PowerPoint Introduction course
Excel Intermediate course

Track changes

With the arrows which show track changes. With complictaed formula, can it formaula be summarised?

RE: track changes

Hello Helen

Thank you for your question.

I'm unclear as to whether you are referring to using track changes in Excel; or using the Formula Auditing tools Trace Precedents or Trace Dependants arrows that appear in blue or red on your screen.

Also if you could explain more about what you mean by summarising a formula in relation to using track changes or Trace Precedents/Trace Dependants.


Kind regards
Amanda

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

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.09 secs.