Working with Microsoft Office Excel 2003, Things You Need To Know

Working With Microsoft Office Excel 2003

There are some basic things that you need to know in order to be able to work efficiently with Microsoft Office Excel. Though we are working with Excel 2003, some features will still apply to Microsoft Excel versions 2007, 2010, 2013, and even 2016. Most will also work on open source Excel programs.

Re-naming a Worksheet

You can rename a worksheet to make it have a more customized name instead of the normal sheet 1, 2. For instance, Jan Sales, to indicate January sales. The process is:-

  • Double click on the worksheet tab you want to rename and then type the new name or,
  • Right click on the sheet tab then selecct rename and type the new name.

Excel 2003 Window

Excel 2003 Window
Excel 2003 Window | Source

How to Copy or Move a Worksheet

  • Click on edit
  • Click on move or copy worksheet
  • Indicate the new position and whether you want to make a copy or move the whole worksheet
  • Click OK

How to Insert a Worksheet in Excel 2003

You can insert a new worksheet by following this procedure:-

  • Click on insert then worksheet or
  • Right click on one of the sheet tabs and select insert > worksheet

Excel 2003 Worksheet

Working With Excel 2003
Working With Excel 2003 | Source

How to Delete a Worksheet in Microsoft Excel 2003

NB: This change is not reversible

a) Click on edit then delete sheet or

b) Right click on the sheet you want to delete and select delete

Copying and Pasting Data in Microsoft Excel 2003

  • Select the data to be copied
  • Click on edit then copy or use short cut keys (Ctrl + C)
  • Click on the destination where you want your work to start (the first cell)
  • Click on edit
  • Click on paste or short cut (Ctrl + V)

Moving Data

  1. Select the data to be moved
  2. Click on edit then cut (Ctrl + X)
  3. Click on the destination
  4. Click on edit then paste (Ctrl + V) or
  5. Highlight the data, move the pointer to the bold outline of the selected text, once the pointer turns to a move point, click, hold on and drag to the required destination.

Data Entry

There are three main types of data that you can enter in a worksheet.

  • Labels – the text you type on a worksheet.
  • Values – these are values or figures that you enter on your work sheet.
  • Formula – these are the formulas that are used to come up solutions to computations for instance =sum(bl:b8).

Performing Calculations in Excel 2003

Calculations in Excel 2003
Calculations in Excel 2003 | Source

Other Types of Entries Include the Following:

Pictures

  • Click on insert
  • Point to picture
  • Select the source
  • Select the picture
  • Click on insert or OK

Comments

  • Click on the cell you want your comment to appear
  • Click on insert
  • Point to comments and click
  • Type in the comments

NB: Comments are details which are hidden within the cell and only appears when that cell is selected or pointed. To view your comment, you can point to the triangle at the top right hand corner of the cell.

Adding and Removing Worksheet Parts in Excel 2003

a) To insert a column

Click on insert then column

b) To insert a row

Click on insert then rows

c) To insert a cell

Click on insert then cells and then indicate the direction of the cells and click OK.

Deleting selected Cells

a) Click on edit then delete

b) Indicate the direction of cells then click OK

How to Delete Rows and Columns

a) Click on edit then delete

b) Indicate whether to delete the whole row or whole column

c) Click OK

Adding and removing tool bars

  • Click on view, point to tool bars
  • Click on the toolbar that you would like to add or remove

Adding or Removing Formula Bar and Status Bar

  • Click on view
  • Point to status/formula bar and click

Hiding rows

To hide a row

1. Click on format

2. Point to row

3. Click hide

This will hide the selected row

To unhide a column or row

Use the go to command in the edit menu so that the cell selector is located in one of the cell in the row or column then click on format, point to the row or column then click on unhide.

Adjusting Row Height in Excel 2003

  • Highlight the row or rows
  • Click format
  • Point to row
  • Click on row height
  • Adjust the height by keying in the points for adjusting the row height
  • Click OK

You can adjust a row height by pointing in between the row header and clicking and holding down the mouse pointer and dragging.

You can adjust row height by clicking on format then point to row then click on autofit selection.

How to Hide and Unhide Worksheet in Excel 2003

Follow this procedure:

  • Click on format
  • Select sheet and click on hide

To unhide a sheet

  • Click on format, point to sheet
  • Click on unhide, then select the sheet to unhide
  • Click OK

Spreadsheet Programs

Which Spreadsheet Program are you using at the moment?

See results without voting

© 2012 Patrick Kamau

More by this Author


Comments 2 comments

Patkay profile image

Patkay 4 years ago from Nairobi, Kenya Author

Thanks lucy patrick for reading and commenting. I am glad you liked it.


lucy patrick 4 years ago

good work patkay.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working