DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Insert Sheet Column
|
|
|
Insert Sheet
|
|
|
Borders
|
|
|
Row Height
|
|
|
Column Width
|
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: -Select one or more columns that you wish to resize. To select all columns, press Ctrl + A or click the Select All button. On the Home tab, in the Cells group, click Format > Column Width. In the Column width box, type the desired number, and click OK.
Detailed explanation-3: -Select Format > Column > Width to display the Column Width dialog box, shown below.
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.