Page 34 - ModularV1.1 _c6_flipbook
P. 34

Step 2  Click on  the  arrow  of  the  Merge &
                          Center  command in the  Alignment
                          group under the Home tab.

                  Step 3  Select the  Unmerge Cells option.
                          The cells  will split  and the contents
                          of the merged  cell will appear  in
                          the upper-left cell  of the range  of
                          split cells.                                                 Splitting cells
                      AUTOFILL

                  AutoFill feature automatically fills a series of data in your worksheet. It saves your time to complete
                  the text or number series. To use the AutoFill feature, follow these steps:

                  Step 1  Enter the first two numbers you want to start the series with.
                  Step 2  Select both the cells containing the numbers you have entered.
                  Step 3  Position the mouse pointer over the bottom right corner of the last selected cell. The
                          pointer changes to (+) sign.
                  Step 4  Drag the mouse pointer over the cells you want to include in the series. The cells display
                          the number series automatically.









                                 Starting AutoFill          Using AutoFill          Series after using AutoFill
                      CUSTOMISE WORKSHEET TAB

                  To customise the worksheet tab, follow these steps:
                  Step 1  On the Worksheet tab bar, right-click the sheet tab that you

                          want to customise.
                  Step 2  Click Rename to rename the sheet or Tab Color to select a tab
                          colour or Delete to delete the sheet.
                  Step 3  Type in the name or select a colour you would like for your

                          spreadsheet. The information will be added to the tab at the
                          bottom of the spreadsheet.                                         Customising Worksheet tab

                     Recap


                          The contents of a cell can be moved or copied to other cells.
                          Row height and column width can be changed.

                          You can specify column width of 0 to 255 and row height of 0 to 409.
                          Two or more cells can be merged into one cell.
                          AutoFill feature automatically fills a series of data in your worksheet.




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