How do I set up my page in Microsoft Excel?

First, you need to create a new file in Microsoft Excel. To do this, go to File and then click on New. Now select Blank workbook and click on OK. Next, you need to set up your page for the content that you are about to enter. To do this, go to View and then select Page Layout. You can now change the orientation of the page by clicking on Landscape or Portrait mode at the bottom of the screen.

Course Content

Menu in Excel

4m 57s

How to use LearnVern

3m 20s

Quick Access Toolbar

6m 21s

Formula Bar in Excel

2m 5s

Status Bar in MS Excel

5m 23s

Navigation in MS Excel

3m 4s

Shortcuts in MS Excel

4m 15s

Format Painter in MS Excel

2m 29s

Excel Getting Started Quiz

Data Entry in MS Excel

5m 9s

Autofill in MS Excel

5m 42s

Data Entry for Date-Time in MS Excel

5m 46s

Undo-Redo in MS Excel

5m 32s

Comments in MS Excel

4m 1s

Saving File in MS Excel

4m 27s

Excel Data Entry Quiz

Creating Formula in MS Excel

7m 45s

Copy Formula in Excel

3m 35s

Till Date Formula in MS Excel

3m 36s

Pct Calculation in MS Excel

5m 20s

Absolute in MS Excel

6m 10s

Sum Average in MS Excel

6m 5s

Other Common Functions In MS Excel

7m 52s

Excel Creating Formulas Quiz

Formatting Fonts in MS Excel

3m 49s

Adjusting Rows & Columns in MS Excel

4m 2s

Alignment in MS Excel

7m 10s

Formatting Borders in MS Excel

2m 55s

Formatting Numbers in MS Excel

7m 23s

Formatting Date-Time in MS Excel

10m 47s

Conditional Formating in MS Excel

10m 38s

Formatting Tables in MS Excel

8m 43s

Formatting Shapes in MS Excel

7m 5s

Excel Formating Quiz

Resizing Row & Column in MS Excel

7m 18s

Hide-Unhide Row and Column in MS Excel

5m 29s

Copy, Move, Insert Data in MS Excel

5m 37s

Find Replace in MS Excel

6m 35s

Excel Adjusting Layout Quiz

Printing in MS Excel

6m 35s

Page Break Preview in MS Excel

5m 20s

Page Setup in MS Excel

4m 58s

Excel Print Quiz

Creating Charts in MS Excel

7m 13s

Types of Chart in MS Excel

5m 40s

Formatting Charts in MS Excel

6m 36s

Chart Elements in MS Excel

7m 44s

Sparklines in MS Excel

8m 1s

Excel Charts Quiz

Freezing Workbook in MS Excel

7m 28s

Splitting Sheets in MS Excel

6m 39s

Outline in MS Excel

7m 3s

Excel Adjusting Workbook Quiz

Manage Multiple Workbook in MS Excel

6m 48s

Working with Sheets in MS Excel

4m 42s

Copy & Delete Sheets in MS Excel

6m 36s

Use of Formula in Worksheet

9m 22s

Edit Links in MS Excel

10m 43s

Excel Multiple work books Quiz

If Condition in MS Excel

6m 26s

VLOOKUP in MS Excel

6m 2s

VLOOKUP Exact in MS Excel

4m 10s

COUNTIF in MS Excel

4m 25s

Excel If condition VLOOKUP Quiz

Protecting Sheets in MS Excel

4m 55s

Securing Workbook in MS Excel

5m 45s

Password to Workbook in MS Excel

2m 21s

Sharing Workbook in MS Excel

3m 10s

Track Changes in MS Excel

5m 33s

Excel Protecting sheets Quiz

Sorting in MS Excel

6m 38s

Subtotals in MS Excel

7m 26s

Filter in MS Excel

5m 32s

Split Data in MS Excel

4m 21s

Flash Fill in MS Excel

3m 41s

Remove Duplicate in MS Excel

2m 33s

Data Validation in MS Excel

6m 50s

Excel Data Management Quiz

Creating Pivot Table in MS Excel

11m 11s

Manipulating Pivot Table in MS Excel

8m 29s

Adding Slicers in MS Excel

4m 36s

Other Grouping of Pivot Table in MS Excel

4m 40s

Excel Pivot Table Quiz

Macro in MS Excel

7m 29s

Excel Macros Quiz

Excel Assignment Q-1

1m 11s

Excel Assignment Q-2

21s

Excel Assignment Q-3

34s

Excel Assignment Q-4

51s

Excel Assignment Q-5

48s

Excel Assignment Q-6

37s

Excel Assignment Q-7

47s

Excel Assignment Q-8

45s

Excel Assignment Q-9

37s

Excel Assignment Q-10

33s

Master Quiz

50m

Page Setup in MS Excel

MS Excel Course Print

Enroll Now For Free

Discussion

Course Content

Menu in Excel

4m 57s

How to use LearnVern

3m 20s

Quick Access Toolbar

6m 21s

Formula Bar in Excel

2m 5s

Status Bar in MS Excel

5m 23s

Navigation in MS Excel

3m 4s

Shortcuts in MS Excel

4m 15s

Format Painter in MS Excel

2m 29s

Data Entry in MS Excel

5m 9s

Autofill in MS Excel

5m 42s

Data Entry for Date-Time in MS Excel

5m 46s

Undo-Redo in MS Excel

5m 32s

Comments in MS Excel

4m 1s

Saving File in MS Excel

4m 27s

Creating Formula in MS Excel

7m 45s

Copy Formula in Excel

3m 35s

Till Date Formula in MS Excel

3m 36s

Pct Calculation in MS Excel

5m 20s

Absolute in MS Excel

6m 10s

Sum Average in MS Excel

6m 5s

Other Common Functions In MS Excel

7m 52s

Formatting Fonts in MS Excel

3m 49s

Adjusting Rows & Columns in MS Excel

4m 2s

Alignment in MS Excel

7m 10s

Formatting Borders in MS Excel

2m 55s

Formatting Numbers in MS Excel

7m 23s

Formatting Date-Time in MS Excel

10m 47s

Conditional Formating in MS Excel

10m 38s

Formatting Tables in MS Excel

8m 43s

Formatting Shapes in MS Excel

7m 5s

Resizing Row & Column in MS Excel

7m 18s

Hide-Unhide Row and Column in MS Excel

5m 29s

Copy, Move, Insert Data in MS Excel

5m 37s

Find Replace in MS Excel

6m 35s

Printing in MS Excel

6m 35s

Page Break Preview in MS Excel

5m 20s

Page Setup in MS Excel

4m 58s

Creating Charts in MS Excel

7m 13s

Types of Chart in MS Excel

5m 40s

Formatting Charts in MS Excel

6m 36s

Chart Elements in MS Excel

7m 44s

Sparklines in MS Excel

8m 1s

Freezing Workbook in MS Excel

7m 28s

Splitting Sheets in MS Excel

6m 39s

Outline in MS Excel

7m 3s

Manage Multiple Workbook in MS Excel

6m 48s

Working with Sheets in MS Excel

4m 42s

Copy & Delete Sheets in MS Excel

6m 36s

Use of Formula in Worksheet

9m 22s

Edit Links in MS Excel

10m 43s

If Condition in MS Excel

6m 26s

VLOOKUP in MS Excel

6m 2s

VLOOKUP Exact in MS Excel

4m 10s

COUNTIF in MS Excel

4m 25s

Protecting Sheets in MS Excel

4m 55s

Securing Workbook in MS Excel

5m 45s

Password to Workbook in MS Excel

2m 21s

Sharing Workbook in MS Excel

3m 10s

Track Changes in MS Excel

5m 33s

Sorting in MS Excel

6m 38s

Subtotals in MS Excel

7m 26s

Filter in MS Excel

5m 32s

Split Data in MS Excel

4m 21s

Flash Fill in MS Excel

3m 41s

Remove Duplicate in MS Excel

2m 33s

Data Validation in MS Excel

6m 50s

Creating Pivot Table in MS Excel

11m 11s

Manipulating Pivot Table in MS Excel

8m 29s

Adding Slicers in MS Excel

4m 36s

Other Grouping of Pivot Table in MS Excel

4m 40s

Macro in MS Excel

7m 29s

Excel Assignment Q-1

1m 11s

Excel Assignment Q-2

21s

Excel Assignment Q-3

34s

Excel Assignment Q-4

51s

Excel Assignment Q-5

48s

Excel Assignment Q-6

37s

Excel Assignment Q-7

47s

Excel Assignment Q-8

45s

Excel Assignment Q-9

37s

Excel Assignment Q-10

33s

Page Setup in MS Excel

How to change the page margins too wide

Whenever we are going to print any Excel sheet we always take care about page layout, and before printing we always see print preview.

Before printing any Excel sheet we always check Page setup, i.e. Orientation of the excel sheet, size of the page, print area, etc...

This all options are also available when we are viewing print preview, even if we want to set the margin of our page then we can click page setup button, and then pop up will be displayed showing all print options.

So by using Page setup's 'Margin' option, we can set the margin according to our size requirement.

Also we can use header and footer option from Page setup which will show us what to display in centre section or left or right section of header and footer.

FAQs

First, you need to create a new file in Microsoft Excel. To do this, go to File and then click on New. Now select Blank workbook and click on OK.
Next, you need to set up your page for the content that you are about to enter. To do this, go to View and then select Page Layout. You can now change the orientation of the page by clicking on Landscape or Portrait mode at the bottom of the screen.

The first benefit to using a page setup is that it allows you to automatically format your spreadsheet according to the user's preferences. This can make it much easier for the user to find what they are looking for and make their work more organized. The second benefit is that it allows you to save time by not having to manually apply formatting throughout your spreadsheet each time you want something formatted differently.