Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Formatting in Excel 2011

View:  
Sorted by:  

Office 2011 for Mac: Applying Number and Text Formats in Excel

One of the things you might find you do frequently in Excel 2011 for Mac is change the way cells look, and you do so with options on the Home tab of the Ribbon. Other than the visual effect, format also [more…]

Make Sparklines in Excel in Office 2011 for Mac

If you're really in a hurry, or if space on your Excel 2011 for Mac worksheet is at a premium and you want a quick visual representation of your data, sparklines are worth investigating. It only takes [more…]

Office 2011 for Mac: Apply Number and Text Formats in Excel

One of the things you might find you do frequently in Excel 2011 for Mac is change the way cells look, and you do so with options on the Home tab of the Ribbon. Other than the visual effect, format also [more…]

Excel for Mac 2011: Fit and Position Cell Content in Worksheets

You can align and position cell contents in Excel using the Alignment group on the Office 2011 for Mac Ribbon’s Home tab at the top of the Excel window: [more…]

Office 2011 for Mac: Format Cell Borders in Excel Worksheets

Formatting cells and cell ranges in Excel 2011 for Mac is like formatting tables. In the Font group of the Ribbon’s Home tab, clicking Borders button displays a drop-down gallery of border styles. [more…]

Office 2011 for Mac: Format Dates and Times in Excel

Excel 2011 for Mac has fantastic date and time calculation capabilities. When using Excel worksheets, you need to know just two secrets: Each day is represented by a whole number, called a [more…]

Office 2011 for Mac: Choosing Conditional Formatting Rules in Excel

You can set Excel 2011 for Mac to change the format of a cell, cell range, table, or pivot table based on conditions you specify. Use these settings when you want a cell’s appearance to change as the result [more…]

Excel for Mac 2011: Add a Picture to a Worksheet Background

Behind the cells on each Excel worksheet in Office 2011 for Mac is a background layer that you can format. Excel for Mac 2011 doesn't offer a lot of customization to this feature, but you can place an [more…]

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

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

Excel 2011 for Mac: Working with Headers and Footers in Workbooks

Formatting headers and footers in Excel 2011 for Mac adds a distinctive appearance to your printed worksheets. You can also easily include important date and time information. You can work with headers [more…]

Office 2011 for Mac: Make a Watermark in an Excel Worksheet

You can use the Picture feature of the Header/Footer toolbar in Excel 2011 for Mac to insert a picture as a watermark. In an electronic environment, you create a watermark by formatting text and pictures [more…]

Listings:1-2526-47

Sign Up for RSS Feeds

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

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.