Page 67 - 2422_C5_Flipbook
P. 67
Selecting Multiple Cells
To select a group of cells which are not next to each other, click on
the first cell. Now, keeping the Ctrl key pressed click on the other
cells to select. All the selected cells will be highlighted.
Selecting the Whole Worksheet
To select the whole worksheet, click the Select All triangle. This
button is present above row 1.
Select All
Tech Hint
To select the entire
worksheet: Ctrl + A
Let’s CatCh uP
Short answer question.
1. What is the shortcut to select the whole worksheet? ___________________
2. Which key is used to select a range of cells? ___________________
3. Which key is used to select the multiple cells? ___________________
ENTERING DATE AND TIME
When you enter time in a cell in Excel, it looks for the hours, minutes, seconds and am/pm.
So, the default time format is hours : minutes : seconds AM/PM. For example, 10:28:35 AM,
8:15:00 PM, 10:28 AM, 8 PM, etc. Excel recognises all the formats given
in the examples here. Similarly, when you enter date, e.g. 10/4, Excel
recognises it as date and displays 10-Apr in the cell.
To change the format of date or time you entered, follow these steps:
Step 1: Select the cell where you want to edit the date or time.
Step 2: Click on Home tab.
Step 3: Click on the Number format dialog box launcher.
Step 4: A Format Cells dialog box appears. Select Date option in the Category section. A list
of formats is displayed.
Editing Cell Contents in Excel 2016 65

