USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Scaling
|
|
|
Formula
|
|
|
Data
|
|
|
View
|
Detailed explanation-1: -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.
Detailed explanation-2: -On the Page Layout tab, select Page Setup. Under Scaling, select Fit to, and type 1 in both the page(s) wide box and page(s) tall box. Select OK.
Detailed explanation-3: -Click on Fit under the Scaling in the Page tab in the dialog box. You have to choose 1 in both the boxes that are next to the Fit to option. Excel will shrink all the data into one page, and you will click on the OK button to save the setting.
Detailed explanation-4: -Excel’s AutoFit feature is designed to automatically resize cells in a worksheet to accommodate different sized data without having to manually change the column width and row height. AutoFit Column Width-changes the column width to hold the largest value in the column.