USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Adjust text orientation.
|
|
|
Use the Center alignment command.
|
|
|
Use the Merge & Center command.
|
|
|
Apply a special character attribute.
|
Detailed explanation-1: -Wrap text automatically In a worksheet, select the cells that you want to format. On the Home tab, in the Alignment group, click Wrap Text. (On Excel for desktop, you can also select the cell, and then press Alt + H + W.)
Detailed explanation-2: -Merge multiple cells. If you wish to make a cell bigger without impacting the entire row or column, one option is to merge multiple cells. When you merge cells, you combine two or more cells into one that spans across multiple rows or columns.
Detailed explanation-3: -To change the width of columns to fit the contents, select the column or columns that you want to change, and then double-click the boundary to the right of a selected column heading. To change the width of all columns on the worksheet, click the Select All button, and then drag the boundary of any column heading.
Detailed explanation-4: -To AutoFit column width: The AutoFit feature will allow you to set a column’s width to fit its content automatically. Position the mouse over the column line in the column heading so the cursor becomes a double arrow. Double-click the mouse. The column width will be changed automatically to fit the content.