Page 57 - CloudGPT_C5_Flipbook
P. 57
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.
To change the format of date or time you entered, follow these steps:
Click on Home Select Date option in the
2 4
tab. Category section.
Click on the
Number
format dialog 3
Select the box launcher.
cell where
you want
to edit the Choose the
date or format you 5
1
time. want.
Click on OK 6
button.
Hintbot
To apply the default date format: Ctrl + Shift + #
To apply the default time format: Ctrl + Shift + @
Editing Cell Contents in Excel 2019 55

