Friday, April 29, 2005
In Excel, the biggest problem with keeping your spreadsheet data on different worksheets rather than keeping it all together on the same sheet is being able to compare the information on the different sheets.
When you use a single worksheet, you can split the workbook window into horizontal or vertical panes and then scroll different sections of the sheet into view. The only way to do this when the spreadsheet data are located on different worksheets is to open a second window on a second worksheet and then arrange the windows with the different worksheets so that data from desired regions are both displayed on the screen. The easiest way to do this is to use Excel's new Compare Side by Side command to tile the windows one above the other and automatically synchronize the scrolling between them.
When you use a single worksheet, you can split the workbook window into horizontal or vertical panes and then scroll different sections of the sheet into view. The only way to do this when the spreadsheet data are located on different worksheets is to open a second window on a second worksheet and then arrange the windows with the different worksheets so that data from desired regions are both displayed on the screen. The easiest way to do this is to use Excel's new Compare Side by Side command to tile the windows one above the other and automatically synchronize the scrolling between them.
