DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
between the column letter you want to widen and the column letter to the right
|
|
|
over any cell in that column
|
|
|
over the function icon bar
|
|
|
between the column letter you want to widen and the row it corresponds with
|
Detailed explanation-1: -To change the width of columns to fit the contents, select the column or columns that you want to change, and then double-click the boundary to the right of a selected column heading. To change the width of all columns on the worksheet, click the Select All button, and then drag the boundary of any column heading.
Detailed explanation-2: -AutoFit columns and rows with a double-click The easiest way to auto fit in Excel is by double-clicking the column or row border: To autofit one column, position the mouse pointer over the right border of the column heading until the double-headed arrow appears, and then double click the border.
Detailed explanation-3: -To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same number of columns to the right of where you want to add new ones. Right-click the selection, and then select Insert Columns.