How Do I Reference a Cell in Another Worksheet in Excel?. Learning to use Excel worksheets like relational databases can help you save time, eliminating duplication when managing large projects.

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.

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.

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

Find the sheet you want to link to under Cell Reference. Highlight the sheet. In the Text To Display control, Excel will combine the sheet name with a reference to cell A1.

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

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

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