Microsoft Office Tutorials and References
In Depth Information
Navigating with the Go To Dialog Box
Creating links between workbooks requires a high level of discipline and consistency in file
naming and locations. If you move or delete a workbook that contains source data for links
in another workbook, you risk breaking the links and orphaning your data.
To see and edit all external links in the current workbook, click File to open Backstage view.
On the Info tab, in the lower right corner, click Edit Links To Files. That opens a dialog box
that allows you to update values, change the source of the linked data, open the source
workbook, or change the Startup Prompt behavior.
In some cases, you might want to convert the data in your workbook to its current values
so that it is no longer dependent on the linked workbooks. That might be your preferred
strategy if your fiscal year has ended and the departmental worksheets are final and no
longer need updating. In that case, click Break Link to permanently convert any formulas
and external references to their current values. As a stern warning sensibly advises, you
should make a backup copy before taking this irrevocable action.
Navigating with the Go To Dialog Box
Most of the time, you use scroll bars and keyboard shortcuts to navigate through a
workbook. You can use the Name box to jump to named ranges, tables, and charts in the
current workbook. A well-hidden Excel feature called the Go To dialog box gives you a list that
includes the same options as the Name box as well as a history of cells and ranges you’ve
selected recently. To open this dialog box, click Find & Select (in the Editing group on the
Home tab) and then click Go To, or use either of the keyboard shortcuts, F5 or Ctrl+G. The
Go To dialog box, shown in Figure 14-7, contains a list of recent destinations.
Search JabSto ::

Custom Search