Print a Range,Split a Worksheet,Freeze Rows and Columns & Hide Worksheets

Print a Range,Split a Worksheet,Freeze Rows and Columns & Hide Worksheets

    Print a Range
    There may be times when you only want to print a portion of a worksheet. This is easily done through the Print Range function. To print a range:
    • Select the area to be printed
    • Click the Print Area button on the Page Layout tab
    • Click Select Print Area
    Print a Range
    Split a Worksheet
    You 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 split
    • Click the Split button on the View tab
    • Notice the split in the screen, you can manipulate each part separately
    Split a Worksheet
    Freeze Rows and Columns
    You 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 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
    Freeze Rows and Columns
    Hide Worksheets
    To hide a worksheet:
    • Select the tab of the sheet you wish to hide
    • Right-click on the tab
    • Click Hide
    Hide Worksheets
    To unhide a worksheet:
    • Right-click on any worksheet tab
    • Click Unhide
    • Choose the worksheet to unhide
    unhide a worksheet

Last modified: Wednesday, 11 January 2012, 11:20 PM