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


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...
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...
Delete All Empty Rows or Blank Cells from a Range in Excel
Tutorial: How to quickly delete all empty cells or rows from a range in Excel.  This allows you to q...