USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the techniques described below can be used to resize a column in Excel?
|
Double-click column border
|
|
Drag column border
|
|
Right-click for Column Width
|
|
All of the above.
|
Explanation:
Detailed explanation-1: -Select the column or columns that you want to change. 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-2: -To AutoFit column width: Alt + H, then O, and then I. To AutoFit row height: Alt + H, then O, and then A.
There is 1 question to complete.