Excel 2011

View:  
Sorted by:  

How to Customize a Chart in Excel for Mac 2011

Customizing charts in Excel for Mac 2011 is fun — after all, you have loads of combinations to experiment with. To use the Excel tools in Office 2011 for Mac, be sure to click the chart's border to select [more…]

Make Check Boxes for Excel Forms in Office 2011 for Mac

Knowing how to make checkboxes in Excel 2011 for Mac is a handy bit of know-how. Check boxes appear in all kinds of forms, such as surveys and questionnaires, where you choose from multiple answers. In [more…]

Making Radio Buttons for Excel Forms in Office 2011 for Mac

Knowing how to make radio buttons in Excel 2011 for Mac is just as important as knowing how to make check boxes. Radio buttons (also called option buttons [more…]

How to Perfect Excel Charts in Office 2011 for Mac

One of the more subtle things to master with charts in Excel for Mac 2011 is training yourself to be aware of what is selected at any given moment. The Ribbon can help you with this. When you click anywhere [more…]

Excel 2011 for Mac: Adding Trendlines, Error Bars to Charts

When you make Excel charts in Office 2011 for Mac, you find a brand-new set of Chart tabs on the Ribbon that guide you with the latest Microsoft charting technology. Excel 2011 for Mac offers real power [more…]

Office 2011 for Mac: Copying Excel Charts to Word or PowerPoint

If you're working with Office 2011 for Mac, you’ll be glad to know that it’s easy to move your charts from Excel to Word and PowerPoint. You can even create a chart directly in Word 2011 for Mac and PowerPoint [more…]

Make a Chart in Word or PowerPoint in Office 2011 for Mac

You can make charts a few ways in Office 2011 for Mac. Starting a chart from Word or PowerPoint is almost the same as starting one in Excel, but not quite. Here are some tips to keep in mind when making [more…]

How to Copy and Paste in an Excel 2011 for Mac Worksheet

The first thing to consider when copying and pasting content into Excel in Office 2011 for Mac from Excel (or some other application) is to think about the nature of what you're attempting to copy. Cells [more…]

Excel 2011 for Mac: Using the Paste Special Feature

In Office 2011 for Mac, Excel’s simple Paste option handles most of your ordinary pasting requirements, but it's a one-shot deal — you can choose only a single option. On the other hand, the Paste Special [more…]

Move and Copy Entire Excel Sheets in Office 2011 for Mac

In Excel 2011 for Mac, you can move or copy one sheet at a time, or select multiple worksheets and move or copy them all at once. You can move or copy sheets within a workbook or from one workbook to another [more…]

Using the Excel Camera Tool in Office 2011 for Mac

The Camera tool in Excel 2011 for Mac creates a “picture” of a range of cells. “Picture” is in quotation marks because these pictures aren’t static; they’re [more…]

Hide and Unhide Excel Worksheets, Rows, and Columns in Office 2011 for Mac

In Excel 2011 for Mac, you can hide entire worksheets or just some columns or rows. And you can unhide them, too. This control over what can be seen or not can be helpful in hiding content such as: [more…]

How to Move Data from External Sources into Excel 2011 for Mac

You can find data in many different places and bring it into Excel 2011 for Mac workbooks in whole, or as the result of a query in a query table. The tools on the External Data Sources group of the Data [more…]

Group and Ungroup Rows in Excel 2011 for Mac

In Office 2011 for Mac, use Excel's Group tool to identify ranges of rows in worksheets that you can then turn on and off. Activate the rows by using switches in a new margin that's displayed when Group [more…]

Using a Web Query to Load Tables in Excel 2011 for Mac

In Office 2011 for Mac, Excel can try to load tables from a Web page directly from the Internet via a Web query process. A Web query is simple: It’s just a Web-page address saved as a text file, using [more…]

How to Share a Workbook in Excel 2011 for Mac

Excel was the first Office application to allow more than one person at a time to make changes in a shared file live, in real time. The Excel Share Workbook feature in Office 2011 for Mac is useful if [more…]

How to Work with Worksheet Comments in Excel 2011 for Mac

Working with comments in Excel 2011 for Mac is a breeze with the Comments group on the Review tab from the Office 2011 for Mac Ribbon. In the following sections, you can find out how to add, edit, and [more…]

Excel 2011 for Mac: Track Changes in a Worksheet

Say that you want multiple people to work on an Excel workbook in Office 2011 for Mac that you plan to distribute via e-mail, SkyDrive, SharePoint, or other means. You distribute a workbook to several [more…]

Protect Excel Worksheets and Lock Cells in Office 2011 for Mac

When you make forms in Excel 2011 for Mac, you’ll be turning worksheet protection on and off frequently. You must turn off worksheet protection when you want to build a form. Turning off sheet protection [more…]

Office 2011 for Mac: Validate Data on Excel Forms

It’s always a good thing when you can help people fill out a form that you've created in Excel 2011 for Mac. One way is to make it harder for them to make mistakes when filling out the form. For example [more…]

Making List Boxes for Excel Forms in Office 2011 for Mac

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 [more…]

Office 2011 for Mac: Making a Scroll Bar for Excel Forms

A scroll bar control in a form made in Excel 2011 for Mac generates a number within a specified range, in set increments. The form user drags the scroll bar control left and right or up and down. As the [more…]

Making Pop-up Menu Buttons for Excel Forms in Office 2011 for Mac

The official name of a pop-up menu in Excel 2011 for Mac is combo box. Don't you just hate it when you have to use a pop-up menu that's so big it doesn't even fit on the screen? Pop-up menus work best [more…]

Office 2011 for Mac: Making Spin Buttons for Excel Forms

In Excel 2011 for Mac, the spin button control is similar to the scroll bar control, but is always vertical. You can make it tall and skinny if space is tight. Spin button, also known as a spinner control [more…]

Make a Form on a Dialog Sheet in Excel 2011 for Mac

In Office 2011 for Mac, Excel has a special kind of sheet called a dialog sheet, on which you can make an input form such as the one you see when you’re in an Excel 2011 for Mac table and choose Data→Form [more…]

Listings:1-2526-5051-7576-100more...
Advertisement

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com