Worksheet Layout and Print Setup एक्सेल में प्रिंट लेआउट कैसे सेटअप करें

 Page set -up within worksheet Formatting and Printing worksheet :- As with other Windows programs, Excel also provides you with the feature of WYSIWYG (What You see is what get).Therefore it is always better to start with the page layout which you want as a printer copy also .for this :-

1. Open the File menu by clicking on the File .

2. Click on the Page Set -up.

The following dialogue box is displayed .

The Page option allows you to set the paper size , orientation of the data ,scaling of the area etc. Excel inserts automatic page -breaks also .

The Margins tab, when clicked , displays the displays the dialogue box. You can set the top ,bottom ,left and right margins of the page . These are the distances in inches from the edge of page . This also allows you to see the preview of the data when it will be printed .

Header / Footer tab gives you option to set the header ( which will be displayed on top of every page ) and the footer ( which will be displayed at the bottom of every page ) The header may include the name of the organization or date or any other thing you wish to write .The footer may include the page number or a line or something you wish to write .To add more data as header or footer , click on Custom Header .. or Custom Footer ..

The Sheet tab has the option to select the area to be printed (i . e . the range of cells ) , set the row  or column titles ( there will be printed on every page ), or select the page order from the multiple worksheet etc.