0
In Excel 2007 how can you add a cell from one sheet to a cell on another sheet of the same workbook?
To specify a cell on another sheet, you need to use the name of the sheet and an exclamation mark before the cell reference. If you do not put a sheetname before a cell, it assumes the cell is from the current sheet. So if you were on Sheet2 and wanted to add a value in cell C5 on Sheet1 to cell C6 on Sheet2, then the formula would be:
=Sheet1!C5+C6
If you were on Sheet3 and wanted to add a value in cell C5 on Sheet1 to cell C6 on Sheet2, then the formula would be:
=Sheet1!C5+Sheet2!C6
If you have renamed your sheets then you use the new names for the sheets, rather that Sheet1, Sheet2 etc.
What else can I help you with?
What is a Workbook in Excel 2007?
A workbook in Excel is a collection of worksheets. You can tell if you have more than one worksheet in the workbook if you see multiple tabs at the bottom of the screen. The default setting of Excel 2007 includes three worksheets in the workbook, labeled Sheet 1, Sheet 2, and Sheet 3.
What is the name given to an Excel workbook before you rename it?
A workbook in Excel will be Book1.xlsx for versions from Excel 2007 onwards, or Book1.xls for earlier versions.
How do you move a worksheet in Excel 2007?
The question is not clear, but if you have several worksheets in an Excel 2007 workbook, you can move a worksheet to a new location in the workbook by clicking and dragging the worksheet tab to the loction you want.
How do you get out of compadibility mode in Excel?
Save the workbook as an Excel 2007 file instead of 97-2003 file.
Does an Excel workbook have a file extension?
Yes. It is .xls for version up to Excel 2003 and .xlsx for versions from Excel 2007 onwards.
How is a sheet made active on excel 2007?
Select the sheet.
Does Microsoft Office Excel 2007 displays a warning whenever you open a workbook?
Usually, no.
How many cells in a 2007 Excel sheet?
17,179,869,184 cells in one excel
What is the extension for excel 2007 worksheets?
Worksheets do not have extensions. They are contained in files known as workbooks. A 2007 workbook extension is .xlsx.
What is a embedded pie chart in Excel 2007?
It is a pie chart that is part of the sheet it is on and not on a sheet on its own.
How many sheets are there in Excel 2007?
The default is 3. The maximum number of sheets in a workbook is limited by the computers memory.
How do you convert Microsoft Excel 2007 file to 2000?
open file in excel 2007 then press ribbon and go to Save as, you will see Excel 1997-2003 Workbook option, click on it and save file.
