Printing a worksheet in Excel

Printing a document is a routine task performed by almost everyone, who works with MS Excel.

The printing of documents has the same set of procedures irrespective of the type of application used, either Word, Powerpoint or Excel.

However, since Excel documents are tabular, there rises a need to accommodate the whole data(columns) in a single page within the print range.

This is where the Excel document printing differs from the rest.

With large number of rows, it can be printed in multiple pages, whereas, the columns cannot be splitted in most cases.

So, This chapter aims to provide some details on various printing methods followed in Excel.

To print, Goto File menu and Click 'Print' or use the shortcut Ctrl+P.

The follwing window appears.

excel printing a worksheet

As seen above, there are various options to be given by the user for printing in desired format.

They are explained below:

Copies

This specifies the number of copies to be printed.

Printer

This specifies the available printers to be used.

There might be more than one printer connected.This option enables the user to choose one.

The Settings section is where the excel behaves differently.

There are three options to print a sheet as explained below:

excel printing a worksheet

1.Print Active Sheets

This prints the entire usedrange of the active sheet.

2.Print Entire Workbook

This prints all the sheets in the workbook.

3.Print Selection

This is most commonly used option.

This prints only the selected or highlighted data from the worksheet.

Suppose a worksheet contains a large number of data, but the user wants only first few rows and columns, then this option is used.

Apart from these, the scaling settings also assists the user to select the printable area of the page.

 

You can find similar Excel Questions and Answer hereunder

1) How can I hide all comments in my WorkSheet using VBA?

2) How can I identify all cells with Data Validation in my WorkSheet?

3) How can I copy and rename a WorkSheet using VBA?

4) How can worksheet functions be accessed in VBA?

5) How can I identify the cells that are dependent on a particular cell?

6) How do I add a shape using VBA?

7) How can I insert a watermark in my Worksheet?

8) How can I hide a specific Shape in my WorkSheet?

9) What are worksheets events in VBA. Here we explain some of the main one like like activate or deactivate

10) What are the various functions of the worksheet in Excel VBA

 

Here the previous and next chapter