View(s), simply close them one at a time using the to close the worksheet

ToД¬reate a view use Window (menu), New Window. Suffix of a colon and a digit (:1) to the worksheet name. AnyД¬hange to one view would be immediately reflected in the other views since theДЄre just views and not separate files. Same workbook as you can scroll them or switch worksheets etc. Use of New Window from the Window menu provides the ability to get anДЄdditional view of the workbook. 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 undo freeze frame in excel