Printing spreadsheets in Excel

Name: Printing spreadsheets in Excel
Rating: 4.4 (97 reviews)

An easy to follow but thorough dive into using various known methods for printing complicated or large spreadsheets.

Created byJason Isler

Last updated 8/2016

English

What you'll learn

Format large Excel spreadsheets using various methods in order to print them successfully, legibly on letter, legal and tabloid sized paper.
Add Headers and Footers to a spreadsheet.
Scale spreadsheets to print quickly.

Course content

1 section • 9 lectures • 31m total length

Introduction1:16
An Introduction to our tutorial on printing Excel spreadsheets.
Scaling a spreadsheet to print2:50
Participants will be able to easily scale a spreadsheet to fit all columns on a single page.
Scaling Quiz
Preview your spreadsheet with Page Break Preview3:41
Page Break Preview is one of those hidden gems that proficient Excel users utilize often. It is an invaluable tool for resizing a spreadsheet and moving page breaks to where they are most needed.
Page Break Preview Quiz
Setting the Print Area4:09
Set the print area tells Excel that you know exactly what data your spreadsheet should display on a printed page and what it shouldn't.
Set the Print Area Quiz
Preview using Print Preview Full Screen1:53
Full Screen Print Preview provides a last minute view of your spreadsheet with some nice built-in functionality to correct errors before you send to print.
Print Preview Full Screen Quiz
Using Page Layout7:17
Participants will be able to use the Page Layout tab's functionality to add elements to a spreadsheet and further re-size a sheet to print.
Page Layout tab Quiz
Using Page Order2:37
Using Page order Quiz
Use Wrap Text3:38
Arguably, this topic could have been placed higher in the tutorial list. This is a necessary function to use when dealing with large spreadsheets, particularly when text is entered.
Wrap Text Quiz
Adding a Header or Footer4:15
Excel provides robust Header and Footer features. Add the sheet name, page numbers, or custom text to your header or footer prior to printing.
Header/Footer Quiz

Requirements

Some computer usage is expected.

Description

This course covers one of the most often performed tasks in Excel, but one that is not fully understood even by experienced, capable professionals. Learn to print a spreadsheet of almost any size starting with the first video. The course is only seven videos long and lasts about thirty minutes. Why thirty minutes just to learn how to print? Well, software developers often provide a number of ways to perform the same task, and that is the case with printing a spreadsheet in Excel. Also, some of these known ways can be combined to achieve the results we wish. Lastly, some methods may be more preferred by You, and so I did not wish to leave that out.

Who this course is for:

This course was first made available in a corporate environment. Professionals can take full advantage of this course since they are often tasked to create, edit, read, and of course, print large spreadsheets. Anyone who desires to understand this important function in a task-based manner will benefit from this course. In short, it is for All, however, experienced Excel Users will find this information basic.