DATABASE FUNDAMENTALS
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: -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.
Detailed explanation-3: -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.