DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Insert Cells
|
|
Insert Sheet Rows
|
|
Insert Sheet Column
|
|
Insert Sheet
|
|
Insert Name
|
Detailed explanation-1: -Shortcuts to insert blank rows in Excel Select the necessary number of rows where the blank lines will appear by picking the corresponding cells and pressing Shift + Space.
Detailed explanation-2: -To insert a new worksheet in front of an existing worksheet, select that worksheet and then, on the Home tab, in the Cells group, click Insert, and then click Insert Sheet. Tip: You can also right-click the tab of an existing worksheet, and then click Insert. On the General tab, click Worksheet, and then click OK.
Detailed explanation-3: -Under Table Tools, on the Layout tab, do one of the following: To add a row above the cell, click Insert Above in the Rows and Columns group. To add a row below the cell, click Insert Below in the Rows and Columns group.