To cross-reference between spreadsheets, you must identify cells using extended addresses. These extended references specify the cell's sheet as well as its column and row.

Find your favorite Excel 2003 commands in the new Excel 2007 interface Editor’s note: These charts accompany our story Excel 2007 Cheat Sheet.

You can reference a list on another sheet, but it takes a bit more work. In this tutorial, I’ll show you how to populate a dropdown with data on another sheet.

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.

There are a great many keyboard shortcuts you can use to work with Excel more efficiently. For a handy reference to all of them, some which work in ot ...

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Learn how to switch between Excel worksheets using keyboard shortcuts, Watch Window, Activate Sheet, Name Box. Go To dialog box, Hyperlinks. VBA Macro.

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 ...

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.