Library Reference Resources - Max R. Traurig Library - Naugutuck Valley Community College
Internet Search Guide / LC Classification A-Z / Library Online Tutorials / Research Handouts /

Library Online Tutorials -- MS Office Excel
Here are some Microsoft Office tutorials that we created to assist you in your assignments. Below are a list of instructions for each tutorial along with short video examples.  After each tutorial your browser will redirect you back to the tutorials page.

How to ...?

Solutions!
Add a column or row of numbers in Microsoft Excel.
  1.  Pick the cell where you want to display the sum.
  2. Click "Insert Function" icon.
  3. A dialog box will open with "sum" already chosen.
  4. Click "ok".
  5. In the top box number 1 make sure the cells listed are the ones you want added together.
  6. Click "ok".

Click here to view a video example
Auto-fill a sum formula across several columns or rows.
  1. Highlight the cell with the already established formula.
  2. Click and drag across the cells you want the new sums to appear.  Or you can highlight the cells and choose "edit" then "fill" and choose "right" or "down."

Click here to view a video example
Hide a column in Excel.
  1. Highlight the column you  want to hide.
  2. Choose "Format"
  3. Choose "Column"
  4. Choose "Hide".

Click here to view a video example
Print gridlines on your Excel spreadsheet.
  1. Click "file"
  2. Click "Print Preview"
  3. Click "setup"
  4. Click "sheet"
  5. Check the gridlines box
Click here to view a video example
| NVCC Home | Site Map | Contact US |
Naugatuck Valley Community College Max R. Traurig Library/LRC  NVCC Fall 2007