You can customize the look of the worksheet by applying a different color to the gridlines. You can change the gridline for a single worksheet or you can select multiple worksheets and change the gridlines color at the same time. To select multiple worksheets do the following:
Selecting all worksheets: Right click on the sheet tab and click Select All Sheets.
Selecting adjacent worksheets: Click on a sheet tab and then press the Shift key. Keep the Shift key in pressed state, click to select the last worksheet.
Selecting non-adjacent worksheets: Click on a sheet tab and then press the Ctrl key. Keep the Ctrl key in pressed state, click to select other worksheets.
Once the selection of the worksheet(s) is over, perform the following steps to change the gridline color:
1. Open Microsoft Excel.
2. Click the Microsoft Office Button
and click Excel Options.
3. From the Excel Options dialog box, click Advanced from the left pane.
4. From the right pane, scroll the list. Under Display options for this worksheet: make sure that the Show gridlines is checked. Click the Gridline color box and select a color.
5. Click OK.
Selecting all worksheets: Right click on the sheet tab and click Select All Sheets.
Selecting adjacent worksheets: Click on a sheet tab and then press the Shift key. Keep the Shift key in pressed state, click to select the last worksheet.
Selecting non-adjacent worksheets: Click on a sheet tab and then press the Ctrl key. Keep the Ctrl key in pressed state, click to select other worksheets.
1. Open Microsoft Excel.
2. Click the Microsoft Office Button
and click Excel Options.3. From the Excel Options dialog box, click Advanced from the left pane.
4. From the right pane, scroll the list. Under Display options for this worksheet: make sure that the Show gridlines is checked. Click the Gridline color box and select a color.
5. Click OK.
0 comments:
Post a Comment