4.2.3 Printing of Spread Sheet

Excel offers you various printing options for your worksheets. It enables you to have a preview of worksheet data with the aid of the Print preview option. You can set margins, fonts, headers and footers to enhance you worksheets.

Printing an Area
By default, Excel prints the current worksheet when the Print command is selected from the file menu. However, if you require a particular area of the worksheet to be printed, then you are offered this facility also. To dos, you can follow these steps:

  • Select the range that you want to print.
  • Select the print option from the file menu.
  • The print dialog box gets invoked as shown in figure below.
  • In the Print what section of the dialog box, choose the selection option.
  • Select the OK option to complete the procedure.

Defining and Deleting a Print Area
There may besituations where you need to print the same range repeatedly. To avoid the tedium of specifying the same range for printing several times, you can conveniently define ranges as the print area.

  • Select the area you want to specify.
  • Select the Print area option from the file menu.
  • Select the Set print area from the Print area submenu as shown in the figure below.
  • Select the Print option from the file menu.
  • Click on the OK button.
  • You can select Clear Print area when you want to remove the defined Print Area.

To print worksheets, the steps area:

  • Select the Print option from the file menu. This invokes the print dialog box.
  • This dialog box is very similar as you used in the Ms-Word Print dialog box. The only difference is the three extra button which are given below:

Selection–prints selected cells:
Active sheet(s)–prints only selected worksheets.
Entire workbook–prints open workbook.

Printing Worksheets:
Worksheets can be very conveniently printed by the use of the Print command that sends your worksheet pages to the printer immediately.

Device Options:
Controls the print quality and allows you to adjust printer memory tracking (this affects how the driver tracks printer memory usage).