PRESENTATION ON:

Presented By:Saransh Arora

MS EXCEL-PAGE LAYOUT

Microsoft Excel - Page Layout Tab

INTRODUCTION

Many of the commands you'll use to prepare your workbook for printing and PDF export can be found on the Page Layout tab. These

commands let you control the way your content will appear on a printed page,

including the page orientation and margin size. Other page layout options, such

as print titles and page breaks, can help make your workbook easier to read

GROUPS

• Themes Group• Page Setup Group• Scale to Fit Group• Sheet Options Group• Arrange Group

PAGE LAYOUT VIEW

Before you start modifying a workbook's page layout, you may want to view the workbook in Page Layout view, which can help you visualize your changes.To access Page Layout view, locate and select the Page Layout view command in the bottom-right corner of your workbook.

Themes - Change the overall design of the entire document, including colors, fonts, and effects.

Colors - Change the colors for the current theme.

Fonts - Change the fonts for the current theme.

Effects - Change the effects for the current theme.

THEMES

Margins - Select the margin sizes for the entire document or the current selection.

Orientation - Switch the pages between portrait and landscape layouts.

Size - Choose a paper size for the current section. To apply a specific paper size to all sections of the document, click on More Paper Sizes .

PAGE SETUP

Print Area - Mark a specific area of the sheet for printing.

Breaks - Specify where a new page will begin in the printed copy. Page breaks are inserted above and to the left of the selection.

Background - Choose an image to display as the background of a sheet.

Print Titles - Specify rows and columns to repeat on each printed page.

SCALE TO FIT

Width - Shrink the width of printed output to fit a maximum number of pages

Height - Shrink the height of printed output to fit a maximum number of pages.

Scale - Stretch or shrink the printed output to a percentage of its actual size. The maximum width and height must be set to "Automatic" to use this feature.

SHEET OPTIONS

Gridlines - Show, or hide, the lines between rows and columns in the sheet. Showing makes numbers in columns or rows easier to read or edit. Hiding gridlines is useful if you are making a graphic organizer in Excel. These lines will not print unless the Print box is checked.

SHEET OPTIONS

Headings - Show row and column headings. Row headings are the row numbers on the side of the sheet that range from 1 to 1,048,576. Column headings are the letters that appear above the columns on a sheet that range from A to XFD. This is also found on the View tab of an Excel Workbook.

ARRANGE

Bring to Front - Bring the selected object in front of all other objects so that no part of it is hidden behind another object.

Send to Back - Click here to send the selected object back one level or to the back of all objects.

Selection Pane - Show the Selection Pane to help select individual objects and to change their order and visibility.

ARRANGE

Align - Align the edges of multiple selected objects. You can also center the objects or distribute them evenly across the page.

Group - Group objects together so that they can be treated like a single object.

Rotate - Rotate or flip the selected object.

QUESTIONS • Q1. WHAT IS THE SHORTCUT FOR PRINT?

• Q2. WHAT IS THE USE OF PAGE ORIENTATION?

• Q3. WHAT HAPPENS WHEN YOU SELECT BACKGROUND?

• Q4. MOST USED TYPE OF PAGE SIZES.

• Q5. WHERE IS HEADER AND FOOTER?

ANSWERS• Ctrl+P

• USED DURING PRINT(PORTRAIT AND LANDSCAPE VIEW)

• THE PICTURE YOU SELECT COME BEHIND YOUR DATA WHICH MAKES IT LOOK ATTRACTIVE

• LETTER,A4 AND LEDGER• HEADER IS ON THE TOP AND FOOTER IS AT THE END

OF SLIDE

THANK YOU