By default, Excel 2007 displays lines around cells. These lines are called gridlines. You can select a single worksheet to make the gridlines visible or hidden (or) you can select multiple sheets and make the gridlines visible or hidden 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.
Or
Selecting adjacent worksheets: Click on a worksheet and then press the Shift key. Keep the Shift key in pressed state, click to select the last worksheet.
Or
Selecting non-adjacent worksheets: Click on a worksheet 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 hide the gridlines:
1. Open the workbook and click on the worksheet(s).
2. Click View tab. In the Show/Hide group, click to clear the checkmark besides Gridlines.
You can also hide the gridlines from the Excel Options dialog box. The steps are:
1. Click the Microsoft Office Button
and click Excel Options.
2. From the Excel Options dialog box, click Advanced from the left pane.
3. From the right pane, scroll down to the Display options for this worksheet section and click to remove the checkmark besides Show gridlines.
4. Click OK.
To show the gridlines click the View tab, in the Show/Hide group click to place the checkmark besides Gridlines.
Selecting all worksheets: Right click on the sheet tab and click Select All Sheets.
Or
Selecting adjacent worksheets: Click on a worksheet and then press the Shift key. Keep the Shift key in pressed state, click to select the last worksheet.
Or
Selecting non-adjacent worksheets: Click on a worksheet and then press the Ctrl key. Keep the Ctrl key in pressed state, click to select other worksheets.
1. Open the workbook and click on the worksheet(s).
2. Click View tab. In the Show/Hide group, click to clear the checkmark besides Gridlines.
You can also hide the gridlines from the Excel Options dialog box. The steps are:
1. Click the Microsoft Office Button
and click Excel Options.2. From the Excel Options dialog box, click Advanced from the left pane.
3. From the right pane, scroll down to the Display options for this worksheet section and click to remove the checkmark besides Show gridlines.
4. Click OK.
To show the gridlines click the View tab, in the Show/Hide group click to place the checkmark besides Gridlines.
0 comments:
Post a Comment