answersLogoWhite

0

=Worksheetname!CellReference (=Sheet!A1)

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is a three dimensional cell reference in Excel?

A 3D cell reference includes the row, column and also the sheet. So cell A3 on Sheet2 has a cell reference, as follows with the sheetname followed by an exclamation mark:=Sheet2!A3A 3D cell reference includes the row, column and also the sheet. So cell A3 on Sheet2 has a cell reference, as follows with the sheetname followed by an exclamation mark:=Sheet2!A3A 3D cell reference includes the row, column and also the sheet. So cell A3 on Sheet2 has a cell reference, as follows with the sheetname followed by an exclamation mark:=Sheet2!A3A 3D cell reference includes the row, column and also the sheet. So cell A3 on Sheet2 has a cell reference, as follows with the sheetname followed by an exclamation mark:=Sheet2!A3A 3D cell reference includes the row, column and also the sheet. So cell A3 on Sheet2 has a cell reference, as follows with the sheetname followed by an exclamation mark:=Sheet2!A3A 3D cell reference includes the row, column and also the sheet. So cell A3 on Sheet2 has a cell reference, as follows with the sheetname followed by an exclamation mark:=Sheet2!A3A 3D cell reference includes the row, column and also the sheet. So cell A3 on Sheet2 has a cell reference, as follows with the sheetname followed by an exclamation mark:=Sheet2!A3A 3D cell reference includes the row, column and also the sheet. So cell A3 on Sheet2 has a cell reference, as follows with the sheetname followed by an exclamation mark:=Sheet2!A3A 3D cell reference includes the row, column and also the sheet. So cell A3 on Sheet2 has a cell reference, as follows with the sheetname followed by an exclamation mark:=Sheet2!A3A 3D cell reference includes the row, column and also the sheet. So cell A3 on Sheet2 has a cell reference, as follows with the sheetname followed by an exclamation mark:=Sheet2!A3A 3D cell reference includes the row, column and also the sheet. So cell A3 on Sheet2 has a cell reference, as follows with the sheetname followed by an exclamation mark:=Sheet2!A3


What is a 3-D formula in Excel?

It is a formula that refers to the same cell addresses on more than one sheet. So if you wanted to add the value in C3 on Sheet1, Sheet2 and Sheet3, you would use a 3D formula. To refer to the sheet, you type its name followed by an exclamation mark and then the cell reference. You could start the formula in the cell you want the total to appear. You would type =SUM( and then click on the sheet tab for the first sheet, hold down Shift and select the tab for the third sheet, then click cell C3 and press Enter. The 3D formula created would be: =SUM(Sheet1:Sheet3!C3)


What is an example of a formula with a 3-D reference?

A 3d reference refers to a worksheet, a column and a row, to identify a particular cell in a workbook. The following is a simple example, where the worksheet name is in the reference and is followed by an exclamation mark before the cell address: =Sheet1!A3 * 10


Do any cinemas have Avatar not in 3D?

Avatar is out in a regular format, as well as digital 3D and IMAX 3D.


What do you mean by digital edition?

it means that it is in a new format and will not be in 3d


Is Alien In The Deep an IMAX 3D movie?

Yes, in fact Alien in the deep was shot in IMAX 3D format.


What is 2d avatar?

Avatar is showing in 3 formats in theaters: in IMAX 3D, 3D, and in regular cinema format.


How do you turn soul silver 3D?

SoulSilver is not a 3D game. You cannot turn it into a 3D game, either. SoulSilver is stuck in it's 2-dimensional format.


Are Blu-ray movies the same as 3D movies?

No. Blu-ray is a high definition DVD format that has nothing to do with 3D.


When would the internet or worldwideweb be in 3D?

As of 2014 some parts of the world wide web and internet are available in 3D. There is no set time when all of it will be available in 3D format.


What 3D movie format does the Sony Bravia 3DTV support and how would you play it 3D?

Check your televisions owners manual to learn how to switch back to 3d mode.


In computing what does the Collada format mean?

Collada format stands for collaborative design activity. It is developed by Sony Computer Entertainment and is an interchange file format for interactive 3D applications.