Excel 2011 Set Print Area Professional Presentations And
Excel 2011 Set Print Area How To Do Everything
Excel 2011 Set Print Area How To Do That

Head to the Print group on the Layout tab of the Office 2011 for Mac Ribbon, and youll find the printing tools youll use most often when printing from Excel 2011 for Mac.

You will choose this option if you have some colored areas in the worksheet that you want to print as black and white.

Excel 2011 Set Print Area Professional Presentations And

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

It indicates a way to see more nav menu items inside the site menu by triggering the side menu to open and close.

The Print Area function in Excel allows you to print part of a spreadsheet rather than the full sheet.

However, if you dont manage your print setup, this can create print jobs with page breaks where you dont want them and reams of blank pages as Excel works its way down to the random character you entered by accident in cell Z2647.

The Print Area feature in Excel is a powerful tool that makes it easier to print just the data you need by allowing you to select part of a spreadsheet to print.

Check out the products mentioned in this article: Microsoft Office (From 139.99 at Best Buy) MacBook Pro (From 1,299.99 at Best Buy) Lenovo IdeaPad 130 (From 299.99 at Best Buy) How to set print area in Excel For the sake of this example, we use a small set of data about employees of a fictitious company.

The dataset includes position, division, city, and date of hire.

You might want a list with just the employees hired before or after a certain date, everyone in a certain position, or employees of a certain division.

Excel 2011 Set Print Area How To Do That

Heres how to do that using the Print Area button.

Click on Page Layout in the top menu to open its menu ribbon.

When you click File in the top menu bar and the Print, youll see a preview of what Excel will print.

This will help you determine if you set the right print area correctly.

A window will pop up with several ways you can modify your page setup.

This field displays your print area, starting with the top box on the left and ending with the bottom box on the right.

Pro tip: when you finish printing, click the Print Area button again and choose Clear Print Area.

Otherwise, your spreadsheet tab will retain the print area you selected and the next time you go to print data youll get only that limited data, unless you set a new print area.

Excel 2011 Set Print Area How To Do Everything

Related coverage from How To Do Everything: Tech: How to remove duplicates in Microsoft Excel to clean up data in individual or multiple columns How to create a drop-down list in Excel to manage data and prevent mistakes How to move columns in Microsoft Excel to organize your spreadsheet data How to hide and unhide rows in Microsoft Excel in 2 different ways How to remove blank rows in Microsoft Excel to tidy up your spreadsheet.

Excel 2011 For Mac Set Print Area