Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Opening cell links

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Opening cell links

Resolved · Medium Priority · Version 2007

Reply Thu 28 Oct 2010, 11:24Delegate Elishka said...

Elishka has attended:
Excel Intermediate course

Opening cell links

Hi there,

I'm just wondering...

When you have a cell with a value linked in from another sheet or workbook, how do you get excel to open up the original sheet to see where exactly the value has come from - rather than going through the file extension in my computer as I've been doing?!

I'm sure there's a shortcut for this but have totally forgotten how to do it.

Thanks very much,

For upcoming training course dates see: Pricing & availability

Reply Thu 28 Oct 2010, 12:42Trainer Anthony said...

RE: Opening cell links

Hi Elishka, thanks for your query. If you select the cell and then on the Formulas tab click Trace Precedents, you'll see a dashed line and a table icon. Double click on the dashed line and then select the reference in the Go To box that appears. You'll be taken straight to the cell that is linked!

Hope this helps,

Anthony

Wed 3 Nov 2010: Automatically marked as resolved.

Excel articles

· Microsoft Excel Training: Not Just for Newbies Anymore
· Learn The Secrets Of COUNT Functions In Excel
· MS Excel: Excel At Making The Most Of Your Christmas
· Edit Anywhere With Mobile Spreadsheets
· Plug Into The Big Grid

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

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips