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

