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 Excel 2011 Cells & Worksheets

View:  
Sorted by:  

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

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

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

Sign Up for RSS Feeds

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

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.