USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Select Edit > Select > Column from the menu
|
|
|
Click the column heading letter
|
|
|
Hold down the shift key as you click anywhere in the column.
|
|
|
Hold down the Ctrl key as you click anywhere in the column
|
Detailed explanation-1: -Select the letter at the top to select the entire column. Or click on any cell in the column and then press Ctrl + Space. Select the row number to select the entire row. Or click on any cell in the row and then press Shift + Space.
Detailed explanation-2: -To select an entire column, click the column letter or press Ctrl+spacebar.
Detailed explanation-3: -You can also click anywhere in the table column, and then press CTRL+SPACEBAR, or you can click the first cell in the table column, and then press CTRL+SHIFT+DOWN ARROW. Note: Pressing CTRL+SPACEBAR once selects the table column data; pressing CTRL+SPACEBAR twice selects the entire table column.
Detailed explanation-4: -’Ctrl+space’ keys can select an entire column in a worksheet.
Detailed explanation-5: -Hold the Shift key and then press the Spacebar key. You will again see that it gets selected and highlighted in gray. In case you want to select multiple contiguous rows, select multiple adjacent cells in the same column and then use the keyboard shortcut.