Page 32 - ModularV1.1 _c6_flipbook
P. 32

Tech



                      Funda           Similar to MS Word, MS 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 MS Word, MS Excel 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 action. On the other hand, the Redo
                  command is used to reverse the the last Undo. You can access both the commands from the
                  Quick Access Toolbar located at the top-left corner of the MS Excel 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 are 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 these steps:
                  Step 1  Select the column(s) or row(s) whose width or height is to be changed.
                  Step 2  Click on Format command in Cells group from Home tab.

                  Step 3   Choose 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  In the Column Width or Row Height box, type the value that you

                          want your column width or row height to be.







                            Row Height dialog box        Column Width dialog box                    Setting column width
                  Automatically Fit Column/Row Content

                  To set column width or row height automatically, follow these steps:         Select All button
                  Step 1  Click the Select All button.

                  Step 2  Double-click any boundary between two column/row headings.
                  Step 3  All columns/rows in the entire worksheet will be changed to
                                                                                               Selecting entire worksheet
                          the new size.


                  30      Modular (Ver. 1.1)-VII
   27   28   29   30   31   32   33   34   35   36   37