DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Format, wide, height
|
|
|
Format, row, height
|
|
|
Format, coloum, autoselection
|
|
|
Format, row, autoselection
|
Detailed explanation-1: -To set the row height to a specific measurement, click a cell in the row that you want to resize. On the Layout tab, in the Cell Size group, click in the Table Row Height box, and then specify the height you want. To use the ruler, select a cell in the table, and then drag the markers on the ruler.
Detailed explanation-2: -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-3: -Once the row or rows are selected, press Alt+O, then R (the shortcut for “Row Height"). Excel will display the Row Height dialog box. From here, you can either enter a specific row height or use the up and down arrow keys to adjust the row height incrementally. When you’re done, press Enter or click on the OK button.