DATABASE FUNDAMENTALS
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, select one, several or all columns on the sheet, go to the Home tab > Cells group, and click Format > AutoFit Column Width. To AutoFit row height, select the row(s) of interest, go to the Home tab > Cells group, and click Format > AutoFit Row Height.