Latest Updates:
Welcome To E-MAX COMPUTER EDUCATION PURNEA BRANCH (EMAX/EK13409) (India's Number 1 Computer Education)


PAGE LAYOUT (EXCEL)

PAGE LAYOUT


Theme: This option is used to change the overall design of selected worksheet such as (font style, color, etc.)

Margin: this option is used to change default page margin with help of (Left, Right, Top, Bottom) direction and also used to change default margin space for header and footer.



Orientation: this option is used to change default orientation of Microsoft excel and Ms-Excel contain "Portrait" as default orientation, every Microsoft office contain two orientation types, which are described below.
1. Portrait: this orientation type is used to print content in horizontal format (Left to right) in printouts.
2. Landscape: this orientation type is used to print content in vertical format (Top to bottom) in printouts.

Size: This option is used to change default page size of Microsoft Excel and by default Microsoft excel page set in "Letter" page size.

Print Area: This tool is used print only selected data items with help of "Set Print Area" sub-option and its second sub-option (Clear Print Area) is used to delete an already existing Print Area.

Break: This Tool is used break an excel worksheet in four pages by selected cell.
All sub option of "Break" tool, is described below.  
1. Insert Page Break: this suboption is used to break page from the selected cell.
2. Remove Page Break: this suboption is used to remove selected page break.
3. Reset All Page Breaks: this suboption is used to remove all existing page break. 

Background: This option is used to set any selected image file in the background of Microsoft Excel's worksheet.

Print Titles: This option is used to insert header and footer, change default page margins, change page orientation and to perform other tasks. 

Width: This option is used to shrink the width of printed output to fit a maximum number of selected pages. 

Height: This option is used to shrink the height of printed output to fit a maximum number of selected pages.

Scale: This option is used to stretch or shrink the printed output to a percentage of its actual size and the maximum width and height must be set to "Automatic" for normal size printouts. 

Gridlines: This option is used to show and hide the grid lines in the current worksheet as well as also used to print grid lines in printouts by "Print" option.

Headings: This option is used to show and hide Columns and Rows heading as well as also used to print Columns and Rows headings.



No comments:

Post a Comment