Áp dụng một style cho một Range Bạn có thể làm giảm thời gian cần để định dạng bảng tính của mình bằng cách áp dụng phong cách của Excel được xác định trước để các phạm vi của bạn. Excel đi kèm với hơn 20 phong cách được định nghĩa trước cho các thành phần bảng tính khác nhau như tiêu đề, cũng như hai phong cách chục liên kết với các chủ đề tài liệu hiện hành. | Apply a Style to a Range You can reduce the time it takes to format your worksheets by applying Excel s predefined styles to your ranges. Excel comes with more than 20 predefined styles for different worksheet elements such as headings as well as two dozen styles associated with the current document theme. Each style includes the number format cell alignment font typeface and size border and fill color. Apply a Style to a Range _ 1 Select the range you want to format. 2 Click the Home tab. 3 Click Cell Styles. CHAPTER Formatting Excel Ranges 5 t 4 1W mi pin mû rCk Excel displays the Cell Styles gallery. 4 Click the style you want to apply. Note If the style is not exactly the way you want you can rightclick the style click Modify and then click Format to customize the style. Excel applies the style to the range. Are there styles I can use to format tabular data Can I create my own style Yes. This is useful if you find yourself Yes. Excel comes with a gallery of table styles that offer formatting options that highlight the first row apply different formats to alternating rows and so on. Select the range that includes your data click the Home tab and then click Format as Table. In the gallery that appears click the table format you want to apply. applying the same set of formatting options over and over. By saving those options as a custom style you can apply it by following Steps 1 to 4. Apply your formatting to a cell or range and then select that cell or range. Click Home click Cell Styles and then click New Cell Style. In the Style dialog box type a name for your style and then click OK. Change the Column Width You can make a column of data easier to read by adjusting the column width. For example if you have a large number or a long line of text in a cell Excel may display only part of the cell value. To avoid this you can increase the width of the column. Similarly if a column only contains a few characters in each cell you can decrease the width to fit
