Layout
Split a WorksheetYou can split a worksheet into multiple resizable panes for easier viewing ofparts of a worksheet. To split a worksheet:
§ Select any cell in center of the worksheet you want to split
§ Click the Split button on the View tab
§ Notice the split in the screen, you can manipulate each part separately
You can select a particular portion of aworksheet 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 tab
§ Either select a section to be frozen or click the defaults of top row or left column
§ To unfreeze, click the Freeze Panes button
§ Click Unfreeze
Hide Worksheets
To hide a worksheet:
§ Select the tab of thesheet you wish to hide
§ Right-click on the tab
§ Click Hide
Post a Comment