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

To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

Microsoft Excel can't map nonadjacent cells from the source spreadsheet to nonadjacent cells in a destination worksheet, however. While it has no problem linking groups of cells, nonadjacent cells ...

You don’t need to manually re-enter Excel spreadsheet data in another workbook. Learn how to copy a worksheet to another workbook here.

How to Add a Footer to All Sheets in Excel. Adding a footer to all of your sheets in an Excel workbook is a good way to ensure continuity between each sheet, especially if you are printing them out.