Spread Link

Spread Link
We use cookies to make wikiHow great. By using our site, you agree to our cookie policy . Cookie Settings
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/47\/Link-Sheets-in-Excel-Step-1.jpg\/v4-460px-Link-Sheets-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/4\/47\/Link-Sheets-in-Excel-Step-1.jpg\/aid9071602-v4-728px-Link-Sheets-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"License: Fair Use<\/a> (screenshot)\n<\/p><\/div>"}

Open a Microsoft Excel workbook. The Excel icon looks like a green-and-white "X" icon.

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/17\/Link-Sheets-in-Excel-Step-2.jpg\/v4-460px-Link-Sheets-in-Excel-Step-2.jpg","bigUrl":"\/images\/thumb\/1\/17\/Link-Sheets-in-Excel-Step-2.jpg\/aid9071602-v4-728px-Link-Sheets-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"

License: Fair Use<\/a> (screenshot)\n<\/p><\/div>"}

Click your destination sheet from the sheet tabs. You will see a list of all your worksheets at the bottom of Excel. Click on the sheet you want to link to another worksheet.

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4f\/Link-Sheets-in-Excel-Step-3.jpg\/v4-460px-Link-Sheets-in-Excel-Step-3.jpg","bigUrl":"\/images\/thumb\/4\/4f\/Link-Sheets-in-Excel-Step-3.jpg\/aid9071602-v4-728px-Link-Sheets-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":341,"bigWidth":728,"bigHeight":540,"licensing":"

License: Fair Use<\/a> (screenshot)\n<\/p><\/div>"}

Click an empty cell in your destination sheet. This will be your destination cell. When you link it to another sheet, the data in this cell will be automatically synchronized and updated whenever the data in your source cell changes.

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/12\/Link-Sheets-in-Excel-Step-4.jpg\/v4-460px-Link-Sheets-in-Excel-Step-4.jpg","bigUrl":"\/images\/thumb\/1\/12\/Link-Sheets-in-Excel-Step-4.jpg\/aid9071602-v4-728px-Link-Sheets-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"

License: Fair Use<\/a> (screenshot)\n<\/p><\/div>"}

Type = in the cell. It will start a formula in your destination cell.

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fb\/Link-Sheets-in-Excel-Step-5.jpg\/v4-460px-Link-Sheets-in-Excel-Step-5.jpg","bigUrl":"\/images\/thumb\/f\/fb\/Link-Sheets-in-Excel-Step-5.jpg\/aid9071602-v4-728px-Link-Sheets-in-Excel-Step-5.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":542,"licensing":"

License: Fair Use<\/a> (screenshot)\n<\/p><\/div>"}

Click your source sheet from the sheet tabs. Find the sheet where you want to pull data from, and click on the tab to open the worksheet.

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d9\/Link-Sheets-in-Excel-Step-6.jpg\/v4-460px-Link-Sheets-in-Excel-Step-6.jpg","bigUrl":"\/images\/thumb\/d\/d9\/Link-Sheets-in-Excel-Step-6.jpg\/aid9071602-v4-728px-Link-Sheets-in-Excel-Step-6.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":542,"licensing":"

License: Fair Use<\/a> (screenshot)\n<\/p><\/div>"}

Check the formula bar. The formula bar shows the value of your destination cell at the top of your workbook. When you switch to your source sheet, it should show the name of your current worksheet, following an equals sign, and followed by an exclamation mark.
Alternatively, you can manually write this formula in the formula bar. It should look like =! , where "" is replaced with the name of your source sheet.

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0e\/Link-Sheets-in-Excel-Step-7.jpg\/v4-460px-Link-Sheets-in-Excel-Step-7.jpg","bigUrl":"\/images\/thumb\/0\/0e\/Link-Sheets-in-Excel-Step-7.jpg\/aid9071602-v4-728px-Link-Sheets-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)\n<\/p><\/div>"}

Click a cell in your source sheet. This will be your source cell. It could be an empty cell, or a cell with some data in it. When you link sheets, your destination cell will be automatically updated with the data in your source cell.
For example, if you're pulling data from cell D12 in Sheet1, the formula should look like =Sheet1!D12 .

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c5\/Link-Sheets-in-Excel-Step-8.jpg\/v4-460px-Link-Sheets-in-Excel-Step-8.jpg","bigUrl":"\/images\/thumb\/c\/c5\/Link-Sheets-in-Excel-Step-8.jpg\/aid9071602-v4-728px-Link-Sheets-in-Excel-Step-8.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"

License: Fair Use<\/a> (screenshot)\n<\/p><\/div>"}

Click ↵ Enter on your keyboard. This will finalize the formula, and switch back to your destination sheet. Your destination cell is now linked to your source cell, and dynamically pulls data from it. Whenever you edit the data in your source cell, your destination cell will also be updated.

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/94\/Link-Sheets-in-Excel-Step-9.jpg\/v4-460px-Link-Sheets-in-Excel-Step-9.jpg","bigUrl":"\/images\/thumb\/9\/94\/Link-Sheets-in-Excel-Step-9.jpg\/aid9071602-v4-728px-Link-Sheets-in-Excel-Step-9.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"

License: Fair Use<\/a> (screenshot)\n<\/p><\/div>"}

Click your destination cell. This will highlight the cell.

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/94\/Link-Sheets-in-Excel-Step-10.jpg\/v4-460px-Link-Sheets-in-Excel-Step-10.jpg","bigUrl":"\/images\/thumb\/9\/94\/Link-Sheets-in-Excel-Step-10.jpg\/aid9071602-v4-728px-Link-Sheets-in-Excel-Step-10.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":542,"licensing":"

License: Fair Use<\/a> (screenshot)\n<\/p><\/div>"}

Click and drag the square icon in the lower-right corner of your destination cell. This will expand the range of linked cells between your source and destination sheets. Expanding your initial destination cell will link the adjacent cells from your source sheet.
You can drag and expand the range of linked cells in any direction. This could include the entire worksheet, or only parts of it.

Include your email address to get a message when this question is answered.
All tip submissions are carefully reviewed before being published

Thanks for submitting a tip for review!

New to Excel? Here's 7 Super Easy Tricks to Get You Started

This article was co-authored by wikiHow Staff . Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards. This article has been viewed 286,118 times.

Cookies make wikiHow better. By continuing to use our site, you agree to our cookie policy .
% of people told us that this article helped them.
Helpful how-tos delivered to your inbox every week!
By signing up you are agreeing to receive emails according to our privacy policy.

This article was co-authored by wikiHow Staff . Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards.

The wikiHow Tech Team also followed the article's instructions and verified that they work.

This article has been viewed 286,118 times.

Learn more...

This wikiHow teaches you how to link data between multiple worksheets in a Microsoft Excel workbook. Linking will dynamically pull data from a sheet into another, and update the data in your destination sheet whenever you change the contents of a cell in your source sheet.

1. Open Excel.
2. Click your destination cell.
3. Type " = ".
4. Click another sheet.
5. Click your source cell.
6. Press Enter on your keyboard.
Level up your tech skills and stay ahead of the curve
For over a decade, we’ve been on a mission: to help everyone in the world learn how to do anything. Today, we’re asking that you join us. Any amount that you can contribute helps us to continue providing readers like you with trusted, accurate and up-to-date information. Please consider supporting our continued work with a contribution to wikiHow.

North America / Oceania
Europe

Learn how Spreadshop is working to be the most sustainable print-on-demand merchandise on the planet.
FIND OUT MORE

The Spreadshop Athletes program is empowering a new generation of College Athletes in the Name Image Likeness era.
Become a Spreadshop Athlete

*
Earnings are calculated based on our suggested prices. You can set and adjust your prices on Spreadshop at any time.

Gscheade Leibal
Spreadshop Partner since 2006

Amorphia Apparel
Spreadshop Partner since 2006

Chef Shirts
Spreadshop Partner since 2018

The High Frontier
Spreadshop Partner since 2017

Little Adventures
Spreadshop Partner since 2017

Dad’s Life
Spreadshop Partner since 2017

Waldogs
Spreadshop Partner since 2015

Danger Ecole
Spreadshop Partner since 2008

Gscheade Leibal
Spreadshop Partner since 2006

Amorphia Apparel
Spreadshop Partner since 2006

Chef Shirts
Spreadshop Partner since 2018

The High Frontier
Spreadshop Partner since 2017

Design Tutorials
Marketing Tips and Tricks
Regular Dev Updates

Sell Merchandise

Custom Merchandise

YouTube Merchandise Maker

Merchandise Creator

Sell Custom T-shirts

Sell Shirts Without Inventory

Free Online Shop

About Spreadshop

About Us

Spreadshop for Businesses

Help

Contact

Forum

Legal

Privacy
Policy

Do not sell my
personal information

Wiki

North America / Oceania
Europe

Don't waste your time on the tedious work.
No need to worry about payments, production, fulfillment or shipping. We've got that covered at no cost to you.
Modify your shop start page to match your brand. Customization settings are quick and easy, so you can stay focused on selling.
Our performance bonus automatically kicks in when you sell more than 50 items per month.
Spreadshop prints on top quality brands like Next Level, Bella Canvas and more. Over 130 items to customize. Take a look.
We're just chock-full of resources to help YOU be the BEST.
Embed your shop in your own site or use one our official plugins.
While we specialize in print-on-demand, we also have a bulk service that can dropship anywhere on earth.
Spreadshop has partnered with Placeit, offering thousands of product photos for you to mockup.
Connect with our shop owners and see how they create with passion and make merch happen!
Our blog is one of the most helpful resources for shop owners. You'll always be in the know and never in the dark.
No matter your passion, we'll make it happen.

Overview

Features

Security

Pricing

More tools

Drive

Gmail

Meet

Calendar

Docs

Sheets

Slides

Forms

Sign up for free

For my personal use

For work or my business

You control your data.

We never use your Sheets content for ad purposes.

We never sell your personal information to third parties.

Choose from a variety of dashboards, project trackers, and other professionally-designed templates to kick things off quickly.

An integrated suit of secure, cloud-native collaboration and productivity apps powered by Google AI.

Create and collaborate on online spreadsheets in real-time and from any device.

T h e s e n u m b e r s l o o k v e r y s t r o n g !

Establish a ground truth for data in your online spreadsheet, with easy sharing and real-time editing. Use comments and assign action items to keep analysis flowing.

Assistive features like Smart Fill and formula suggestions help you analyze faster with fewer errors. And get insights quickly by asking questions about your data in simple language.

Sheets is thoughtfully connected to other Google apps you love, saving you time. Easily analyze Google Forms data in Sheets, or embed Sheets charts in Google Slides and Docs. You can also reply to comments directly from Gmail and easily present your spreadsheets to Google Meet.

Easily edit Microsoft Excel spreadsheets online without converting them, and layer on Sheets’ enhanced collaborative and assistive features like comments, action items, and Smart Fill.

Speed up workflows by building business apps and automations. Use AppSheet to build custom applications on top of Sheets, without writing code. Or add custom functions, menu items, and macros with Apps Script.

With Sheets, everyone’s always working on the latest version of a spreadsheet. And with edits automatically saved in version history, it’s easy to undo changes or even see edit history of an individual spreadsheet cell.

Pull in
Nasty 1
Naughty America Babes
Mature Fucking Hd

Spread Link

Report Page