You can move the split to adjust the split. You will see the Watch Window appear and it will remain on top as you work on your spreadsheet. Simply right click a cell and select Add Watch. (in Excel 2007 use View, Window, then Split)Īlso see Cell Watch on Excel 2002 (Tips), add a cell to the Watch Window. Indicator just above or to left of the scrollbar and drag it to where you want Another method to split is to grab the split Split and Freeze Frame are mutually exclusive (one or the The method ofĬhoosing the cell to indicate the split using the Window menu is the same as forįreeze panes. You to view different parts of a sheet at the same time. You can Split the view of a worksheet vertically and/or horizontallyĮach with it own scroll bar, so you could have 4 scroll bars. Split view is similar to Freeze Frame (#split) An alternative to split is to create a new window within Excel to view the same data. Split would allow you to view and scroll independentlyĪ vertical and or horizontal split. Split and Freeze panes are mutually exclusive you can only have one One beyond the second column and then Freeze panes.

To freeze the first two column descriptions, you would select Column C as One beyond the first row the Freeze panes.

To freeze only the first row descriptions, you would select Row 2 as (in Excel 2007 use View, Window, then Freeze panes) These need to be seen as you scroll anywhere on the sheet.Īnd the row descriptions, choose the column and cell beyond In the above example a single row at top is used forĬolumn headings, and a single column at left for row descriptions, and Freeze panes is used for viewing,Īnd Rows/Columns to repeat is used for printing.įreeze panes to display heading columns/rows (#panes) Headings anywhere on the sheet, and when printing we would also want to see the sameĭescriptive information repeated on each page. When viewing a sheet we usually want to see the descriptive column and row Freeze Panes for view and Repeat descriptive row/col headings for printing Freeze Panes for view and Repeat row/col headings for printing

How to freeze frame in excel 97