answersLogoWhite

0


Best Answer

To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:

=Sheet1!C25

To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:

=Sheet1!C25

To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:

=Sheet1!C25

To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:

=Sheet1!C25

To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:

=Sheet1!C25

To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:

=Sheet1!C25

To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:

=Sheet1!C25

To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:

=Sheet1!C25

To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:

=Sheet1!C25

To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:

=Sheet1!C25

To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:

=Sheet1!C25

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

11y ago

To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:

=Sheet1!C25

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the formula used to duplicate a cell on a different sheet in excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How can you put vlookup formula from three different excel sheet?

When writing the function, in the table array choose the table from the relevant sheet.


What are the different terms used in Microsoft Excel?

Workbook, Worksheets, sheet, rows, columns, pivot, formula, filter And many more.


How do you split multi-worksheet Excel files into single-worksheet ones?

Excel worksheet Separator is a powerful, friendly and easy-to-use Excel tool to split multi-sheet excel files into single sheet excel files with high speed. This excel tool can easy to find you excel files and change the complicated ,duplicate and boring excel works into easy ones.


How is PowerPoint different from Excel?

Excel is a spread sheet programme, PowerPoint is more of a movie programme.


How many ways of referencing cells in a formula in an Excel Sheet?

Three: Relative, Absolute and Mixed.


How do you make a result sheet in Excel?

how to create a excel sheet


What is the formula to copy data from one sheet and to put it in another sheet in Excel?

There is no automatic forumla to copy and paste in excel, unless you write a custom macro. You could use a formula in sheet1 to show the value of a cell on sheet1, like this: In sheet1 put =sheet1!A1


What is the full form of PFA in Excel sheet?

Pfa the excel sheet


How do you get duplicate diploma mark sheet from stae board of technical education chennai?

my 1st sem mark sheet is correction, so i have a duplicate mark sheet


How you delete formula in excel sheet without deleting value?

we can use the option copy and then past special value.


How do you link data in a row on excel master sheet to row on another sheet on Mac Excel 2011?

Use the name of a sheet, followed by an exclamation mark and a cell reference. The following would take the value in cell C21 on Sheet2 and put it wherever the formula is typed. =Sheet2!C21


How do you make a cover sheet in excel?

Add a sheet