navigating workbooks

  1. T

    Highlight previous cell

    I have two monitors with an Excel worksheet open on each. I'm comparing data with lots of rows and columns on each sheet. When I move from one sheet to the other, it would be helpful if I could highlight the cell I'm leaving, so that when I'm looking at the active sheet I can still see where...
  2. L

    Linking to 200 worksheets

    I had an unusual question come to me at work. A manager is creating a report by linking one summary spreadsheet in the same workbook as 200 other spreadsheets where those who report to him enter data into various tables. He wants to know if there is a way to navigate the workbook more easily...

Some videos you may like

This Week's Hot Topics