Alignment & Formatting

  • Inserting Data

    To insert data into a cell simply select it (i.e. make it active) and enter your information. Excel has a useful auto entry function that enables you to simply drag from the bottom right-hand corner of a cell to populate cells in any direction. After a few entries, Excel is often capable of deciphering the pattern that you are creating and can fill in remaining cells based on the pattern. To test this feature, start by typing a sequence of numbers and then highlight those cells and drag downward from the bottom right-hand corner of the last cell you entered data into.

  • Inserting Formulas & Functions

    Functions always begin with an = sign. You can insert functions just like you are entering text or numbers and when you press enter, the result of your function will appear.

  • Inserting Columns

    You can insert columns into a worksheet by:

    1. Right clicking, and
    2. Selecting Insert from the menu.

    Or by...

    1. Clicking on the Insert tab, and
    2. Selecting Columns

  • Inserting Rows

    You can insert rows into a worksheet by:

    1. Right clicking, and
    2. Selecting Insert from the menu.

    Or by

    1. Clicking on the Insert tab, and
    2. Selecting Rows

  • Copying Data

    To copy data in cells

    1. Select one or more cells
    2. Select Edit in the menu
    3. Select Copy

  • Formatting Cells

    To format cells

    1. Select Format in the menu
    2. Select Cells...

    There are a number of different format options in Excel. For example, you may want to specify how numbers in a given cell should appear.

    You may also need to align data within a cell. For example, you can adjust the horizontal and vertical alignment and/or make the characters within a cell wrap to fit a particular cell size.

    This shows how a cell with Wrap Text selected will appear.

    You have numerous options available in the Formatting Toolbar to adjust the appearance of you spreadsheet.

    To add/remove borders in your spreadsheet, you can use the Borders Button.

Source:ischool.utexas.edu

0 comments:

Post a Comment

Custom Search