Page 49 - 2617_JSSPS_C-5

Using the Mouse
To select a range of cells using a mouse: First click in the
top left cell and drag to the bottom right cell. The range gets
selected. All the selected cells get highlighted. Only the active
cell is not highlighted.

Using the Keyboard
You can also select a range by clicking the top left cell. Then
keeping the Shift key pressed while using the arrow keys to
reach the bottom right cell of the desired range. The range
will be selected.

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.

What if you could use Excel to track the books you’ve read and the books you want to
read? How would you rate them and what genres would you include?

Selecting the Whole Worksheet

To select the whole worksheet, click the Select All triangle.
This button is present above row 1.

Hintbot

To select the entire
worksheet: Ctrl + A

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.

Introduction & Editing in Excel 47