Use the extended reference to identify the cell in formulas. For example, a cell in a different sheet that adds 20 to the value in the first cell must use the following formula:=Sheet1!A1 + 20 ...

Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook. Before you apply this formula, check that each worksheet is formatted the same way.

Q. I have an amortization schedule arranged vertically in Excel on Sheet 1 that I want to reference horizontally in my income statement on Sheet 2. Is there a way to write and copy/paste a single ...