answersLogoWhite

0

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

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

How do you make a result sheet in Excel?

how to create a excel sheet


What is the full form of PFA in Excel sheet?

Pfa the excel sheet


How do you copy a protected cell in excel without removing the protection to another excel sheet?

Cell protection only kicks in when you protect the entire sheet. So for the cell to be protected, then the sheet has to be protected.


What is the difference between Excel sheet and spread sheet?

They are the same thing, excel is Microsoft's spreadsheet programme.


How do you calculate Microsoft Excel sheet Debt-Service Coverage Ratio - DSCR?

Calculating DSCR in Excel sheet


How many cells in a 2007 Excel sheet?

17,179,869,184 cells in one excel


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 do i copy data from one excel sheet to another automatically?

To automatically copy data from one Excel sheet to another, you can use formulas or Excel's built-in features. For example, you can use the =Sheet1!A1 formula in the target sheet to reference a specific cell from the source sheet, allowing it to update dynamically. Alternatively, you can utilize Excel's Power Query feature to import and transform data from one sheet to another automatically. For more complex automation, consider using VBA macros to copy data based on specific conditions or triggers.


How do you make a cover sheet in excel?

Add a sheet


What is a model in excel?

A spread sheet


How is PowerPoint different from Excel?

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


How is a sheet made active on excel 2007?

Select the sheet.