Home
More Briefs
Get news delivered to you
BYTE Categories
Tips

Reference Other Worksheets in Excel To Work from Just One

Comments | Jeremy Lesniak, BYTE | August 05, 2011 11:00 AM

Category: Operating systems, Desktop PCs

MS Excel lets you reference data from different worksheets. To do this, use the worksheet title followed by an exclamation point. This way you can perform any calculation that you would with data or cell references, but within one worksheet.

For instance, in the image below, I took data from Cell B2 of my worksheet titled Software and placed it in cell C2 of the worksheet titled Hardware. I did this by typing =Software!B2 into cell C2 of the Hardware worksheet.

More tips >>



Related Reading

News

Commentary

Most Popular

On the Web



Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

BYTE encourages readers to engage in spirited, healthy debate, including taking us to task. However, BYTE moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing/SPAM. BYTE further reserves the right to disable the profile of any commenter participating in said activities.

COMMENTS
Tune In to BYTE
Facebook Twitter LinkedIn Newsletter RSS
Whitepapers
whitepaper
CIO Strategies for Consumerization: The Future of Enterprise Mobile Computing
In this paper you will learn the five trends shaping the future of enterprise mobility. Learn how the rise of social media as a business application, the lurring between work and home, the emergence of new mobile devices, the demand for tech savvy employees and changing expectations of corporate IT will fundamentally change the workplace.
whitepaper
Media Tablets in the Enterprise
In a survey of more than 1,700 information workers (iWorkers) in North America, notebooks, desktops, and smartphones were found to be “must-have” devices, while tablets, slates, and netbooks were relegated to “nice-to-have” status, according to a commissioned study conducted by Forrester Consulting on behalf of Dell and Intel.
Sponsored by: Dell
Upcoming Events
  • BYOD and Windows 7 Migration are the Questions. Is Desktop as a Service the Answer?
  • Mobile DevOps - Handling Platform Sprawl
  • Using 3D Tools to Create Mobile/Casual Hits: The Fieldrunners Story
  • CTO to CTO: Scott Davies, VMware, and Jim Davies, Mitel, Give Voice to the Virtual Desktop
  • What Impact Will Windows 8 Have on the Tablet Market?


    • More Webcasts>>