DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
click the bottom of row border
|
|
|
click the top of row border
|
|
|
double click the bottom of row border
|
|
|
double click the top of row border
|
Detailed explanation-1: -On the Home tab, in the Cells group, click Format > AutoFit Row Height: Tip. To auto fit all rows on the sheet, press Ctrl + A or click the Select All button, and then either double click the boundary between any two row headings or click Format > AutoFit Row Height on the ribbon.
Detailed explanation-2: -AutoFit columns and rows with a double-click To autofit one row, hover the mouse pointer over the lower boundary of the row heading, and double click the border. To autofit multiple columns / multiple rows, select them, and double click a boundary between any two column / row headings in the selection.
Detailed explanation-3: -Change row height 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-4: -AutoFit is a feature in Excel that allows you to quickly adjust the row height or column width to fit the text completely (so that there is no spilling over to other cells). Autofit Row Height: This feature automatically adjusts the row height to fit the text in the cell. You can autofit multiple rows at once.