USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Enter
|
|
|
Tab
|
|
|
Shift
|
|
|
Ctrl
|
Detailed explanation-1: -For example, if you want to select cells A1 through E1, left-click the A1 cell, press and hold Shift, then click the E1 cell.
Detailed explanation-2: -You can also select cells in a row or column by selecting the first cell and then pressing CTRL+SHIFT+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns). Note: If the row or column contains data, CTRL+SHIFT+ARROW key selects the row or column to the last used cell.
Detailed explanation-3: -This means that a simple cell reference, used within an Excel cell, will be adjusted when copied to other cells. For example, in the spreadsheet below, cell A1 contains a reference to cell E1. The spreadsheet on the right shows the result of cell A1 being copied to cells A1-C3.
Detailed explanation-4: -Hold down the Ctrl key, and left-click each cell or range you want to include.