Excel: How To Reference Cells in Other Worksheets

Contributor Icon Contributed by shamanstears Date Icon August 28, 2006  
Tag Icon Tagged: Microsoft Excel

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

Previous recipe | Next recipe |
 
  • garrison
    how to reference the name of worksheet as a valuable, ie. from the content of another cell, thx.?
  • joe
    thank you u saved my life
  • Michael
    can the worksheet be referenced other than by name? i'd like to get data from one sheet to the left, regardless of its name. i'm using =INDIRECT(ADDRESS... etc to enter a value in a cell, and a macro to name the worksheets based on that cell. it all works fine, but when i copy the sheet data to a new sheet, i have to replace the worksheet name in the cell formula, which kind of defeats the purpose of all the coding. thanks!
blog comments powered by Disqus