tailieunhanh - Office 2010 visual quick tips phần 5

Gridlines là một yếu tố thiết yếu của tất cả các bảng tính Excel bạn hiển thị. Gridlines là chìa khóa để giúp bạn duy trì trật tự và giữ nhiệm vụ nhập dữ liệu của bạn tổ chức và dễ dàng để thực hiện. Gridlines giúp bạn giữ cho nội dung của bạn xếp hàng đúng trong các tế bào của mình. | Change Gridline I Color Gridlines are an essential element of every Excel worksheet you display. Gridlines are key to helping you maintain order and keeping your data-entry tasks organized and easy to perform. Gridlines help you keep your contents lined up properly in their respective cells. By default the gridlines appear as faint bluish-gray lines that define column and row borders and the cells contained within. Depending on how busy your worksheet becomes as you enter more and more data it is not always easy to see the gridlines. Thankfully you can customize the worksheet and substitute another color setting for gridlines. You can change the gridline color by accessing the Excel Options dialog box and the Advanced options. If after assigning a new color you prefer to return to the default setting simply revisit the dialog box settings and switch back to Automatic as your color choice for the gridlines. o Click the File tab. 2 Click Options. The Excel Options dialog box appears. 3 Click Advanced. 4 Scroll down to the Display Options for This Worksheet section. 5 Click the Gridline Color button. 6 Click a new color. 7 Click OK. The color is assigned to the current worksheet. 138 _L Print í Gridlines i Gridlines make it easier to read a worksheet. By default gridlines appear on-screen but not in printed versions of your worksheet. If you plan to print your worksheet you might want to set up Excel to print it with the gridlines displayed. Doing so makes the printed worksheet a bit easier to read although be aware that printing with gridlines takes a bit longer than printing without them. You can apply two methods to activate gridline printing. You can click the Print check box changes to n on the Page Layout tab under the Gridlines settings or you can use Chapter 6 Excel s Page Setup dialog box to activate gridline printing. In addition to specifying that gridlines be printed you can also choose other print-related options in Excel in the Page Setup dialog box.