FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of these methods can you use to set the width of a row in a worksheet? (2 answers)
A
Select FORMAT in the CELLS group and select AUTOFIT ROW HEIGHT
B
Right-click on a row header and select COLUMN HEIGHT
C
None
D
Both answer choices
Explanation: 

Detailed explanation-1: -Resize rows Select a row or a range of rows. On the Home tab, select Format > Row Width (or Row Height). Type the row width and select OK.

Detailed explanation-2: -Select the row you want to adjust the height. In Microsoft Office Excel 2003 and in earlier versions of Excel, point to Row on the Format menu, and then click AutoFit. In Microsoft Office Excel 2007 and later versions, click the Home tab, click Formatin the Cells group, and then click AutoFit Row Height.

Detailed explanation-3: -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.

There is 1 question to complete.
Previous
Next