Excel Basics
Computing Resources >> Tutorials >> Office Suite >> Excel Basics  

Overview

Basics

Navigating in Excel

Data Types

Sorting Data

Alignment & Formatting

Importing & Printing

Functions

Charts & Graphs

Evaluate this tutorial

 

Alignment & Formatting

Alignment & Formatting

screen shot

  • 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.

    screen shot

  • 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.

    screen shot

  • Inserting Columns

    You can insert columns into a worksheet by:

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

    screen shot

    Or by...

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

    screen shot

  • Inserting Rows

    You can insert rows into a worksheet by:

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

    screen shot

    Or by

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

    screen shot

  • Copying Data

    To copy data in cells

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

    screen shot

  • Formatting Cells

    To format cells

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

    screen shot

    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.

    screen shot

    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.

    screen shot

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

    screen shot

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

    screen shot

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

    screen shot

next section >

 

Watch the video
screenshot
choose format/speed
real media dial-up | broadband

html transcript

© 2004 Sam Burns | iSchool | UT Austin | webmaster