answersLogoWhite

0

Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.

=Sheet1!C5

You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.

=SUM(Sheet1:Sheet3!A9)

Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.

=Sheet1!C5

You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.

=SUM(Sheet1:Sheet3!A9)

Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.

=Sheet1!C5

You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.

=SUM(Sheet1:Sheet3!A9)

Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.

=Sheet1!C5

You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.

=SUM(Sheet1:Sheet3!A9)

Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.

=Sheet1!C5

You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.

=SUM(Sheet1:Sheet3!A9)

Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.

=Sheet1!C5

You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.

=SUM(Sheet1:Sheet3!A9)

Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.

=Sheet1!C5

You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.

=SUM(Sheet1:Sheet3!A9)

Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.

=Sheet1!C5

You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.

=SUM(Sheet1:Sheet3!A9)

Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.

=Sheet1!C5

You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.

=SUM(Sheet1:Sheet3!A9)

Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.

=Sheet1!C5

You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.

=SUM(Sheet1:Sheet3!A9)

Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.

=Sheet1!C5

You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.

=SUM(Sheet1:Sheet3!A9)

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

Where can I find inference worksheets online?

First go to http://www.ereadingworksheets.com/free-reading-worksheets/reading-comprehension-worksheets/inferences-worksheets/. There you should find multiple links as to what you are looking for.


What is the difference between spreadsheet and worksheet?

A spreadsheet file can contain multiple worksheets. Worksheet is the "grid" that you use to fill information and a spreadsheet can be a single worksheet or multiple worksheets


What can create formulas to the same cell or range in multiple worksheets?

3-D Reference


Purpose of working with multiple spreadsheet?

Purpose of working in multiple spreadsheet:It is the data that separate into the categories such as date or product type. The ability to work of data in multiple worksheet is necessary skill for excel user.For example, you may wonder: Is it possible to enter the same data into several worksheets without retyping or copying and pasting the text into each one? Or, how can you easily sum the cell values across multiple worksheets? Or, how can you list the names of the worksheets in your workbook.


Which key is used to select multiple non consecutive worksheets in a workbook?

You use the Ctrl key with the mouse to do it.


What reading site offers making inferences worksheets?

havefunteaching.com/worksheets/reading-worksheets/inference-worksheets There is a link to a really good website for making inferences worksheets. You can even make your own worksheets.


Where can I purchase antonyms worksheets online?

This site offers antonyms worksheets for sale, http://havefunteaching.com/worksheets/english-worksheets/antonym-worksheets/. They offer worksheets for various grade levels both with and without pictures.


How do division worksheets help children learn math?

Division worksheets help children to learn math by repetitive practice on their skills. Teachers and parents can make division worksheets by searching the internet to help find multiple division problems allowing for the student to continually practice the division skills needed for basic math skills.


How can you tell worksheets are grouped?

Worksheets are grouped in spreadsheet applications like Excel when they are visually indicated by a different color on the tabs or when multiple tabs are highlighted simultaneously. You can also tell they are grouped if actions performed on one worksheet, such as formatting or data entry, are reflected across all grouped worksheets. Additionally, the status bar may display a message indicating that multiple sheets are selected. To ungroup, you typically need to click on a single worksheet tab.


Where can I purchase quality kindergarten worksheets online?

www.schoolsparks.com/kindergarten-worksheets is a good place to find worksheets. There are some free worksheets available to download and there is also a workbook of worksheets available for purchase.


Where can I find math practice worksheets for high school students?

If you want practice worksheets for high school students , just go to http://havefunteaching.com/worksheets/english-worksheets/alphabetical-order-worksheets/. Once there just select the worksheets wanted.


Do spreadsheets have the capability of rendering charts in 3D?

A spreadsheet file also may include multiple worksheets. More than one worksheet can be used to render three-dimensional charts of data. Spreadsheets are very powerful, extensive electronic worksheets.