Excel Digest

To view multiple worksheets at the same time follow these steps:
1. Open your workbook.
2. In the Window menu click New Window.
3. In the Window menu click Arrange and select an option (Tiled, horizontal .. etc). Now you will have two windows showing the same worksheet.
4. Click on any one of the two windows and select [...]

If you have a large Excel worksheet and find it difficult to navigate from one part of the worksheet to another, then you can use a feature in Excel called Custom Views to define parts of your worksheet as unique units.To create a custom view:

Select the worksheet area that you [...]