How to Print Individual Worksheets in Excel

An error occurred trying to load this video.

Try refreshing the page, or contact customer support.

Coming up next: How to Set Print Scaling in Excel

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
Your next lesson will play in 10 seconds
  • 0:01 Printing from Excel
  • 0:50 Printing One Worksheet
  • 2:03 Printing Multiple Worksheets
  • 3:14 Lesson Summary
Add to Add to Add to

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Login or Sign up

Create an account to start this course today
Try it free for 5 days!
Create An Account

Recommended Lessons and Courses for You

Lesson Transcript
Instructor: Karen Sorensen

Karen has a Bachelors in Communications. She has 25 years of experience in Information Systems, Adult Learning and Virtual Training.

Workbooks can have multiple worksheets. Do you find yourself in need of printing just one worksheet rather than the entire workbook? This lesson will guide you through the steps for printing one worksheet or multiple worksheets.

Printing from Excel

There are many options when printing from Excel. And, at times, printing from Excel can be a bit frustrating. Excel spreadsheets can be large, with an enormous amount of data. Columns and rows can go on and on. As a result, before you go to print, settings usually require tweaks and adjustments.

Besides choosing whether to print landscape or portrait, print to letter or legal paper or scale to fit all on one page, you need to identify exactly what part of the workbook needs printing. Do you need the entire workbook? Maybe one worksheet? Or, could it be your workbook has ten worksheets and you only need to print three?

This lesson will explain the steps to printing one worksheet or multiple worksheets within a workbook.

Printing One Worksheet

A workbook can have multiple worksheets. Many times, you may want to print only one worksheet rather than printing the entire Excel file or workbook.

Imagine you have your family budget in Excel. You have used it and kept it updated for the last four years. You have a worksheet setup for each year, starting in 2011. There is one for 2011, 2012, 2013 and 2014. You would like to print only 2014.

Before we look at the steps, we should quickly review the meaning of Active Worksheet. The Active Worksheet is the spreadsheet that is displayed on your screen. To make a worksheet active, click on the worksheet tab. Now, let's take a look at the steps to print one worksheet.

  1. Activate the worksheet you want to print by clicking on the worksheet tab.
  2. Go to the File menu in the ribbon.
  3. Click on the Print command,
  4. Confirm that Print Active Sheets is selected.
  5. Click on Print.

It's that simple! The worksheet selected as the Active Worksheet is what will print.

Printing Multiple Worksheets

Let's take a look at another scenario. Let's assume we need to print 2011 and 2012. In this case, we need more than one worksheet to print but not the entire workbook. Again, just like printing one worksheet, Excel prints the sheets that are active. If we make 2011 and 2012 active, then we can follow the same steps and print just those two years.

The question becomes how do you select the two sheets? Simple. Using the Control key on your keyboard, hold down the Control key and select the worksheet tabs for 2011 and 2012.

To unlock this lesson you must be a Study.com Member.
Create your account

Register for a free trial

Are you a student or a teacher?
I am a teacher

Unlock Your Education

See for yourself why 30 million people use Study.com

Become a Study.com member and start learning now.
Become a Member  Back

Earning College Credit

Did you know… We have over 95 college courses that prepare you to earn credit by exam that is accepted by over 2,000 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Create an account to start this course today
Try it free for 5 days!
Create An Account