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
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Resolved · Low Priority · Version 2003
Peter has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
with 07, when validating formulas across two different sheets, where do the arrows point
Hello Peter
Thank you for your question and welcome to the forum.
When using the Trace Precedents or Trace Dependents buttons for formula auditing purposes, you will find that if a formula refers to a cell (or cells) located on another sheet, an arrow with a small spreadsheet icon will appear (instead of the blue or red arrows you usually see).
If you hold your mouse anywhere along the dashed line ending in the arrow, then double-click, the Go To dialogue box will appear so you can select the cell that is being referred to and then click OK to go to the cell.
I hope this helps.
Kind regards
Amanda
Wed 18 Feb 2009: Automatically marked as resolved.
|
Excel tip:Copying Formulae QuicklyThere is a quicker way of copying a formula down a column. |
We'll call during UK business hours
Server loaded in 0.09 secs.