• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Support Your Tech

Instructions and tutorials to help you get the most from your applications and devices

  • Android
  • Excel
  • Word
  • iPhone
  • Mac
  • Docs
  • Slides
  • Sheets
  • Streaming
You are here: Home / Excel / How to Clear a Print Area in Excel for Office 365

How to Clear a Print Area in Excel for Office 365

April 2, 2019 By Matt Jacobs

Have you ever gone to print a spreadsheet in Excel, only to have your pages broken up in weird spots, or certain rows or columns entirely excluded? In many cases this is due to an incorrectly-defined print area.

If your spreadsheet has a print area that is missing some of your data or splitting it up incorrectly, then you may need to either reset the print area, or remove it entirely. Either way you will need to remove the existing print area from the spreadsheet.

How to Remove a Print Area in Excel

The steps in this article were performed in Microsoft Excel for Office 365. By completing this tutorial you will be clearing an existing print area from the current worksheet. This means that the next time you go to print it, then entire spreadsheet will be printing.

Step 1: Open your file in Excel.

Step 2: Select the Page Layout tab at the top of the window.

select the page layout tab

Step 3: Click the Print Area button.

how remove excel print area

Step 4: Choose the Clear Print Area option.

how to clear the print area in excel for office 365

Defining or removing the print area is just one of the many ways that you can customize your spreadsheet when you print. Find out how to horizontally center a printed spreadsheet so that it looks better on paper.

Matt Jacobs

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Primary Sidebar

Recent Posts

  • How to Show Contact Photos in Messages on an iPhone 11
  • How to Sign Out of Spotify on an iPhone
  • How to Flip a Picture in a Microsoft Word Document
  • How to Announce Messages with Siri on an iPhone 11
  • How to Clear Spotify Cache on an iPhone

Featured Posts

How to Upload iPhone Videos to YouTube in HD

how to merge cells vertically in Google Sheets

How to Merge Cells Vertically in Google Sheets

how to loop a slideshow in Powerpoint for Office 365

How to Do a Powerpoint for Office 365 Slideshow Loop

How to Clear a Print Area in Excel for Office 365

how to disable iPhone data roaming

How to Turn Off Data Roaming on an iPhone 11

How to Stop the Screen from Sliding Down on an iPhone 7 Plus

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Privacy Policy
  • Affiliate Disclaimer
  • Contact Us
  • About Us

SupportYourTech.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Copyright © 2021 SupportYourTech.com