Looking for Something Specific?
Search the I.T. and Business News You Need Archives.
San Jose-based BC Networks provides managed IT services and Microsoft support in the San Francisco Bay Area. Contact us today for more information on how we can transform your business and make your employees more productive.
“A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate,” according to Microsoft.
BC Networks offers Microsoft Support in San Francisco Bay Area, including MS Excel training. This article is based on video produced by the company. Learn tips and tricks on how to link cells and cell ranges in a single workbook or in a separate workbook.
In this tutorial, you can learn:
Creating links, also called external cell references, eliminates manually entering the same information in multiple places. This saves time, reduces errors an improves the reliability of your data.
For example, product prices may be stored in a worksheet called “Master Price List” and other sheets might link to it. A sales manager could use detailed sheets for each salesperson and then create a summary sheet that compares performance and adds up total sales.
“Some of the most useful and time-saving features in Excel are the options to link data across worksheets…including how to link several worksheets in one workbook,” according to a comprehensive video tutorial from BC Networks.
An Excel link, or external cell reference, dynamically pulls data from one worksheet into the same workbook or a new workbook. It’s written like a formula.
The worksheet that contains the data is called the source worksheet; the external cell reference is written in the destination worksheet which copies the data in the source. For added convenience, if the source data changes, so does the destination worksheet cell when it’s opened.
Open the destination worksheet and all workbooks that contain source worksheets. Make sure they’re open the same Excel window. There are a few ways to create the link; here’s the easiest:
If you want to link a range of cells, simply select them then click copy. Within the destination sheet, select the cell where the upper-left cell of the chosen range should appear. Right-click and select Paste Link.
The contents of the source cells will now appear in the destination worksheet. Each cell will have its own link back to the source worksheet.
San Jose-based BC Networks provides managed IT services and Microsoft support in San Francisco Bay Area. Contact us today for more information on how we can transform your business and make your employees more productive.