Setup

Change worksheet margins: top, bottom, left, right.

In order to change the worksheet margins, click on the ‘Format’ button from the main menu bar. Click on ‘Page…’ button from the resulting drop-down. This gives the ‘Page Style’ dialog box. Under the ‘Page’ tab, you can make the appropriate changes to the ‘Margins’ in order to change the top, bottom, left, and right margins of a worksheet.


img0
img1
img2
img3
img4
img5
img6
img7
img8
img9
img10
img11
img12
img13
img14
img15
img16
img17

Margins

Change worksheet orientation: portrait, landscape. Change paper size.

In the same dialog box, under the ‘Page’ tab, the ‘Paper Format’ options can be selected to make changes to the paper size and worksheet orientation.

Paper Format

Adjust page setup to fit worksheet contents on a specified number of pages.

In the same dialog box, under the ‘Sheet’ tab, the ‘Scale’ options can be altered to fit the worksheet contents on a specified number of pages. When ‘Scaling mode:’ is selected as ‘Fit print range(s) on number of pages’, then the worksheet contents will be printed on a specific number of pages as selected in the ‘Number of Pages:’ option.

Page Scale

Add, edit, and delete text in headers, footers in a worksheet.

In the same dialog box, under the ‘Header’ or the ‘Footer’ tab, you will find the ‘Edit’ button. Click on this button and a new dialog box will appear. This dialog box provides the options for entering contents in the header or footer of a worksheet.

Header

Header Style

Insert and delete fields: page numbering information, date, time, file name, worksheet name into headers, footers.

In the same dialog box, which was displayed after clicking on the ‘Edit’ button, the different options for inserting fields like date, time, worksheet name and page numbers are present. In the ‘Custom Headers’ section, there are different icons for adding text, sheet name, date, time and page numbering information to the headers and the footers.

Custom Head



Comments

Prepare Outputs — 8 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *