Page 36 - TP_Modular_V2.1_Class7
P. 36

Copying content of a Cell               Pasting content in a cell
                           Tech Funda



                         Similar to MS Word, Excel 2016 also allows 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 2016 also allows 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 or action. You can access both

                  the commands from the Quick Access Toolbar located at the top-left corner of the Excel 2016
                  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 of 0 to 255 and a row height of 0 to 409. This
                  value 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 is hidden, i.e., it is not visible in the grid.
                  Set Column Width/Row Height

                  To set column width or row height, follow the given steps:
                  Step 1  Select the column(s) or row(s) whose width or height you want to change.
                  Step 2  Click on Format command in Cells group from Home tab.



                   34       Modular (Ver. 2.1)-VII
   31   32   33   34   35   36   37   38   39   40   41