USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Page Layout Tab
|
|
|
Page Setup
|
|
|
Scale to Fit
|
|
|
Sheet Options
|
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.
Detailed explanation-2: -On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Column Width. Note: To quickly autofit all columns on the worksheet, click the Select All button, and then double-click any boundary between two column headings.
Detailed explanation-3: -Select a column or a range of columns. On the Home tab, select Format > Column Width (or Column Height). Type the column width and select OK.
Detailed explanation-4: -Column properties First, click in the column or select the columns you want to change, right-click, choose Table Properties, and then click the Column tab. Under Size, set the column’s width by selecting Preferred width and choosing a size.