The Page Layout Tab in Microsoft Excel is used to control how a worksheet looks on the screen and how it will appear when printed or exported as a PDF.
It provides options for setting margins, page orientation, paper size, print area, page breaks, scaling, themes, backgrounds, and print titles.
Page Layout is especially important when creating professional:
The Page Layout Tab contains several important groups.
| Group | Main Options |
|---|---|
| Themes | Themes, Colors, Fonts, Effects |
| Page Setup | Margins, Orientation, Size, Print Area, Breaks, Background, Print Titles |
| Scale to Fit | Width, Height, Scale |
| Sheet Options | Gridlines, Headings |
| Arrange | Position, Bring Forward, Send Backward, Align, Group, Rotate |
A Theme is a predefined combination of fonts, colors, and effects that gives a consistent appearance to a workbook.
You can also customize:
Themes help maintain a consistent and professional design throughout the workbook.
Margins control the amount of blank space around the printed content.
Excel generally provides:
For more control, choose Custom Margins.
You can set:
For a professional report, you may use standard margins so that text does not appear too close to the edge of the paper.
Page orientation determines whether the worksheet is printed vertically or horizontally.
Portrait
Landscape
Page Layout → Orientation → Portrait/Landscape
A marksheet containing many subject columns is usually easier to print in Landscape orientation.
Paper Size determines the physical size of the printed page.
Common options include:
For many office documents in India, A4 is commonly used.
The Print Area specifies which part of the worksheet should be printed.
Suppose a worksheet contains data in A1:K100, but you only want to print A1:F30.
You can set A1:F30 as the Print Area.
To remove the selected print area:
Page Layout → Print Area → Clear Print Area
A Page Break determines where Excel starts a new printed page.
This is useful when a large worksheet needs to be divided into multiple pages.
A 100-row student report can be divided into separate pages using appropriate page breaks.
Page Break Preview helps you see how the worksheet will be divided across printed pages.
You can access it from:
View → Page Break Preview
It allows you to adjust page boundaries before printing.
The Scale to Fit section helps adjust the worksheet so that it fits properly on printed pages.
It includes:
If a worksheet is too wide and prints across four pages, you can set:
Width → 1 Page
This can make the columns fit across one page.
Reducing the scale too much can make text difficult to read. Always check Print Preview before printing.
Print Titles allows selected rows or columns to repeat on every printed page.
Suppose a report has headings:
| Roll No. | Name | Course | Marks |
|---|
If the report continues for several pages, you can repeat the heading row on every page.
Repeated headings make multi-page reports easier to understand.
Excel allows you to add a background image to a worksheet in versions that support this feature.
A worksheet background is primarily a screen display feature and does not normally print like a regular page background.
Gridlines are the light lines that separate cells.
You can control whether gridlines are:
Go to:
Page Layout → Sheet Options → Gridlines
Options:
You may keep gridlines visible while working but turn off Print if you want a cleaner professional report.
Excel normally displays:
Under Sheet Options, you can control whether these headings are displayed or printed.
For professional reports, unnecessary row and column headings are often excluded from printing.
When you insert pictures, shapes, icons, or other objects, Excel provides tools to control their position.
If a picture is covering a shape, you can use:
Send Backward
to move the picture behind the shape.
When multiple objects are inserted, they can be aligned for a professional layout.
Common alignment options include:
This is useful when creating dashboards and visual reports.
Grouping allows multiple objects to behave as a single object.
Suppose a dashboard contains:
You can group them together and move them as one unit.
You can later use Ungroup to separate them.
Objects such as pictures and shapes can be rotated.
Common options include:
This can help improve the design of a worksheet.
Before printing, always check how the worksheet will appear on paper.
It helps identify:
The Page Setup dialog box provides additional control over printing.
It generally contains:
Allows you to add:
Provides options for:
Create a worksheet named:
Student Marks Report
Enter the following data:
| Roll No. | Student Name | Computer | MS Word | Excel | Total |
|---|---|---|---|---|---|
| 101 | Rahul Sharma | 82 | 78 | 85 | 245 |
| 102 | Amit Kumar | 75 | 70 | 80 | 225 |
| 103 | Neha Singh | 90 | 88 | 92 | 270 |
| 104 | Priya Verma | 68 | 72 | 75 | 215 |
| 105 | Rohit Kumar | 80 | 76 | 84 | 240 |
Perform the following tasks:
ADCA_Excel_Page_Layout.xlsx
Create a professional Student Performance Report containing at least 30 student records.
Configure the worksheet using:
Finally:
ADCA_Professional_Report.xlsx
After completing this lesson, students will be able to:
Leave a Reply