Microsoft Excel 2007 - Customize the Layout

Split a WorksheetYou can split a worksheet into multiple resizable panes for easier viewing of parts of a worksheet. To split a worksheet:Select any cell in center of the worksheet you want to splitClick the Split button on the View tabNotice the split in the screen, you can manipulate each part separatelyFreeze Rows and ColumnsYou can select a particular portion of a worksheet to stay static while you work on other parts of the sheet.  This is accomplished through the Freeze Rows and Columns Function.  To Freeze a row or column:Click the Freeze Panes button on the View tabEither select a section to be frozen or click the defaults of top row or left columnTo unfreeze, click the Freeze Panes buttonClick UnfreezeHide WorksheetsTo hide a worksheet:Select the tab of the sheet you wish to hideRight-click on the tabClick HideTo unhide a worksheet:Right-click on any worksheet tabClick UnhideChoose the worksheet to unhide