Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 71 - 2610_Springdales_C-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 |