Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»Excel»How to Reference Another Sheet in Excel

How to Reference Another Sheet in Excel

Asmi DhakalBy Asmi DhakalNovember 2, 2022
reference another sheet in excel

Cell referencing, also known as 3-D referencing, is a convenient method to link contents in two or more sheets. For instance, you could perform calculations in one sheet and then present them on the next sheet by referencing the cells. Professionals mainly benefit from this feature of linking spreadsheets.

If you’re interested in learning more about 3-D referencing, we’ve got you covered. This article will discuss how you can refer cells in two sheets, what you can expect while referencing, and a bonus tip in the end, so keep reading!

Table of Contents

  • What to Expect While Referencing Sheets?
  • How to Reference Another Sheet in Excel?
    • Refer Cells From Another Sheet
    • Pass Cell From Another Cell As Argument
  • How Can I Make Referencing Easier?
    • Name Your Sheet
    • Define a Range

What to Expect While Referencing Sheets?

When you reference cells between two sheets, Excel copies the content of the referred cell to the cell with the formula. You cannot change the cell content in the destination cell; all you can edit is the reference formula. 

If you choose to remove the formula in total, nothing changes in the actual cell. However, if you remove the content from the referred cell, the content is also deleted on the other sheet. This also means that 3-D referencing is dynamic in nature. 

Furthermore, when you reference the cell, you’re referencing the content of the cell. So, if you move the cell content to a different cell location, Excel will automatically change the cell reference in the formula.

How to Reference Another Sheet in Excel?

To reference another sheet in Excel, you need to enter a formula in the cell that includes the sheet name and either the cell or the cell range. In addition to referencing a cell’s content, you can also pass a cell from another cell as an argument in Excel formulas. 

In this section, we have included both of these methods of referencing cells; as a cell content and as an argument.

Refer Cells From Another Sheet

If you want to create a copy of the cell contents from one cell to another, you can do it by entering a simple formula. Here are the steps you can follow to refer to another sheet in Excel:

  1. Launch Excel and open your workbook with your sheets.
  2. On the cell you wish to refer cells from another sheet, enter the formula in this format:
    • For a single cell: (Sheetname)!(cell location)Cell Referencing
    • For cell range: (Sheetname)!(start cell):(end cell)
      Cell Range Reference
  3. Hit Enter on your keyboard.
  4. If you referred a range, use Flash Fill to fill the corresponding cells with the referred value.
    Flash Fill For Sheet Reference

Pass Cell From Another Cell As Argument

Certain library functions offered by Excel allow you to refer to a cell from a different sheet to pass as an argument. If you wish to further manipulate the content of the referred cells from a different sheet using a supported function, follow these steps:

  1. Open your workbook with your sheets.
  2. Select the Sheet you wish to enter the formula with the referred cell.
  3. On an empty cell, enter the equals (=) sign.
    Equals Sign
  4. Enter your formula and then insert an open parentheses ‘(’ sign.
    Enter Formula to Refer Cell
  5. Head to the sheet with the cell you wish to refer, and hit Shift on your keyboard.
  6. Select the cell you wish to refer.
    Select Cells

How Can I Make Referencing Easier?

At times, referencing can become tricky because of the rookie errors we sometimes make. When referencing another sheet, you need to ensure that the sheet name and the cells you’re referring to are entered correctly. To avoid mistakes, you can define your Sheet and the cell range with a name.

Name Your Sheet

Excel, by default, names your sheets as Sheet1, Sheet2, and so on. This naming can get confusing when you have many sheets open. While referencing your cell, rename your sheet to something relevant so that you can visit the referred sheet later.

Refer to the following steps to name your sheet in an Excel workbook:

  1. Open your Excel file.
  2. Right-click on your sheet at the bottom of the Excel program.
  3. Choose Rename.
    Rename Sheet
  4. Enter a name for your worksheet.

Define a Range

Defining your cell range leaves less room for incorrectly referencing your cells. If you incorrectly enter either one of your beginning or ending cells, the value of the entire range will be affected. If you wish to eliminate this issue, follow these steps to define a range in Excel following these steps:

  1. Open your Excel workbook.
  2. Select the range you wish to refer to on the next sheet.
  3. Head to the Formulas tab on the menubar.
  4. Select Name Manager.
    Name Manager Excel
  5. On the window, click on New.
    Create Defined Name in Name Manager Excel
  6. Enter the following details on the New Name Window:
    • Name: Give your range a name.
    • Scope: Select Workbook.
    • Comment: If you wish to note down something else about this range, you can do so in this section.
    • Refers to: Confirm if the cells you wish to define are selected. If not, select the icon next to it, then select the cells you wish to name.
      New Name Excel
  7. Click OK.
how-to
Asmi Dhakal
  • Twitter
  • LinkedIn

Asmi Dhakal is a Tech Writer specializing in Microsoft Office-based programs at TechNewsToday. She aims to use her experience to help others learn their way around its programs. Asmi’s interest in Office products grew when she first entered the marketing industry. While she initially struggled to understand their application, she eventually understood her way around them. In her articles, she exhibits a strong understanding of related issues and attempts to push only relevant fixes. Over time, she has grown a particular fondness for MS Excel and spends her free time learning Visual Basic Analysis (VBA). She’s always on the lookout for productivity tools that can get the job done quicker in Excel. Her approach to related problems is very humane, helping new users not only fix the issue but learn more about its nature. Asmi also heavily indulges in personal writing. She is a disciplined journal writer and has maintained a regular journal for 8 years! When her schedule allows, she works to rehabilitate street animals. You can contact her at asmi@technewstoday.com

Related Posts

check mark in excel

How to Put Check Mark in Excel

January 20, 2023
best excel shortcuts

Best 52 Excel Shortcuts Only Experts Know

January 19, 2023
How to Find and edit Hyperlinks on Excel

How to Find and Edit Hyperlinks on Excel

January 23, 2023
how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how to find links in excel

How to Find and Edit External Links in Excel

January 13, 2023
reference isn't valid excel

Reference Isn’t Valid Excel Error – 6 Ways to Fix it

January 6, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
usb a vs usb c

USB A Vs USB C – What’s the Difference?

January 31, 2023
how long does a cmos battery last

How Long Does a CMOS Battery Last

January 25, 2023
thunderbolt vs usb c

Thunderbolt Vs USB C: What’s the Difference

January 25, 2023
You may also like
Razer Mouse Not Working

Razer Mouse Not Working? Here’re 9 Ways to Fix It

February 3, 2023
how to make cursor bigger

How to Make Cursor Bigger

February 3, 2023
surface-screen-flickering

Why is My Surface Screen Flickering? 6 Ways to Fix It

February 3, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Our Team
  • Editorial Guidelines
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday.

Type above and press Enter to search. Press Esc to cancel.