• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer
WebSetNet

WebSetNet

Technology News

  • Technology News
    • Mobile
    • Games
  • Internet Marketing
  • System Admin
    • Windows 11
    • Linux
    • Mac & Apple
    • Website Scripts
      • Wordpress

How to Cross Reference Cells Between Excel Spreadsheets

August 5, 2020 by Martin6

Like a map, each cell in Excel has a reference that you can refer to in other worksheets and Excel files. Here’s how.

For every cell in an Excel spreadsheet, there’s a reference to it. This allows you to refer to this cell elsewhere in an Excel spreadsheet. You can cross-reference this cell in the same worksheet, in different worksheets in the same file, and across different Excel spreadsheets entirely.

This is a useful feature that allows you to keep data separate and organized across different sheets and files. If you want to know how to cross-reference cells between Excel spreadsheets, here’s how.

Cross Referencing Single Cells in Excel

If you’ve ever used a map, you’ll be familiar with the idea of grid references. A map is split up into a grid, allowing you to pinpoint a specific location using the individual grid reference.

An Excel spreadsheet works in a similar way. A spreadsheet in Excel is split into cells, which you can reference using letters for columns and numbers for rows. Cell C7, for instance, is in the cell that intersects the third column (column C) and row 7.

To reference this cell in your active worksheet, type =C7 in a different cell, or use a formula containing that cell reference that combines multiple cell references together. =C7*C8 multiplies the data from C7 with the data from cell C8, for instance.

Single cell references in Excel

If you want to reference a cell from a different worksheet, you need to put the name of the worksheet before the cell, followed by an exclamation mark. The correct format for this is =Sheet2!C7.

A single worksheet cell reference in Excel

The formula =Sheet2!C7*Sheet2!C8 would multiply the data from cells C7 and C8 in a worksheet named Sheet2.

You can also reference cells from another Excel spreadsheet file. You’ll need to use square brackets to identify the file, name the worksheet it’s from, then use the cell reference. For instance, =[Spreadsheet.xlsx]Sheet2!C7.

Single cell reference from an external Excel spreadsheet file

Using =[Spreadsheet.xlsx]Sheet2!C7*[Spreadsheet.xlsx]Sheet2!C8, you’d be able to multiply the data from cells C7 and C8 in worksheet Sheet2 from a file called Spreadsheet.xlsx.

Referencing Cell Ranges in Excel

It’s also possible to reference multiple cells in Excel, so long as they follow sequentially. You can use references to cell ranges in certain formulae.

For instance, finding the sum of cells C7 to C10 is easy—simply type =SUM(C7:C10), using a colon to connect the start (C7) and end (C10) cells in the range.

An Excel SUM formula using a cell range

You can reference cell ranges in other worksheets and Excel spreadsheet files, too. This follows the same naming approach as listed above for individual cells.

To reference a cell range from another worksheet in the same file, name the worksheet before the cell range. For instance, =SUM(Sheet2!C7:C10).

An Excel SUM formula using a cell range from a different worksheet

To reference a cell range from another file, use square brackets to name the file, followed by a reference to the worksheet, and finally the cell range. For example, =SUM([Spreadsheet.xlsx]Sheet2!A7:A10).

An Excel SUM formula using a cell range from a different Excel file

Referencing Named Cells in Microsoft Excel

Microsoft Excel allows you to give a set name to a cell, replacing the grid-style reference. To do this, select your cell, then provide a name for it in the text box next to the formula bar.

You can then use this defined cell name as a reference in other cells. For example, a named cell named namedcell could be referred to in another cell as =namedcell.

A named cell reference in Excel

This named cell reference can be used as-is across your entire worksheet. For example, if it was on a worksheet named Sheet2, you would still use the =namedcell reference to refer to it.

If you want to reference a named cell from another Excel spreadsheet, you don’t need to use square brackets.

Typing =Spreadsheet.xlsx!namedcell would refer to a cell named namedcell saved in an external Excel spreadsheet file named Spreadsheet.xlsx instead.

A named cell reference from an external Excel file

Organizing Data in Microsoft Excel

Knowing how to cross-reference cells in Excel allows you to organize data more effectively. You don’t need to work on a single sheet—you can use data from a single cell across different worksheets and spreadsheet files.

You can then take this data and refer to it in other software. For instance, you could begin embedding Excel with your OneNote notes. If you’re new to Excel, don’t worry—there are plenty of Excel tips that will help you get up to speed quickly.

Twitter Facebook Pinterest Linkedin WhatsApp

Related posts:

  1. How to Use Excel Like a Pro: 18 Easy Excel Tips, Tricks, & Shortcuts
  2. Microsoft Excel Basics Tutorial – Learning How to Use Excel
  3. How to Learn Excel Online: 17 Free and Paid Resources for Excel Training
  4. Link Cells Between Sheets and Workbooks In Excel
  5. 12 Basic Excel Functions Everybody Should Know
  6. The Ultimate Guide to Google Sheets
  7. How to Rename Columns or Rows in Google Sheets
  8. Convert JSON to Excel using free online converter tools
  9. How to Count Cells With Text in Microsoft Excel
  10. Here are the Top 24 Functions in Microsoft Excel You Should be Using

Filed Under: Windows 11 Tagged With: excel, reference, spreadsheets

Primary Sidebar

Trending

  • How To Extract & Install tar.gz Files In Ubuntu
  • 8 Best Sites to Read Manga Online for Free
  • Exclamation Mark on Network Signal, Mobile Data Not Working? 8 Ways to Fix
  • 3 Ways to Disable GetApps on Xiaomi, Redmi, and Poco Phones Running MIUI
  • How to Track a Stolen or Lost Nintendo Switch
  • How to find a lost Apple Pencil using your iPad (1st and 2nd gen)
  • How To Fix No Sound On YouTube
  • How to lock Shape, Image or Objects in Microsoft PowerPoint
  • 7 Ways to Save an Image From Google Docs
  • How to Make Any Wired Printer Wireless in 6 Different Ways
  • Samsung TV model numbers explained 2022: What you need to know about Samsung’s OLED, Mini LED, QLED and LCD televisions
  • How Much Data is Consumed by Zoom, Google Meet, Skype, Microsoft Teams, Slack and Hangouts?
  • How to Boot a Mac in Safe Mode
  • How To Install Android App APK on Samsung Tizen OS Device
  • Microsoft Edge’s newest feature? Shopping in Microsoft Edge
  • How to Find Hidden & Saved Passwords in Windows
  • Fix Windows Update Error 0x800f020b
  • Fix: Nvidia High Definition Audio no sound / not working

Footer

Tags

Amazon android Apple Asus available download: edge feature features first free from galaxy Game games gaming gets google install Intel iPhone launches linux Microsoft more OnePlus phone release released review: samsung series support this Ubuntu update using video watch what will windows with xbox your

Archives

  • December 2023
  • November 2023
  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org