Printing spreadsheets in Excel

An easy to follow but thorough dive into using various known methods for printing complicated or large spreadsheets.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
0 students enrolled
25% off
Take This Course
  • Lectures 9
  • Length 32 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2015 English

Course 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.

What are the requirements?

  • Some computer usage is expected.

What am I going to get from this course?

  • 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.

Who is the target audience?

  • 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: How to scale and print a spreadsheet

An Introduction to our tutorial on printing Excel spreadsheets.


Participants will be able to easily scale a spreadsheet to fit all columns on a single page.

Scaling Quiz
1 question

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
1 question

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.

1 question

True or False question on setting the print area in a spreadsheet


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.

1 question

A brief quiz to test our understanding of the capabilities associated with the Print Preview Full Screen button.


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
1 question
Using Page Order
1 question

A quiz to help us determine the correct situations in which to modify the order in which pages are printed.


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.

1 question

If I choose Wrap Text and do not see my text wrap, what may be the problem?


Excel provides robust Header and Footer features. Add the sheet name, page numbers, or custom text to your header or footer prior to printing.

1 question

This quiz tests our memory of how to quickly navigate to the area to modify an Excel Header or Footer.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jason Isler, Instructional Designer/Analyst

A certified Excel expert and CompTIA certified Technical Trainer. Responsible for eLearning development in a corporate environment. Although professionals can be very talented and capable they may not always be comfortable with technology. My investment is in creating a comfort level with these necessary tools so that they empower its Users to fulfill their tasks.

Ready to start learning?
Take This Course