DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A page break
|
|
|
The Wide margin setting
|
|
|
Scale to Fit
|
|
|
Commands in the Sheet Options group on the PAGE LAYOUT tab
|
Detailed explanation-1: -Select Fit to under Scaling. To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes. Note: Excel will shrink your data to fit on the number of pages specified. You can also adjust the Fit to numbers to print to multiple pages.
Detailed explanation-2: -Print a sheet to page width On the Layout tab, under Print, select the Fit To check box. In the page(s) wide box, enter 1 (for one-page wide). In the page(s) tall box, enter 0 so that the number of pages tall is unspecified. On the File menu, click Print.
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.
Detailed explanation-4: -On the worksheet, click and drag to select the cells you want to print. Select File > Print > Print. To print only the selected area, in Print Options, select Current Selection. If the print preview shows what you want printed, select Print.
Detailed explanation-5: -Click the sheet. On the Page Layout tab, in the Page Setup group, click Page Setup. Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat. Click OK.