Welcome to Excel 2011 for the Mac: Mastering Formulas and Functions. Oefen terwijl u leert met oefenbestanden. Extracting specific data with LEFT and RIGHT. Removing extra spaces with TRIM. Using ampersands and CONCATENATE to combine data from different cells. Step 2: Open the contacts by using Excel 2011 for Mac. In Excel 2011 for Mac, on the File menu, click Open, and then select the.txt file that you created in step 1. On the right side, under Shortcuts to other things you can do, click Import your contacts from an existing e-mail account.

Serena asked if there is a way to adjust the text margins with a cell so that there is more white space within a cell. The answer is that there is no intrinsic Excel command to add more space, as you can do in Word tables or with the CELLPADDING attribute in an HTML table. However, there is a way you can accomplish the desired goal, although it is somewhat more manual in nature. Follow these general steps: • Select the cell you want to adjust. • Click the Cells option on the Format menu. Excel displays the Format Cells dialog box. • Make sure the Alignment tab is displayed.

(See Figure 1.) Figure 1. The Alignment tab of the Format Cells dialog box.• Using the Horizontal drop-down list, choose Center. • Using the Vertical drop-down list, choose Center.

There are also two other ways to do so — the first is by opening up Disk Utility and going to File -> Open Disk Image. The second way is by opening up a Terminal window and typing something similar to the following: hdiutil mount filename.iso Did this really require us to write up a tip? Until very recently, mounting an ISO image on Windows required installing some additional software, but over on the Mac OS X side of things, you can easily mount an ISO image by simply double-clicking on it.

• Click on OK. • Adjust your column width to leave the desired white space on both sides of the cell contents. • Adjust your row height to leave the desired white space above and below the cell contents. The drawback to this approach, of course, is that it affects the width of not just one cell, but of the entire column and row. In addition, your numbers will not line up properly—on the decimal point—if you choose to center horizontally.

The way around this last issue is to still center the contents horizontally, but use a custom number format for the cells, as follows: [???,??0.00;-??,??0.00] The question marks in the format forces Excel to leave space as if there were a digit, even if there isn't. You cannot change the vertical white space without adjusting row height.

There is, however, one thing you can try if you want to change the horizontal white space: Adjust the indent value used in a cell. All you need to do is display the Format Cells dialog box, and then set the indent on the Alignment tab. If you are using Excel 97 or 2000 you can only adjust the left indent. If you are using a later version of Excel you can adjust either the left or right indent (check out the Horizontal drop-down list), but not both.

• Select the text you want to adjust. • On the Home tab, click Line and Paragraph Spacing, and then click Line Spacing Options at the bottom of the menu. The Paragraph dialog box opens. • On the Indents and Spacing tab, select the options you want, and click OK. The Paragraph dialog box options are described in the following section. Paragraph dialog box options Choose from these options in the Paragraph dialog box. At the bottom of the dialog box, the Pre”view box shows you how the options look before you apply them.

General Alignment Select Left to align text to the left with a ragged right edge (or use the keyboard shortcut, + L). Select Centered to center text with a ragged left and right edge ( + E). Select Right to align text to the right with a ragged left edge ( + R). Select Justified to align text both left and right, adding space between words ( + J). Outline level Select the level at which the paragraph appears in Outline view. Indentation Left Moves in the left side of the paragraph by the amount you choose. Right Moves in the right side of the paragraph by the amount you choose.