USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Wrapping Text
|
|
|
Adjusting Column Height
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -In Excel worksheets, the default row height is determined by the font size. As you increase or decrease the font size for a specific row(s), Excel automatically makes the row taller or shorter.
Detailed explanation-2: -Now, Excel should also automatically adjust the row height to make all of the wrapped cell content visible. If it does not-it’s because you have manually adjusted the row height (or the column width) yourself at some point. That sort of disengages the auto Wrap Text. NOTE: You can often toggle the auto text back on.
Detailed explanation-3: -Wrapping the text will automatically modify a cell’s row height, allowing cell contents to be displayed on multiple lines. Merging allows you to combine a cell with adjacent empty cells to create one large cell.
Detailed explanation-4: -Change the row height to fit the contents On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Row Height. Tip: To quickly autofit all rows on the worksheet, click the Select All button, and then double-click the boundary below one of the row headings.