Page 37 - modular4.0
P. 37

Chapter Profile
                                Tech Funda




                     Similar to MS Word, Excel 2019 also allow us to use shortcut keys to copy, cut and paste the

                     content of the cells. The shortcut keys are:
                        To Copy: Ctrl + C    To Cut: Ctrl + X    To Paste: Ctrl + V



                        USING UNDO AND REDO FEATURES


                 Similar to MS Word, Excel 2019 also allows you to use the Undo and Redo commands. The Undo
                 command is used to reverse the previous action that you have performed in the worksheet. With
                 the help of this command, you can reverse more than one actions. On the other hand the Redo
                 command is used to reverse the last Undo command. The
                 Redo button only appears after you've undone an action.
                 You can access both the commands from the Quick Access
                 Toolbar located  at the  top-left  corner of the  Excel 2019
                 window. You can also use the Ctrl + Z key and Ctrl + Y key
                 to Undo and Redo respectively.


                        COLUMN WIDTH AND ROW HEIGHT


                 On a worksheet, you can specify a column width ranging from 0 to 255 and a row height ranging
                 from 0 to 409. These values represents the number of characters that can be displayed in a cell that
                 is formatted with the standard font. The default column width is 8.43 characters, and the default
                 row height is 15 points. If a column/row has a width or height 0, it becomes hidden, meaning it is
                 not visible in the worksheet grid.

                 Set Column Width/Row Height

                 To set column width or row height, follow the given steps:

                  2  Click on Home tab.                   3  Click on Format command.







                                                                                                 4  Choose  Column
                                                                                                Width or Row Height.












                     1  Select the column(s) or row(s) whose width or height you want to change.




                                                                                                 Editing in Excel 2019  35
   32   33   34   35   36   37   38   39   40   41   42