New Posts
Home / Computer 4 Beginners / How to Print Worksheet.

How to Print Worksheet.

How to Print Worksheet.

In this lesson, we will learn how to print worksheet. Where I have discussed topics like Print preview, Workbook views, Orientation, Changing page size, Printing the highlight data, Print Tiles, Previewing page breaks, Working with Page Setup and printing controls and much more.

Print-Worksheet

Exploring the Page Layout tab and Page Layout view.

If you are about to print worksheet. Before print worksheet, it is the best way that you have to use print preview first.

When you will click on Page Layout Tab.

See all features related to Print worksheet. But note down there is no command of Print Preview.

print commands

Print preview command is located inside print command. Which can use from File.

Print as shown below image.

print preview

Print preview shortcut key.

print preview shortcut

Use following options exit from print preview.

 exit form print preview

This command can also be used from quick access toolbar.

quick access tool bar

The 3rd way of using this option is from:

File.

Print.

Workbook views.

 normal page layout page break

Normal (Normal is used mostly.)

 Normal

Page Layout

 page layout

Page Beak Preview.

 Page Beak Preview
Orientation.

Give your pages a portrait or landscape layout.

Think Portrait as Vertical and Landscape as Horizontal.

 Orientation

Changing page size:

Choose a paper size for your document.

Changing page size

When you click on size number of choices will be displayed, select one them according to your need.

Mostly two types of papers are used everywhere.

Letter: it has width 8.5 inches and height 11.

Legal: it has width 8.5 inches and height 14.

 page setup

Printing the highlight data.

 Printing the highlight data

Print Tiles.

 Working with Page Setup and printing controls

 Printing the highlight data 2

 

Previewing page breaks

Another approach to printing is to begin that is called page break preview.

It is located on the lower left-hand corner of the status bar.

 Previewing page breaks

 Previewing page breaks 2

If we do not want to print particular area.

 Previewing page breaks 3

 Previewing page breaks 4

 Previewing page breaks 5

 Previewing page breaks 6

Working with Page Setup and printing controls.

When you about to print the worksheet. Page layout is the obvious of our menu tab have to go first to control the features. If you want to consider to add print titles.

From Page layout.

Print tiles

After clicking on print titles, you notice that a dialog box will be displayed

 Working with Page Setup and printing controls 2

Page Layout

 Working with Page Setup and printing controls 3

Working with Page Setup and printing controls 4

Working with Page Setup and printing controls 5

 exit form print preview

 print preview

 custom margins

 margins

 scaling

print

 header and footer

header

 header options

sheet

 

 

 

 

 

About imran

My Name Mohammad Ramzan Bhutto. Live in District Jacobabad, Sindh, Pakistan. I have started blogging on Information Technology, my selected areas are Online Business, Digital Marketing, Make Money Online.

Check Also

Microsoft Excel Data Analysis Tools

Microsoft Excel Data Analysis Tools

Learning Microsoft Excel Data Analysis Tools. This article illustrates the Microsoft Excel Data Analysis Tools. …