DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
In Print Preview
|
|
|
On the Home tab in the Cells group
|
|
|
On the PAGE LAYOUT tab, in the sheet options group
|
|
|
On the PAGE LAYOUT tab in the Page Setup Group
|
Detailed explanation-1: -On the Page Layout tab, in the Sheet Options group, select the Print check box under Gridlines.
Detailed explanation-2: -Select the worksheet. Click the Page Layout tab. To show gridlines: Under Gridlines, select the View check box.
Detailed explanation-3: -To print gridlines in a worksheet, on the PAGE LAYOUT tab, under Gridlines, check Print . Now when you print the worksheet, the gridlines are printed and it is easier to read. You can print row and column headings. This is 1, 2, 3 and so-on for rows and A, B, C, and so on for columns.
Detailed explanation-4: -Alternatively, you can go to the Sheet Options group on the PAGE LAYOUT tab and select the View checkbox under Gridlines.
Detailed explanation-5: -Click the Page Layout tab to expand the page layout commands and then go to the Gridlines section.