Page 68 - iPrime_V2.2_class7
P. 68

Tech Funda



                         Similar to Word, Excel 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 Word, Excel also allows you to use the Undo and Redo commands. The Undo command
                  reverses the most recent action you performed in the worksheet and can undo multiple actions
                  sequentially. Conversely, the Redo command reverses the last action that was undone. Both
                  commands can be accessed from the Quick Access Toolbar located at the top-left corner of the

                  Excel window. You can also use the Ctrl + Z key and Ctrl + Y key to Undo and Redo respectively.

                      COLUMN WIDTH AND ROW HEIGHT

                  In a worksheet, you can set a column width ranging from 0 to 255 characters and a row height
                  from  0  to  409.5 points.  The  column width  represents the  number  of  characters  that  can  be

                  displayed in a cell using the default font size. The default column width is 8.43 characters, and
                  the default row height is 15 points. If a column or row is set to a width or height of 0, it becomes
                  hidden and will not be visible in the worksheet grid.
                  Set Column Width/Row Height


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

                  Step 3   Select the Column Width or Row Height under the Cell Size
                          section from the drop-down list.

                  A Column width or Row height dialog box will appear.
                  Step 4  Type the desired value in the Column Width or Row Height
                          text box.









                                                                                                   Setting column width
                                  Row Height dialog box         Column Width dialog box

                  66     Touchpad iPRIME (Ver. 2.2)–VII
   63   64   65   66   67   68   69   70   71   72   73