Choosing a part of sheet for printing

[ylijohe]

I made a calendar into my sheet, but I want only that part to be printed which contains weekdays, nothing else.

I named the area to "PrintArea", but how to go further?

Area parameters are B4:H13, only this part is to be printed.

 

[Mudface]

Try selecting the cells you want to be printed then clicking on File- Print Area-Set Print Area. This will name your selected range Print_Area, check in Print Preview that it's done what you want.

 

[ylijohe]

Thnaks, I found at last also the help file which told the same:

Print a specific area of a worksheet
On the View menu, click Page Break Preview.


Select the area you want to print.


Right-click a cell within the selection, and then click Set Print Area on the shortcut menu.
Tip You can add additional cells to a print area in page break preview. If the cells you want to add are adjacent to the current print area, drag the thick blue border to include the cells. To include other cells, select the cells you want to add, right-click a cell in the selection, and then click Add to Print Area on the shortcut menu.