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

formulas

ResolvedVersion 2010

Samantha has attended:
Excel Introduction course
Excel Intermediate course

Formulas

What is the shortcut for "Trace precedents/dependents" in Excel 2010?

RE: Formulas

Hello Samantha,

Hope you enjoyed your Microsoft Excel courses with Best STL.

Thank you for your question regarding shortcuts for trace precedents/dependents.

If you click on a cell containing a formula and use the shortcut CTRL+[ your cursor is taken to the precedent cell. Keep pressing CTRL+[ until there are no further precedent cells to be found. Pressing CTRL+SHIFT+{ will highlight all the precedent cells at once.

Click a cell that you know is part of a formula and use the shortcut CTRL+] and your cursor is taken to the dependent cell. Pressing CTRL+SHIFT+} will highlight all the dependent cells at once.

Please note that this method does not show the blue line with arrow plus surrounding blue rectangle.

I hope this is what you were looking for.


If it is, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Tue 29 May 2012: Automatically marked as resolved.

Excel tip:

Percentage format

Ctrl+Shift+% applies the Percentage format, with no decimal places.

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.