OzGrid

Lesson 30 - Effective Excel Printing 2

< Back to Search results

 Category: [Excel]  Demo Available 

EFFECTIVE EXCEL PRINTING 2

 

EXCEL PRINTING

Download the associated Workbook for this lesson

Make Use of Custom Views to Save Your Print Settings. Found under View on the main menu barDifferent Views

Excel provides you with lots of different settings that let you adjust the final appearance of the data that you wish to print. There are three different types of views that are available to you to help you see and adjust how the Worksheet will look when you print it. It is entirely up to you which view you work in, you can switch between the different views to view your work in different modes and see the effects before you print it.

The three views available to you are:

  • Normal View
  • Page Break Preview
  • Print Preview

Normal View

Normal view is the default of Excel. It is the best option for working with your document and for on-screen viewing. This view is available through the View menu.

Page Break Preview

This preview will show you the page breaks of your data and will easily allow you to adjust your print area and page breaks. This view is available through the View menu on the Standard Worksheet Menu Bar and is not covered in this lesson.

Print Preview

If you set your view to Print Preview, you can easily see your columns and margins and adjust them in this mode. All you need to do is hover your mouse over the column handles (located right at the top of your page) until your mouse changes to a cross and drag in whichever direction you require to widen the column, or place your mouse on the margin lines and drag in the same way. This view is available by pressing the Preview button on your Print dialog box, by selecting the Print Preview icon located to the right of your printericon on the Standard Toolbar, or by selecting Print Preview from the File menu.

Let us now have a look at printing a typical document.

Call up the attached Workbook ExcLev1L07. xls (NOTE: you may have to extract it from the ZIP first !)

  • Try Out The Different Views Available To You. Remember, Normal View (Which You Should Already Be In Since It Is The Default) And Page Break Preview Are Available Through The View Menu On The Standard Worksheet Menu Bar, Whilst Print Preview Is Available To You By Selecting The Icon Next To The Printer Icon, Or By Selecting Preview From The Print Dialog Box Or By Accessing Print PreviewFrom The File Menu.
  • Let Us Now Highlight The Range That We Wish To Print To Perform A Print By Selection. Select The Range A3:J54 On The Automatic Outline Worksheet.
  • Now Select Print Preview To Have A Look At Your Selected Range In This Mode By Using One Of The Three Methods Described Above.
  • Notice Down On The Status Bar At The Bottom Of Your Page You Will See The Text: Preview: Page 1 Of 2. This Is Telling You That You Are On Page 1 Of 2 Pages.

At the top of your screen are 9 buttons. Let’s have a look at some of these now.

Next and Previous

Selecting these buttons will take you through the number of pages you have on your screen. Next will take you forwards and Previous will take you to the previous page.

Zoom

By selecting this button, you will switch between a full-page view of a sheet and a magnified view. The Zoom feature will not affect the size of your printing. It is just an aid to assist with readability. You can switch between a full-page view and a magnified view of a sheet by clicking any area of the sheet. Notice your mouse will change to a magnifying glass when you do this. Place your mouse over the part of the sheet that you wish to magnify and by clicking your mouse button it is magnified.

Margins

Select the button titled Margins (another toggle button), you will see lines pop up on your screen. Each line depicts a margin. You can change your margins by hovering your mouse over the lines until your mouse changes to a cross, then drag to either widen or shorten. Selecting the Margins button again will hide the margin lines.

Setup

If you select this button, your Page Setup dialog box will pop up in front of you.

This dialog box can also be accessed via the File menu. You will notice as we go through this box that a few options are greyed out. If you select Page Setup through the File menu, all options will be available to you, so it is a good idea to access it this way while you are learning. This is probably the most important box of the entire printing function, as it is here you make the necessary changes to print your document professionally.

Orientation

Orientation means the way in which your sheet of paper prints from the printer. Portrait means with the shorter edge at the top of your page and the longer edges at the sides, and the Landscape option means with the longer edges at the top of the page and the shorter edges down the sides.

Scaling

There are two options under this heading. The first option Adjust to __% of normal size will allow you to reduce or enlarge the print range you have selected. The range varies from shrinking your selection to 10% of normal size, to expanding your selection to 400% of normal size.

The second option under this heading is Fit to __ page(s) high by __ page(s) tall. This will make our selection to fit on however many pages we specify.

Let’s now select Portrait under Orientation and Fit to 1 page(s) wide by 1 page(s) tall under Scaling. Now hit OK and you should be returned to Print Preview mode. You will notice that all our selected data now appears on one page.

If you hit the Setup button again, you will be returned to the Page Setup dialog box. Note here that under Adjust to __% of normal size you have 77%. This is telling you that Excel had to reduce your selected data to 77% of it’s normal size to fit it all onto a page that is 1 page wide by 1 page tall.

Now select the Landscape button under Orientation and then select the Adjust to __% of normal size option and either type or use the spin button arrows to reach 100%. Select OK again to accept your choice.

Again you will be returned to Print Preview mode and you will notice now that your selected data is again on two pages. If we wanted to, we could select the Fit to 1 page(s) wide by 1 page(s) tall option, to fit all of our data on a landscape page, but in this case we will print on 2 pages.

Paper Size

You can change your paper size here, as well as in your Print dialog box if you wish by selecting your downward pointing arrow to see the paper sizes available through your printer.

Print Quality

You can change your print quality here, as well as in your Print dialog box by also selecting the downward pointing arrow to see the ranges available to you.

First Page Number

The default here is Auto which means your printing will Start at page 1. If you wish to print Starting at another page number, you can type any number other than 1 in this box.

Margins

This sheet tab will show you the margins of your page and the margins of any headers or footers you may have. You can type your margins in if you wish, but it is far easier to change your margins using the Marginsbutton in Print Preview mode, as discussed above.

Centre on Page

This option however, is a very handy feature not available in Print Preview mode. By selecting either horizontal or vertical you will center your selection on your page either horizontally or vertically.

Header/Footer

The definition of a Header or Footer is something that is required to appear on every page of your document. As the names suggest, a Header is something that will appear at the top of every page, and a Footer is something that will appear at the bottom of the page. In Excel, you can have only one Header and one Footer in each Worksheet. The Header/Footer Dialog box can be accessed through the Page Setup dialog box, or via the View menu on your Standard Worksheet menu bar.

Let us first create a Header for the data that we wish to print.

  • Click On Custom Header.
  • Click In The White Box Under Centre Section. As The Title Suggests, If You Type In This Box, Your Header Will Be Centered, Left Section Will Left Align Your Text And Right Section Will Right Align Your Text.
  • Type In The Words FOUR YEAR FORECAST In The Centre Section Box.
  • Now, Highlight Your Text And Click On The A Icon Above. You Will Now Be Familiar With The Format Cells Dialog Box, And What You Are Looking At Now Is A Mini Version Of This.
  • Select Bold Under Font Style And 24 Under Size. Click OK.
  • You Will Now Be Taken Back To Your Header Dialog Box And You Will Notice That The Words FOUR YEAR FORECAST Are Indeed Bolded And Size 24.
  • Select OK.

Now you are back in your Page Setup dialog box, notice that your header is in the top white box, and also under the heading Header.

To the right of the second white box is a downward pointing drop down arrow. This contains some built-in headers. If you wanted to, you could select a build-in header, then go to Custom Header to use it for your Worksheet.

Footers work in exactly the same way so let’s put a footer in now

  • Click On Custom Footer.
  • Click In The White Box Under Left Section.
  • Select The Second Icon From The Left With A Green Cross In It. You Will Notice &[File] Appear In The Left Section. This Will Automatically Insert The File Name Of Your Worksheet Into The Left Section Of Your Worksheet.
  • The Other Icons Here (Apart From The A Which Is The Mini Version Of Your Format Cells Dialog Box) Will Insert Information As Follows:
    • # Will Automatically Insert The Page Numbers For You.
    • ++ Will Automatically Insert The Number Of Pages In The Active Workbook. 
      This Means That If You Had Page # Of ++ In Your Footer, You Would Actually Have Page 1 Of 12 (Or However Many Pages You Had).
    • 8/7 This Will Automatically Insert The Current Date.
    • Clock Will Automatically Insert The Current Time.
    • Green Cross Will Automatically Insert The Current File Name.
    • Blank Paper Will Automatically Insert The Sheet Name Of The Current Worksheet.
  • Now Click In Right Section Of Your Footer, Type The Words Printed On Then Select The Date Icon.
  • Now Select OK To Return You To Your Page Setup Dialog Box.

The last section of the Page Setup dialog box that we need to look at is under the Sheet heading

Sheet

The top area of this box is greyed out. If something is greyed out within Excel, this is because the options are not available in the area in which you are in. The options at the top of this box are only available if you access the Page Setup dialog box via the File menu as mentioned above.

The only options we need to look at here are the ones under Print.

Print

If you select Gridlines the gridlines of your Excel Worksheet will print.

If you select Black and White, your data will be printed in Black and white only (if you have color in it, it will appear as grey shading).

If you select Draft Quality your data will be printed in draft quality.

If you select Row and Column Headings then the row and column headings (A, B, C, 1, 2, 3 etc) will be printed.

Page Order

You have two options here; Down then Over and Over then Down. Selecting one of these options will control the way data is numbered and printed when it does not fit on one page.

Let us select OK now to return us to Print Preview mode to have a look at our nearly ready to print Worksheet.

You will notice that you can now see the Header and Footer that we placed in our Worksheet.

Now hit your Next button and you will notice that the row that appears at the top of page 1 (Jan, Feb, 1st Quarter etc) does not appear at the top of page 2. We can easily change this by doing the following.

  • Press Your Close Button To Close You Out Of Your Print Preview Mode And Return You To Your Worksheet.
  • Now With Your Print Range Still Selected, Go To File>Page Setup>Sheet. You Will Notice In Here That The Top Half Of The Box Is Now NOT Greyed Out, So All Options Are Accessible. The Top Option Print AreaAllows You To Select The Range That You Wish To Print If You Have Not Already Done So. We Have Already Selected Our Print Area, So We Do Not Need To Use This Option In Our Printing.
  • We Need To Go To Rows To Repeat At Top Under Print Titles.  Let Us Press The Collapse Box (Red Arrow) To The Right Of This Box, To Collapse The Dialog Box And Enable Us To Select The Row We Wish To Repeat.
  • All We Need To Do Now Is To Select Somewhere In Row 3. This Will Place The Reference $3:$3 In The Rows To Repeat At Top Box.
  • Press Your Collapse Box Button Again To Expand The Box. 
    You Will Note The Option Here Columns To Repeat At Left. This Works The Same As For Rows, Except It Will Repeat The Selected Columns On Each Page. You Can Also Note Here That Under The Heading PrintThere Is An Option Called Comments. This Option Is Only Available If You Select Your Page Setup Dialog Box Via The File Menu And Is Used To Print What Are Known As Comments (Discussed In Excel – Level 2)
  • Select OK.
  • Now We Are Happy With Our Worksheet, We Can Print It By Selecting The Print Button In Print Preview Mode.

Once a document has been saved with it’s print settings, you only need to press the Print icon on the Standard Toolbar to print. This will by-pass Print Dialog box and send your Worksheet straight to the printer.

As we stated at the beginning of this lesson, printing is an essential part of Excel. Even in these days of a paperless office, we need to be able to efficiently present data that people can understand and use to it’s fullest capacity. Our personal preference is to use Print Preview first to set up how a worksheet would look, although you need to be aware that not all options in the Page Setup dialog box are available to you by doing it this way. You can access the Page Setup dialog box via the File menu and have all options discussed here available, but at the end of the day, it is up to you which way you use.

Printing Workbooks

If you have quite a few Workbooks to print, go to File>Open from within Excel, select the Workbook(s) uisng the Ctrl key, then right click and choose Print.

 

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
Lesson 29 - Effective Excel Printing 1

See also:

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.

 


Gallery



stars (0 Reviews)