Page 91 - 2622_Delhi Police Public School_C-5

Selecting a Column Selecting the Whole Worksheet

To select a column, place the mouse pointer on the To select the whole worksheet, click the Select All triangle.
column header of the column. Click on the column This button is present above row 1.

header, the entire column gets selected.
Hintbot

Selecting a Range of Cells To select the entire
worksheet: Ctrl + A
A range is a rectangular section of cells which are next
to each other and at least one side of their border is

common. A range is defined by the cell addresses of ENTERING DATE AND TIME
the top left cell and the bottom right cell with a colon (:) When you enter time in a cell in Excel, it looks for the hours, minutes, seconds and am/pm. So,
in between. For example, the range address is B2:D10. the default time format is hours : minutes : seconds AM/PM. For example, 10:28:35 AM, 8:15:00
B2 is the address of the top left cell. D10 is the address PM, 10:28 AM, 8 PM, etc. Excel recognises all the formats given in the examples here. Similarly,
of the bottom right cell. when you enter date, e.g., 10/4, Excel recognises it as date and displays 10-Apr in the cell.

To edit the contents in a range of cells, you have to select the range. To change the format of date or time you entered, follow these steps:

Using the Mouse Click on Home Select Date option in the
2 4
To select a range of cells using a mouse: First click in the tab. Category section.
top left cell and drag to the bottom right cell. The range gets Click on the
selected. All the selected cells get highlighted. Only the active Number
cell is not highlighted. format dialog 3
Select the box launcher.
Using the Keyboard cell where

You can also select a range by clicking the top left cell. Then you want Choose the
keeping the Shift key pressed while using the arrow keys to to edit the format you 5
date or
reach the bottom right cell of the desired range. The range 1 time. want.
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 OK 6
click on the other cells to select. All the selected cells will be button.

highlighted.

Hintbot

What if you could use Excel to track the books you’ve read and the books you want to To apply the default date format: Ctrl + Shift + #
read? How would you rate them and what genres would you include? To apply the default time format: Ctrl + Shift + @

Editing Cell Contents in Excel 2019 89