Using Excel 2: Linking Cells Across Worksheets

Do you work with large Excel workbooks? Then these tips are for you.


  • Open second version of workbook with "New Windows" *
  • View two versions of workbook with with "Arrange All"
  • Scroll while maintaining titles with "Freeze Panes"
  • Link to cells in other worksheets

Using Excel 2: Linking cells across worksheets. [9 min]

icon_Movie.gif Video

           [Only above video format has menus; requires Flash]

icon_Podcast.gif iPod [mp4] iPhone/Android/iPad [mp4]


* For Mac users, click the “Layout” tab and then, in the “Window” area on the right, click the feature you want, such as “New” for a new Excel window. Click here for a screenshot.


Excel ® is a registered trademark of Microsoft Corporation.
Microsoft ® Office Excel ® is part of the Microsoft Office system. All brands and product names are trademarks of their respective owners.