Đang chuẩn bị liên kết để tải về tài liệu:
Excel 2010 part 10

Thêm một màu nền cho một Range Bạn có thể làm cho một phạm vi đứng ra khỏi phần còn lại của bảng tính bằng cách áp dụng một màu nền cho dãy núi này. Ví dụ, nhiều người áp dụng một màu nền cho các nhãn trong phạm vi một, mà làm cho nó dễ dàng hơn để phân biệt các nhãn từ các dữ liệu. | Add a Background Color to a Range You can make a range stand out from the rest of the worksheet by applying a background color to the range. For example many people apply a background color to the labels in a range which makes it easier to differentiate the labels from the data. Perhaps the easiest way to change the background color is by applying a color from the set of 60 predefined colors that come with the workbook s theme. You can also choose a color from Excel s palette of standard colors or from a custom color that you create yourself. Add a Background Color to a Range Select a Theme or Standard Color 1 Select the range you want to format. 2 Click the Home tab. 3 Click in the Fill Color list . 4 Click a theme color. Alternatively click one of Excel s standard colors. Excel applies the color to the range text. To remove the background color from the range click No Fill. 9 5 CHAPTER Formatting Excel Ranges Select a Custom Color 1 Select the range you want to format. 2 Click the Home tab. 3 Click in the Fill Color list . 4 Click More Colors. The Colors dialog box appears. 5 Click the color you want to use. 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. Are there any pitfalls to watch out for when I apply background colors Yes. The biggest pitfall is applying a background color that clashes with the range text. For example the default text color is black so if you apply any dark background color the text will be very difficult to read. Always use either a light background color with darkcolored text or a dark background color with light-colored text. Can I apply a background that fades from one color to another Yes. This is called a gradient effect. Select the range click the Home tab and then click the Font group s dialog box launcher Q . Click the Fill tab and then click Fill Effects. In the Fill Effects