5-4 using the sheet tab

8/3/2019 5-4 Using the Sheet Tab

1/12

5-4 Using the Sheet Tab

The last Tab in the Page Setup DialogBox is the Sheet Tab. On this Tab, you canset the rows to repeat at the top and thecolumns to repeat at the left of every page

of the worksheet. You can apply the printoptions: gridlines, rows and columns heading,draft quality, black and white.To Print Row or Column Titles

The common practice is copying andpasting the column and row titles on every page.Excel provides a more efficient way to do thisthrough the Print Titles Option under the Sheet Tab.


2/12

1. On the File Menu, choose Page Setup.

2. Click the Sheet Tab.

3. Specify which row(s) and column(s) should appear atthe top and/ or left of every page in the appropriateboxes under the Title Section.

To Print GridlinesThe worksheet gridlines show where each cell

ends and the next one begins.

1. In the File Menu, click Page Setup.

2. Select Sheet Tab.

3. Add or remove the check mark in the Gridline CheckBox.


3/12

To Print Row and Column Headings1. On the File Menu, choose Page Setup.2. Click the Sheet Tab.

3. Under Print, make check mark in the Row andColumn Headings Check Box.

To Print In Black and White1. On the File Menu, choose Page Setup.

2. Click the Sheet Tab.3. Under Print, make a check mark in the Black and

White Check Box.


4/12

To Specify Draft Quality Printing1.

On the File Menu, choose Page Setup.2. Click the Sheet Tab.

3. Under Print, make a check mark in the Draft QualityCheck Box.

To Set the Order of the Pages1. On the File Menu, choose Page Setup.

2. Click the Sheet Tab.3. Under Page Order, choose either Down, Then Over

(from top to bottom) or Over Then Down (from leftto right).


5/12

5-5 Setting the Print Area & Page

Breaks

To Print Selected Cells or Cell Ranges1. Select the cell/ cell range that you want to print.

2. Do one of the following:

In the File Menu, point to Print Area, then click SetPrint Area from the Menu.

In the View Menu, click Page Break Preview. Select

a cell or range. Right-click and choose Set Print

Area from the Shortcut Menu.

In the File Menu, click Print. Select a cell or range.

In Print What, choose Selection option.


6/12

To Add a Print Area1. Make sure that you have already set a print area on

the selected cell or range.2. In the View Menu, select Page Break Preview. Selectthe cell or range.

3. Right-click this, and then choose Add to Print Area.

To Clear a Print AreaDo one of the following: In the File Menu, point to Print Area, then selectClear Print Area.

On the View Menu, click Page Break Preview.

Select the printed area or cell range. Right-click and choose Reset Print Area from ShortcutMenu.


7/12

Page Breaks

There are two types of page breaks:Manual and Automatic. Automatic Page Break isautomatically set by Microsoft Excel appearingas dashed lines. Manual Page Breaks are set bythe user. It appears as solid lines.

To Adjust Page Breaks1. In the View Menu, click Page Break

Preview.

2. Drag the Page Break Indicator Line towhere you want the page break to occur.

3. In the View Menu, select Normal whenyoure already finished.


8/12

To Insert Page Breaks Move the insertion point above or to the left of

where the automatic Page Break is any locationwhere you want to insert page break.

In the Insert Menu, choose Page Break.

5-6 Previewing and PrintingWorksheets

After you setup your worksheet, you may

need to view the worksheet before printing it.Switch to Print Preview to check the setup andto make direct adjustments.


9/12

To Preview a WorksheetDo one of the following:

Click Print Preview Button on the Standard

Toolbar.

In the File Menu, click Print Preview.

To Preview a Web PageIn the File Menu, click Web Page Preview.

This action prompts the Internet Explorerappear.


10/12

To Print a Workbook1. Do one of the following:

On the File Menu, click Print.

Press CTRL+P.

2. The Print Dialog Box appears.

3. In the Print what Option, click Entire Workbook.

4. In the Copies Area, click the increment buttonsto enter the number of copies to be printed.

5. In the Print Range Area, click the desired option:

All prints all pages

Pages enter the first and last pages to beprinted inside the From and To Boxes.

6. Click OK.


11/12

To Print a Worksheet1. Click the worksheet to be printed on the Sheet

Tab.2. Do one of the following:

On the File Menu, click Print

Press CTRL+P

Click the Print Button

3. The Print Dialog Box appears.

4. In Print what Options, click Active Sheet(s).

5. In Print Range Area, click the desired option.6. In the Copies Area, click the Increment Buttons

to enter the number of copies to be printed.

7. Click OK.


12/12

To Print a Selection1. Select a range.2. On the File Menu, click Print.

3. On the Print What, choose Selection.

4. Click OK.

5-4 using the sheet tab

Documents