Print options

Dear Friends, it’s been a year since I have been communicating to all of you by way of this article. In today’s article instead of covering a particular feature I have covered various printing options available in excel and how to use them in our day-to-day activities.

Setting up the page
To
From the File menu, choose page setup and then
Set Margin

Select the Margins tab. In the Top, Bottom, Left, Right, Header and Footer boxes, enter the measure of margins you want.
Set Alignment on the page
Select the Margins tab. Under Center On Page, select the option you want.
Add or edit headers and footers
Select the Header/Footer tab and select the text you want.
Portrait or Landscape
Select the page tab. Under orientation you can select the required option as portrait or landscape.


Choosing What to print
To
From the File menu, choose page setup and then
Specify a worksheet range to print
Select the Sheet tab. In the Print Area box, enter the range to print.
Repeat print of rows or columns on all pages
Select the Sheet tab. Under Print titles, enter the row or column ranges that you want to be printed as titles on all the pages.
Control whether gridlines, cell notes or row/column headings are printed
Select the Sheet tab. Under Print, select the check boxes for the items you want to print.


Previewing what will print
To
Do this
Preview the print
Click the print preview toolbar button or while in the page setup dialog box you can choose the print preview button.


Fitting your work to the page
To
From the File menu, choose page setup and then
Enlarge or reduce your printed data
Select the Page tab. Select the Adjust To option button, and then type or select the scaling percentage you want.
Reduce your data so that it fits on the number of pages you specify
Select the Page tab. Select the Fit To option button, and then type or select the number of pages you want.




Controlling page breaks, page numbers and print order
To
Do this
Display page breaks on screen
Tools >> Options >> View >> Select the page break check Box.
Set manual page breaks (vertical and horizontal)
Select the cell where you want to start a new page and choose page break from insert menu.
Set a page print order
File > Page Setup >> Sheet (Tab). Under the page order, select the printing order.
Beginning numbering pages at a specified page number
File >> Page Setup >> Page (Tab). In the First Page Number box, type the starting page number you want.