Link to Cells on Other Worksheets in Excel

Add to Favorites

It is very easy to link one cell to another cell in Microsoft Excel. The steps needed are listed below as well as pictures for every step.

  1. Double-Click the desired cell in Excel. The cursor should now be flashing in that cell.
  2. Type an equals sign "=" - without the quotes.
  3. Select the tab that contains the cell to which you want to link.
  4. Select the desired cell.
  5. Hit Enter.

Thats all there is to linking cells between different worksheets in Excel.

Note: If you are linking to this cell within a formula or function and need to go back to the original worksheet or tab in Excel, you must first enter something after you have selected the desired cell.

  • If this is used as an argument in a function, enter the comma after the argument and then you can navigate back to the original tab.
  • If you are adding (summing) two cells, enter the plus sign after you select the cell and then you can move back to the original worksheet or tab.

Link to cells on other worksheets or tabs in Microsoft Excel in pictures:

  1. Step 1 - Link Cells Worksheets

  2. Step 2 - Link Cells Worksheets

  3. Step 3 - Link Cells Worksheets

  4. Step 4 - Link Cells Worksheets

  5. Step 5 - Link Cells Worksheets

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Quickly Move Cells Around a worksheet in Excel Cut/Paste Trick
Tutorial: Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forename...
Link Worksheet Form Controls with Cells on Protected Worksheets without VBA Macros in Excel
Tutorial: Simple method to use Excel Form Controls and ActiveX Controls and link them to cells on p...
Shade Every Other Row in Excel Quickly
Tutorial: How to shade every other row in Excel quickly without using the Table feature. This method...
Print The Current Worksheet in Excel
Macro: This free Excel macro will print the current active worksheet in Excel. This means th...
Quickly See All Cells linked to a Formula or Function in Excel
Tutorial: Ill show you how to see the cells used in a formula/function in Excel and also how to tel...