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

excel shortcuts precedents

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2016, shortcuts for precedents across tab/sheets

Excel 2016, shortcuts for precedents across tab/sheets

ResolvedVersion 2016

Michael has attended:
Excel Advanced - Formulas & Functions course

Excel 2016, shortcuts for precedents across tab/sheets

Hello,

We tend to have excel with many sheets and they tend to refer to each other.

For one of them, it can be a simple reference e.g. ='Sheet1'!A3 (approximated spelling for visual aid only) for instance, but it can also be more than one reference like ='Sheet1'!A3+'Sheet2'!Z33

To "run" to a particular reference, a quick shortcut of Ctrl+[ is required, but it only goes to the first reference. Is there a way to choose the 2nd or 3rd reference for instance?

Using the mouse to click on trace all precedents seems too long, as then I have to double click a certain place and then figure out which one to use using the mouse.

Many thanks.

RE: Excel 2016, shortcuts for precedents across tab/sheets

Hello Michael,

Thank you for your question. One way to jump to any reference in a formula is to double-click on the formula in its cell, highlight the reference inside the formula you wish to go to, press F5, then Enter. This will take you to the sheet and cell(s) you selected.

I hope this helps!

Kind regards
Marius Barnard
STL

Wed 18 Dec 2019: Automatically marked as resolved.

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

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