Topic 10: proper settings involves to Print the Worksheet

[seema]

Excel Printing - Page Settings

The options that can change here includes the paper orientation, set the page scale and size, and print quality.

To change Page Setup options

From the File menu, click Page Setup. From the Page Setup dialog box displayed, click on the Page tab.

Similar Threads:

• Proper SEO Keyword Research
• The Proper Mindset of an Online Business Owner
• Objective settings
• Climbing Google Through Proper Article Marketing
• Carry child proper way

[seema]

To set the printing paper orientation

In the Orientation section, select Portrait or Landscape by clicking the option ****on. To set the scale of the page In the Scaling section, choose the Adjust to: option ****on and enter a percentage to scale (in conjunction with normal size) in the Adjust to spin box. Choose the Fit to: option and enter the dimensions of the pages in the wide and tall spin boxes. To set other printing options Paper size In the Paper size: drop-down list box, select the size you require. Print quality In the Print quality: drop-down list box, choose the quality you require (higher dpi – better quality). Page numbering To begin page numbering with a different number, select the First page number: text box and enter the number you want to use.

[seema]

Excel Printing - Margins Settings

Proper Microsoft Excel printing that involves margins is to set the top, bottom, left and right margins of the page. You also can choose to center the data of a page.
To change the page margins

From the Page Setup dialog box displayed, select the Margins tab. Click on the Top, Bottom, Left, or Right margin spin box to change the settings. To change header and footer margins, click on the Header: or Footer: spin box. Click OK.Note: At the bottom Center on page section, you can choose Horizontally or Vertically to reflect the best position of your data in a page.

[seema]

Excel Printing - Header/Footer Settings

Proper settings of page header and footer are important as it will affect the overall look of a page in Excel printing.

To change headers and footers

From the Page Setup dialog box displayed, select the Header/Footer tab. Click on the down arrow to the right of the Header: list box to reveal a list of available headers. Click on the header required to select it. Click on the Custom Header or Custom Footer ****on to display the Header (or Footer) dialog box.

In the Left section: box, enter any data you want to appear at the left margin of the header or footer. In the Center section: box, enter any data you want to appear at the center of the header or footer. In the Right section: box, enter any data you want to appear at the right margin of the header or footer.

[seema]

You also offered the following options: Format font Click this ****on after highlighting the text to change the font, size, and style. Page number Insert the page number of each page. Number of pages Use this feature along with the page number to create strings such as "page 1 of 15". Date Add the current date. Time Add the current time. File path Add the file path name (location of the file) File name Add the name of the workbook file. Tab name Add the name of the worksheet’s tab. Insert picture Bring up insert picture window and you can choose a location to insert picture. Format picture Format the inserted picture. When you have finished, click on OK. Your new header (or footer) will be displayed in the Page Setup dialog box in the Header or Footer list box. Click OK to close the Page Setup dialog box.