There used to be a time when the help in word and excel was ... ummm ... helpful. I remember writing an assignment when I was at University in 1991; we'd just switched from word perfect to ms word; the help was fantastic. But nowadays ...
Anyway. Today I found out how to arrange 2 (or more) sheets from the same workbook so that I can see both at the same time. It's easy to do with two different spreadsheets, but look what you have to do when they're in the same workbook.
Here's what you have to do:
View multiple sheets or workbooks at the same time
- Open the workbooks you want to view.
- To view multiple sheets in the active workbook, click New Window on the Window menu.
- Switch to the new window, and then click a sheet you want to view. Repeat for each sheet you want to view.
- On the Window menu, click Arrange.
- Under Arrange, click the option you want.
- To view sheets in only the active workbook, select the Windows of active workbook check box.
