Lesson 29 - Effective Excel Printing 1

< Back to Search results

 Category: [Excel]  Demo Available 



Lesson 29 - Excel Printing-Effective Printing in Excel. Level 1 Free Training


Download the associated Workbook for this lesson

As we have stated in previous lessons, we believe the content of a Worksheet is far more important than using a great deal of formatting to pretty it up.

However, when it comes to printing a Worksheet, it is essential that you know how to produce a finished product that a reader can easily relate to. It is definitely worth spending a small amount of time on getting your printer settings correct, rather than waste time and paper trying to do it quickly. Let’s look at the printing function of Excel in more detail.

There are many different ways that you can print a Workbook. The three most common are:

  • By Going To File>Print.
  • By Selecting Ctrl + P.

If you print by selecting the printer icon, you must be aware that this option will by-pass the Print dialog box and print straight to your printer using its current print settings. Use this option only when you are sure of your print settings.

Let us now access the Print dialog box by using either the File>Print option or by selecting Ctrl + P and look at the essential functions of this dialog box in some more detail. Printer Name

In the white box next to Name, you will see the printer that your particular PC is connected to. If you can access more than one printer, selecting the downward pointing arrow to the right of the printer name will enable you to see the other printers you are connected to. If you wish to change printers to print (ie, if you are connected to both a black and white printer and a color printer, you can decide which printer you wish to use by just clicking the desired printer with your left mouse button. Status

This is telling you the status of the printer you have selected. The choices are either busy or idle. Type

This is again telling you which type of printer you are connected to as your default Where

This is identifying to you the location of your printer. If you are connected to a local printer it will display the port number of your computer. If you are connected to a network printer, it will display the location of the network printer. Find Printer

Allows you to select a printer on your network that is not listed in your dialog box. Sometimes network administrators will bar you from entering this area, but if you have access, you can select the printer you want to use, click OK to return to this menu and print the document. casino bonus på nett Properties

By pressing this button, you will be taken to a sub-menu of Properties. Let’s look at the sheet tabs within this sub-menu. After making a selection on any of these sheet tabs, click OK and your changes will be accepted.

Note:Some of the options listed here may not be available to you, you may have extra options, or the option names may be slightly different. This is entirely dependent on the printer you are connected to. Paper Paper Size

Under this heading you will see the various paper sizes available to your printer. Have a look at the paper sizes available to you by scrolling through with the horizontal scroll bar beneath the icon window. Clicking on the desired paper size will select it. You will note in this box that there is a custom icon. If you printer supports custom paper sizes, you can click this icon and specify the size you wish to use. Paper Source

This box and its downward pointing arrow to the right specify where in your particular printer your paper resides. Different printers have different paper sources, such as upper tray, manual feed or lower tray and you may wish to change your source. For instance, in most business today you will find letterhead stored in an upper tray and followers (white) paper in a lower tray, or A3 paper stored in one tray, and legal in another. Media Choice

This box and its downward pointing arrow to the right specify the type of mediums available to you. These could be in the range of standard, bond, special paper, or transparency. Note that if you select transparency, you must have a transparency in your paper tray, otherwise if you print on ordinary paper, the printer’s ink will smear and waste not only ink but paper as well. About

This will tell you nothing more than the copyright information unique to your particular printer. Restore Defaults

Pressing this button will restore the defaults on this page tab to their original settings. Graphics Resolution

This option will only apply if you are using a laser printer and true-type fonts. It enables you to change the resolution of your printing. Basically, the higher the resolution, the better quality printing you will get. Dithering

Dithering is used for color printing and black and white printing. It blends pure colors into patterns to simulate a wider range of colors (such as blending red and yellow together to make orange) when used with a color printer, and will produce grey shading in graphics for black and white printers. None

Click None if you don’t want any dithering. Course

Click this if your resolution setting is 300 dots per inch or higher. Fine

Click this option if your resolution setting is 200 dots per inch or less. Line Art

Click this option if your graphics include well-defined borders between black, white and grey settings. Error Diffusion

For printing pictures or photographs without well-defined or sharp edges. Intensity

This option has a slide bar that can be dragged by holding down your left mouse button on the arrow and dragging towards either darkest or lightest. It will affect how dark or light the graphics in your document are printed. Device Options Print Quality

The options under this heading will be unique to your printer. Basically, you can change the type of quality you want to use depending on if you want to print a draft, a presentation or whatever.

Back onto the Print Dialog Box now and we will look at Print Range.

Print Range

There are two options under print range. Select All you would use if you wish to print your entire Workbook, or Select Page(s) if you wish to only print some of your Workbook. You can either type in the From and Toboxes, or you can use the spin button (the tiny upwards and downwards pointing arrows to the right of these boxes) to make a selection. Then click OK. Print What

There are three options under this heading. Selection

By selecting this option, Excel will only print the range you have selected. Active Sheet

If you select this option, Excel will print the active sheet. This is defined as going from the first cell containing data to the furthest right most cell containing data, and the furthest bottom cell containing data in your Worksheet. Entire Workbook

This obviously will print the entire Workbook if selected. Copies

You can either type the number of copies that you require in this box, or use the spin button to make a selection, then select OK. Preview

By pressing this button, you will be able to view your document in Print Preview mode. More about this now in lesson 30.


Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft


Go back to:

Lesson 1 - Excel Fundamentals
Lesson 2 - Starting Excel and Excel Workbooks
Lesson 3 - Excel Toolbars and Task Panes
Lesson 4 - Excel Worksheets
Lesson 5 - Excel Cells and Navigating a Worksheet
Lesson 6 - Excel Cut/Copying and Pasting Data
Lesson 7 - Excel Copying with the Fill Handle
Lesson 8 - Excel Paste Special
Lesson 9 - Excel Insert Command
Lesson 10 - Excel's default options
Lesson 11 - Excel's Undo and Redo
Lesson 12 - Excel's Format Painter
Lesson 13 - Excel's Dates and Times
Lesson 14 - Excel's Custom Formats
Lesson 15 - Excel Formulas
Lesson 16 - Excel Cell References
Lesson 17 - Excel: Avoid Typing
Lesson 18 - Excel Formulae Arguments & Syntax
Lesson 19 - Excel Autosum Formula
Lesson 20 - Excel Auto Calculate
Lesson 21 - Excel's Insert Function
Lesson 22 - Excel's Useful Functions
Lesson 23 - Excel's Named Ranges
Lesson 24 - Excel's Constants and the Paste Name Dialog
Lesson 25 - Excel's Calculations
Lesson 26 - Excel Comments Cell
Lesson 27 - Excel Find and Replace
Lesson - 28 - Clear Excel Cell Contents

See also:

Lesson 30 - Effective Excel Printing 2
Lesson 31 - Sorting in Excel
Lesson 32 - Hide/Show Row/Columns in Excel
Lesson 33 - Auto-Formats in Excel
Lesson 34 - Creating a Basic Excel Spreadsheet
Lesson 35 - Excel Charting Lesson: The Basic Excel Spreadsheet
Lesson 36 - Excel Worksheet Protection
Lesson 37 - Excel IF Formula Nesting
Lesson 38 - Excel Function Now/Today Formulas


See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets


Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.



stars (0 Reviews)