DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Review
|
|
Insert
|
|
Page Layout
|
|
Home
|
Detailed explanation-1: -If your worksheet has a lot of columns, you can use the Scale to Fit options to reduce the size of the worksheet to better fit the printed page. Follow these steps: 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.
Detailed explanation-2: -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.
Detailed explanation-3: -Set Print Margins Click the Page Layout tab. Click the Margins button. Select the margin size you want to use from the list. If you don’t see a margin size that works, select Custom Margins to display the Page Setup dialog box.