Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Opening cell links
Resolved · Medium Priority · Version 2007
Elishka has attended:
Excel Intermediate course
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,
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 tip:Paste functions box quicklyIf you want to do a formula using the paste functions box press SHIFT + F3. |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
