USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Ensure that row and column headings and gridlines display when printing the worksheet. How do you do this?
|
|
page layout tab, sheet options group, check print gridlines, check print headings
|
|
|
view tab, show group, check gridlines
|
|
|
file, print, page setup, sheet tab, check gridlines
|
|
|
you aren’t able to do this
|
Explanation:
Detailed explanation-1: -On the Ribbon, click the Page Layout tab. In the Sheet Options group, under Headings, select the Print check box., and then under Print, select the Row and column headings check box . To print the worksheet, press CTRL+P to open the Print dialog box, and then click OK.
Detailed explanation-2: -On the screen, by default, the worksheet’s pages have gridlines, making it easier to read across rows and down columns. But when you print, by default, the gridlines are not printed. To print gridlines in a worksheet, on the PAGE LAYOUT tab, under Gridlines, check Print .
There is 1 question to complete.