Before you can print your Excel 2011 for Mac spreadsheet, you need to be familiar with Excel’s print options. Head to the Print group on the Layout tab of the Office 2011 for Mac Ribbon, and you’ll find the printing tools you’ll use most often when printing from Excel 2011 for Mac:
- Preview: Displays a preview of your document in the Mac OS X Preview application. Adobe Reader or Adobe Acrobat may intercept this action.
- Repeat Titles: Displays the Sheet tab of the Page Setup dialog.
- Gridlines: Selecting this check box prints all the lines between the rows and columns.
- Headings: Prints row numbers and column letters.
- Fit To: You can shrink the width and height of the printed output separately so that the content fits in a few less pages.
By Geetesh Bajaj, James Gordon. Use a list box when you’re making a form in Excel 2011 for Mac and have a long list of items from which a choice is to be made. The list box will report which item was selected with a number that shows how many items from the top of the list was chosen. Question: In Microsoft Excel 2011 for Mac, how do I set up a named range so that I can use it in a formula? Answer: A named range is a descriptive name for a collection of cells or range in a worksheet. To add a named range, select the range of cells that you wish to name. In this example, we've selected all cells in column A.
![Microsoft Excel For Mac 2011 Change Range For List Microsoft Excel For Mac 2011 Change Range For List](/uploads/1/2/5/6/125689845/655416598.jpg)
![Mac Mac](/uploads/1/2/5/6/125689845/160872307.png)
You have several ways to adjust the way you print Excel files on the Sheet tab of the Page Setup dialog, accessed by clicking the Repeat Titles button:
Excel For Mac 2011 Download
- Rows to Repeat at Top: If you want the first row (probably composed of column headings) to repeat on each printed page, use this setting.
- Columns to Repeat at Left: This option is like setting a row to print, except you click a column instead.
- Print Area: Type in a range, name of a table, PivotTable, query table, or some other named object. Separate multiple ranges or objects with commas. Each object or range prints on a new sheet of paper.
- Black and White: Prints in black and white. You will choose this option if you have some colored areas in the worksheet that you want to print as black and white.
- Draft Quality: Prints to a lower fidelity, draft output.
- Comments: The Comments pop-up menu lets you choose from these options:
- None: Don’t include comments.
- At End of Sheet: Show all comments at the end of the printed sheet.
- As Displayed on Sheet: Show comments as they appear on the worksheet.
- Page Order: You get two options within this area:
- Down, Then Over: Prints pages from your worksheet, from top to bottom leftwards, and then the same way from top to bottom subsequently. Think about printing pages as in a flipped N.
- Over, Then Down: Prints pages from your worksheet, from left to right topwards, and then the same way from the left to right subsequently. Think of printing pages in a sequence as in a Z.
- Tech support scams are an industry-wide issue where scammers trick you into paying for unnecessary technical support services. You can help protect yourself from scammers by verifying that the contact is a Microsoft Agent or Microsoft Employee and that the phone number is an official Microsoft global customer service number.
- Change the width of columns so that you can see all the data in cells. Protect a sheet. Prevent unauthorized changes, moves, or deletions of important data. Highlight patterns and trends with conditional formatting. Change the appearance of cells based on certain criteria, for example, all cell values in the top 10% of a range.