USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Print rows/columns
|
|
|
Print area
|
|
|
Print titles
|
|
|
Print headings
|
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 .
Detailed explanation-2: -Click the [Page Layout] tab > In the “Page Setup” group, click [Print Titles]. Under the [Sheet] tab, in the “Rows to repeat at top” field, click the spreadsheet icon. Click and select the row you wish to appear at the top of every page. Press the [Enter] key, then click [OK].
Detailed explanation-3: -Click the Page Layout tab on the ribbon. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic. Columns will now appear on one page, but the rows may extend to more than one page. To print your worksheet on a single page, choose 1 page in the Height box.