Excel 2010 part 9

pdf
Số trang Excel 2010 part 9 10 Cỡ tệp Excel 2010 part 9 940 KB Lượt tải Excel 2010 part 9 0 Lượt đọc Excel 2010 part 9 0
Đánh giá Excel 2010 part 9
5 ( 22 lượt)
Nhấn vào bên dưới để tải tài liệu
Để tải xuống xem đầy đủ hãy nhấn vào bên trên
Chủ đề liên quan

Nội dung

Apply Font Effects You can improve the look and impact of text in an Excel worksheet by applying font effects to a range. Excel’s font effects include common formatting such as bold, italic, and underline, which are available on the Ribbon for easy application. Excel also offers a dialog box tab that includes many more font effects, including special effects such as strikethrough, superscripts, and subscripts. In most cases, you should not need to apply more than one or two font effects at a time. If you use too many effects, it can make the text difficult to read. Apply Font Effects 1 Select the range you want to 2 3 format. 2 Click the Home tab. 3 To format the text as bold, click the Bold button ( • ). 4 To format the text as italic, click the Italic button ( ). 5 To format the text as underline, click the Underline button ( ). • 1 Excel applies the bold effect to the selected range. 4 5 6 Excel applies the effects to the selected range. 6 Click the Font dialog box launcher ( ). 80 07_577639-ch05.indd 80 3/15/10 2:41 PM 5 CHAPTER Formatting Excel Ranges The Format Cells dialog box appears with the Font tab displayed. 7 To format the text as strikethrough, click Strikethrough ( changes to ). 7 8 To format the text as a superscript, click Superscript ( changes to ). • To format the text as a subscript, click Subscript ( changes to ). 9 Click OK. 8 Excel applies the font effects. 9 Are there any font-related keyboard shortcuts I can use? Yes. Excel supports the following font shortcuts: Press 07_577639-ch05.indd 81 To + Toggle the selected range as bold + Toggle the selected range as italic + Toggle the selected range as underline + Toggle the selected range as strikethrough 81 3/15/10 2:41 PM Change the Font Color When you build an Excel worksheet, you can add visual interest to the sheet text by changing the font color. By default, each Excel workbook comes with a theme applied, and you can change the font color by applying one of the colors from the workbook’s theme. You learn more about workbook themes in Chapter 9. You can also select a color from Excel’s palette of standard colors, or from a custom color that you create yourself. Change the Font Color Select a Theme or Standard Color 1 Select the range you want to format. 2 3 2 Click the Home tab. 3 Click in the Font Color list ( 1 ). 4 Click a theme color. • • Alternatively, click one of Excel’s standard colors. Excel applies the color to the range text. 4 82 07_577639-ch05.indd 82 3/15/10 2:41 PM 5 CHAPTER Formatting Excel Ranges 2 Select a Custom Color 3 1 Select the range you want to format. 2 Click the Home tab. 3 Click in the Font Color 4 1 list ( ). 4 Click More Colors. The Colors dialog box appears. 6 5 Click the color you want to use. 5 • You can also click the Custom tab and then either click the color you want or enter the values for the Red, Green, and Blue components of the color. 6 Click OK. Excel applies the color to the selected range. How can I make the best use of fonts in my documents? • • • • • • Do not use many different typefaces in a single document. Stick to one, or at most two, typefaces to avoid the ransom note look. Avoid overly decorative typefaces because they are often difficult to read. Use bold only for document titles, subtitles, and headings. Use italics only to emphasize words and phrases, or for the titles of books and magazines. Use larger type sizes only for document titles, subtitles, and, possibly, the headings. If you change the text color, be sure to leave enough contrast between the text and the background. In general, dark text on a light background is the easiest to read. 83 07_577639-ch05.indd 83 3/15/10 2:42 PM Align Text Within a Cell You can make your worksheets easier to read by aligning text and numbers within each cell. By default, Excel aligns numbers with the right side of the cell, and it aligns text with the left side of the cell. You can also align your data vertically within each cell. By default, Excel aligns all data with the bottom of each cell, but you can also align text with the top or middle. Align Text Within a Cell Align Text Horizontally 1 Select the range you want to 2 3 format. 2 Click the Home tab. 3 In the Alignment group, click the horizontal alignment option you want to use: Click Align Text Left ( ) to align data with the left side of each cell. 1 Click Center ( ) to align data with the center of each cell. Click Align Text Right ( ) to align data with the right side of each cell. Excel aligns the data horizontally within each selected cell. • In this example, the data in the cells is centered. 84 07_577639-ch05.indd 84 3/15/10 2:42 PM 5 CHAPTER Formatting Excel Ranges 2 3 Align Text Vertically 1 Select the range you want to format. 1 2 Click the Home tab. 3 In the Alignment group, click the vertical alignment option you want to use: Click Top Align ( ) to align data with the top of each cell. Click Middle Align ( ) to align data with the middle of each cell. Click Bottom Align ( ) to align data with the bottom of each cell. Excel aligns the data vertically within each selected cell. • How do I format text so that it aligns with both the left and right sides of the cell? This is called justified text, and it is useful if you have a lot of text in one or more cells. Select the range, click the Home tab, and then click the dialog box launcher ( ) in the Alignment group. The Format Cells dialog box appears with the Alignment tab displayed. In the Horizontal list, click and then click Justify. Click OK to justify the cells. In this example, the text is aligned with the middle of the cell. How do I indent cell text? Select the range you want to indent, click the Home tab, and then click the Alignment group’s dialog box launcher ( ). In the Alignment tab, click the Horizontal list and then click Left (Indent). Use the Indent text box to type the indent, in characters, and then click OK. You can also click the Increase Indent ( ) or Decrease Indent ( ) button in the Home tab’s Alignment group. 85 07_577639-ch05.indd 85 3/15/10 2:42 PM Center Text Across Multiple Columns You can make a worksheet more visually appealing and easier to read by centering text across multiple columns. This feature is most useful when you have text in a cell that you use as a label or title for a range. By centering the text across the range, it makes it easier to see that the label or title applies to the entire range. Center Text Across Multiple Columns 1 Select a range that consists of 1 the text you want to work with and the cells across which you want to center the text. 2 Click the Home tab. 3 In the Alignment group, click the dialog box launcher ( ). 2 3 86 07_577639-ch05.indd 86 3/15/10 2:42 PM 5 CHAPTER Formatting Excel Ranges Excel opens the Format Cells dialog box with the Alignment tab displayed. 4 4 Click the Horizontal and then click Center Across Selection. 5 Click OK. 5 • Excel centers the text across the selected cells. Is there an easier way to center text across multiple columns? Yes, although it does require you to merge the selected cells into a single cell. (See Chapter 3 to learn more about merging cells.) Follow Steps 1 and 2 and then, in the Alignment group, click the Merge & Center button ( ). Excel merges the selected cells into a single cell and centers the text within that cell. 87 07_577639-ch05.indd 87 3/15/10 2:42 PM Rotate Text Within a Cell You can add visual interest to your text by slanting the text upward or downward in the cell. You can also use this technique to make a long column heading take up less horizontal space on the worksheet. Excel offers several predefined rotations, such as Angle Counterclockwise, which angles text upward at a 45-degree angle; or Rotate Text Up, which displays the text vertically with the letters running from the bottom of the cell to the top. You can also make cell text angle upward or downward by specifying the degrees of rotation. Rotate Text Within a Cell 1 Select the range containing 2 the text you want to angle. 3 2 Click the Home tab. 3 Click Orientation ( ). • If you want to use a predefined orientation, click one of the menu items and skip the rest of the steps. 1 4 4 Click Format Cell Alignment. The Format Cells dialog box appears with the Alignment tab displayed. 5 5 Click an orientation marker. • You can also use the Degrees spin box to type or click a degree of rotation. (See the Tip on the following page.) 88 07_577639-ch05.indd 88 3/15/10 2:42 PM 5 CHAPTER Formatting Excel Ranges • You can click the vertical text area to display your text vertically instead of horizontally in the cell. 6 Click OK. 6 • • • Excel rotates the cell text. The row height automatically increases to contain the slanted text. You can reduce the column width to free up space and make your cells more presentable. How does the Degrees spin box work? If you use the Degrees spin box to set the text orientation, you can set the text orientation to a positive number, such as 25, and Excel angles the text in an upward direction. If you set the text orientation to a negative number, such as –40, Excel angles the text in a downward direction. You can specify values in the range from 90 degrees (which is the same as clicking the Rotate Text Up command in the Orientation menu) to –90 degrees (which is the same as clicking the Rotate Text Down command). 89 07_577639-ch05.indd 89 3/15/10 2:42 PM
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.