Free Microsoft Office Tutorials | Online Office Learning Guide | Microsoft Office Tips and Tricks

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

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

Hide Worksheets
To hide a worksheet:

• Select the tab of the sheet you wish to hide
• Right-click on the tab
• Click Hide

To unhide a worksheet:

• Right-click on any worksheet tab
• Click Unhide
• Choose the worksheet to unhide

Bookmark it:

Popularity: 11% [?]

Set Print Titles
The print titles function allows you to repeat the column and row headings at the beginning of each new page to make reading a multiple page sheet easier to read when printed. To Print Titles:

• Click the Page Layout tab on the Ribbon
• Click the Print Titles button
• In the Print Titles section, click the box to select the rows/columns to be repeated
• Select the row or column
• Click the Select Row/Column Button
• Click OK

Create a Header or Footer
To create a header or footer:

• Click the Header & Footer button on the Insert tab
• This will display the Header & Footer Design Tools Tab
• To switch between the Header and Footer, click the Go to Header or Go to Footer button

• To insert text, enter the text in the header or footer
• To enter preprogrammed data such as page numbers, date, time, file name or sheet name, click the appropriate button
• To change the location of data, click the desired cell

Set Page Margins
To set the page margins:

• Click the Margins button on the Page Layout tab
• Select one of the give choices, or

• Click Custom Margins
• Complete the boxes to set margins
• Click Ok

Change Page Orientation
To change the page orientation from portrait to landscape:

• Click the Orientation button on the Page Layout tab
• Choose Portrait or Landscape

Set Page Breaks
You can manually set up page breaks in a worksheet for ease of reading when the sheet is printed. To set a page break:

• Click the Breaks button on the Page Layout tab
• Click Insert Page Break

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

Bookmark it:

Popularity: 13% [?]