Scrigroup - Documente si articole

Username / Parola inexistente      

Home Documente Upload Resurse Alte limbi doc  

AccessAdobe photoshopAlgoritmiAutocadBaze de dateCC sharp
CalculatoareCorel drawDot netExcelFox proFrontpageHardware
HtmlInternetJavaLinuxMatlabMs dosPascal
PhpPower pointRetele calculatoareSqlTutorialsWebdesignWindows

AspAutocadCDot netExcelFox proHtmlJava
LinuxMathcadPhotoshopPhpSqlVisual studioWindowsXml

Refer to a cell or range on another sheet


+ Font mai mare | - Font mai mic

refer to a cell or range on another sheet

A 3D reference is one that includes a reference to one or more cells that is not on the same worksheet as the formula. For example, you might create a Summary sheet that pulls in totals from each of several other sheets in the workbook.

You're already familiar with the way area codes in phone numbers work, right? When you're dialing a number that's within your area code, you usually don't have to dial the area code. It's only when you're calling outside it that the area code becomes necessary.

It's the same thing with sheet names. If a formula refers to a cell on the same sheet, the sheet name can be left out; otherwise, it must be included.

Sheet names appear in formulas with an exclamation point after their names, like this:


So, for example, if I want to refer to cell A2 on Sheet2, the full way of expressing that is


Ranges work the same way. The range of A2:C6 on Sheet2 is


If you only want to repeat the value of whatever is in the cell, just precede it with an equal sign:


You can also use it in calculations, just like a normal cell or range. For example:


If you don't remember the sheet name and it isn't convenient to look it up, you can create a formula by selecting instead. Let's say, for example, that you want to create the preceding formula example by selecting. Here's how you would do it:

  1. Click in the cell where the formula should appear, and type
  1. Click the tab for the sheet containing the cells to which you want to refer. (In our example, that's Sheet2.)
  2. Select the cells you want to refer to. (In our example, that's A2:C6.)
  3. Press Enter. You're returned to your original formula, with the sheet name and range filled in.
  4. Type ) -- the closing parenthesis -- and press Enter.

You can also use this process to refer to cells and ranges in other workbooks.

Politica de confidentialitate



Vizualizari: 639
Importanta: rank

Comenteaza documentul:

Te rugam sa te autentifici sau sa iti faci cont pentru a putea comenta

Creaza cont nou

Termeni si conditii de utilizare | Contact
© SCRIGROUP 2023 . All rights reserved