Learn Excel Now

Conquer the Fear of Excel

  • Home
    • Our Team
  • Training
    • Custom Training
      • Custom Virtual Group Training
      • Custom Onsite Group Training
      • Consulting Services
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
      • Simply Excel Pt. II
  • Resources
    • Contact
    • FAQ
    • New User Onboarding
  • Login

Setting a Print Area in Excel

January 27, 2016 by Tyrone Pernsley

Setting the Print Area in ExcelPrinting with excel is always a challenge. Even excel experts have difficulties printing exactly what they want from their excel spreadsheets. If this is a daily fear or challenge at your workplace this post is for you!

Special Paste

To make printing excel spreadsheets quick and easy, you can define a print area that includes just that selection of cells that you desire to be printed. A print area is a range of cells that you can designate to print when you do not want to print the entire excel spreadsheet or continuously highlight cells then search for “Print Selection”

Print Area

To set a print area in excel spreadsheets, all you have to do is highlight the cells that you desire to be printed (called the print area) then move your cursor up to the Page Layout tab in the Page Setup group, click the Print Area dropdown arrow, then click Set Print Area. To check if you have done this correctly, you can go to the “print” option in the File group to make sure your designated cells will be printed.

To add cells to an existing print area, simply highlight the cells that are adjacent to your previous designated print area cells then move your cursor up to the Page Layout tab in the Page Setup group, click the Print Area dropdown arrow, and then click Add to Print Area. To check if you have done this correctly, you can go to the “print” option in the File group to confirm that the new cells have been added to your previous print area.

The only catch to this is that if the new cells that you would like to add are not adjacent to your existing print area than another separate printer area will be created. Additional print areas will be printed on separate pages.

The print area that you have designated will be saved when you save your excel spreadsheet so that each time you want to print this spreadsheet, your designated print area will only be printed.

Finally, if you would like to remove the print area, just highlight the cells that you would like to clear then move your cursor up to the Page Layout tab in the Page Setup group, click the Print Area dropdown arrow, then click Clear Print Area. Just remember that if you clear one print area than all the other print areas you have will be removed from your spreadsheet. To check if you have done this correctly, you can go to the “print” option in the File group to confirm that the print area has disappeared so that you can successfully print the entire excel spreadsheet.

Now you are a print area expert! You now know how to select, add, and clear print areas in excel spreadsheets. Hopefully this post has helped you conquer your fear of constantly printing specific sections of excel spreadsheets!

We hope you found todays quick and easy Excel lesson beneficial. Don’t forget to follow ups on Social Media and subscribe to the blog to get convenient, quick tips like this, and other great Excel training tips so that you can take the fear out of Excel.

Like Learn Excel Now? Sign up for the newsletter!

-Kevin, Learn Excel Now

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In