Excel: How To Reference Cells in Other Worksheets

Home -> Windows -> Office -> Excel

17640 views

From the computer of: shamanstears (738 recipes)
Created: Aug 28, 2006     Updated: Oct 18, 2006


Add a comment

Add to:
Add to stumbleuponAdd to del.icio.usDigg itAdd to FURL

For an Excel formula that needs to reference a cell in a different worksheet in the same workbook, use the following format for your formula.

SheetName!CellAddress (Precede the cell address with the worksheet name, and follow it with an exclamation point).

Note: For worksheet names that include one or more spaces, you will need to enclose it in single quotation marks. The following is a formula that refers to a cell on a sheet by the name of Monthly Sales:

=B4*'Monthly Sales'!A12

Subscribe to the Tech-Recipes Newsletter

You can get tips like this delivered in your email every week!

Enter your Email

We will never, ever sell your email address or spam you.





Related recipes:

  Excel 2007: Change the Number of Worksheets in Your New Workbooks
  Excel: How To Hide Formulas from Other Users
  Excel 2007: Locate Cells Containing Conditional Formatting
  Excel 2007: Have Your Data Read Back To You
  Excel 2007: Where Did They Hide My Favorite Commands?
  Excel 2007: How To Add Headers and Footers to Your Worksheets
  Excel 2007: Clear All Formatting From a Range of Cells
  Excel 2007: Use the Watch Window to Monitor Cells
  Excel: Copy Formatting from One Cell or Range to Another
  Excel 2007: Use Data Bars for Cell Value Analysis

 

Sponsored links

 

Affiliated Sites


Certification Journals
Free certification exam study guides and help

Tech-Recipes Blogs
More tips and news from the tech-recipes authors

 

Login

Nickname

Password

Don't have an account yet? You can create one. As a registered user you have some advantages like theme manager, comments configuration and post comments with your name.