Change page orientation is very important operation
before you print out any document . As you wanted to print out any document
,you must check position of the page
orientation. If you haven't idea about that, you could loose so many paper.
1. first click to page layout menu
2. choose the orientation
3. after you choose orientation you can find two option
4.Page Landscape and other Portrait
Step -1
How to Setup the page Margins :
Print margins indicate how much white space Excel places between the worksheet data and the edge of the page. The Normal margin settings that Excel applies to a new workbook use top and bottom margins of 0.75 inches and left and right margins of 0.7 inches. You also can specify margins
You also can manually adjust the margins of a report either from the Margins tab of the Page Setup dialog box or by dragging the margin markers in the Print Preview window. To get more columns on a page, try reducing the left and right margins. To get more rows on a page, try reducing the top and bottom margins.
Follow these steps to adjust margins using the Page Setup dialog box:
- On the Page Layout tab, click the Custom Margins command on the Margins drop-down menu or click the Page Setup dialog box launcher.
- The Page Setup dialog box appears.
- Click the Margins tab.
q Enter
the new margin settings in the Top, Bottom, Left, and Right text boxes.
q You
also can use the spin buttons to change the margin settings in small
increments.
q (Optional)
Select one or both Center on Page check boxes to center the data between the
current margin settings.
q Click
OK.
You can click the Print Preview
button in the Page Setup dialog box at any time to see how the changes you make
affect the preview of your report.
If you select the Show Margins
check box on the Print Preview tab in the Print Preview window, you can modify
the margins. To change one of the margins, position the mouse pointer on the
desired margin marker (the pointer shape changes to a double-headed arrow) and
drag the marker in the appropriate direction. When you release the mouse button,
Excel redraws the page, using the new margin setting.
Header and Footer :
Working with header and footer in Excel from Office has gotten much
simpler and more sophisticated with varied options. Lets see all the features
of header and footer . If you are new to the feature of Headers and Footers,
they are the information displayed on the top and bottom of page when an Excel
sheet is printed. This allows to display any titles or page numbers when they
are printed.
Go to Insert tab and click Header & Footer
under Text.
Now the layout of the sheet maybe changed to Page Layout
from Normal spreadsheet layout.
Now there are three sections of header and footer,
left, center and right. Click on each section and begin typing the details that
you want to appear on the header.
Print Area :
If you print a specific selection on the worksheet frequently, you can define a print area that includes just that selection. When you print the worksheet after defining a print area, only the print area will print. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet again.
