Occasionally you may find yourself working with a very large spreadsheet that you need to print. We have previously written about how to fit that sheet to one page in Excel 2011, but that isn’t always practical when you are dealing with a lot of data. But you can take advantage of a feature that allows you to set a print area in Excel 2011 so that only part of a spreadshet is printed, as opposed to the entire thing.
Set the Print Area in Excel 2011 for Mac
Note that this is something that you will need to set and clear if you decide that you want to print the entire spreadsheet, or a different part of the spreadsheet later.
Step 1: Open the spreadsheet in Excel 2011.
Step 2: Use your mouse or trackpad to highlight the section of the spreadsheet that you want to set as the print area.
Step 3: Click the File tab at the top of the window.
Step 4: Scroll down to the Print Area option, then select the Set Print Area option.
Now when you go to print your spreadsheet, you will see that only the area that you just selected is displayed on the Quick Preview area of the Print menu.
Did you know that you can purchase magazine subscriptions from Amazon? They have many popular options, including Time, Entertainment Weekly and Cosmopolitan, all of which are available at a low price. Click here to learn more.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.