Page 71 - C_GPT _V4 _class_5
P. 71

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  69
   66   67   68   69   70   71   72   73   74   75   76