Microsoft Excel 2007 for Windows

Outside Links

Mouse Training Reference Sheet for Excel 2007
This is a two page reference sheet from Mouse Training. You may download this pdf by clicking on the link above.

Microsoft tutorials for Excel 2007
The following link is a page of tutorials offered by Microsoft for Excel 2007. These pages are best viewed in Internet Explorer.

Bethel Articles

This page contains helpful links about Excel 2007 concerning the following topics:
--Files & Folders
--Printing
--Worksheet & Cell Options
--Quick Tips

Files & Folders

How do I change my default file format in Excel 2007?
Because many people do not have office 2007 it may be advisable to set the file formats to be compatible with Office 2003.

How do I change the default location for storing and finding my files in Excel 2007?
This article explains how to change where your documents are saved and opened by default.

Printing

How do I print a document in Microsoft Excel 2007 with the gridlines?
This article gives instructions on how to change the settings in Excel so the document will print with gridlines.

How do I print worksheets in Excel 2007 for Windows?
This article explains how to preview and print either a whole worksheet or a specific area of a worksheet and how to adjust where a page breaks in Excel 2007.

Worksheet & Cell Options

How do I change which cell is selected after pressing enter in Excel 2007?
This article explains how to change the default setting for the cell that is selected after pressing the enter key.

How do I link cells between different worksheets in Excel 2007?
This article explains how to link information from cells in one worksheet to cells in another worksheet.

How do I rename a worksheet in Excel 2007?
This article explains how to change the name of a worksheet.

How do I hide and unhide cells in Excel 2007?
Hiding cells can be useful when you do not want others to view their content or it can be useful when you do not want to print certain rows or columns in your worksheet. This article explains how to hide cells.

How do I freeze a column or row in Excel 2007?
This article explains how to lock a row or column so that it remains visible while scrolling to other areas of the document.

Quick Tips

How do I import numbers starting with zero into Excel 2007?
By default, Excel treats number codes as actual numbers, therefore cutting off any zeros in front. Sometimes these zeros are supposed to remain in the data, for instance in zip codes or ID numbers. This article explains how to prevent Excel from deleting leading zeros in these types of number codes.

How do I add commands to the Quick Access Toolbar in Microsoft Office 2007?
The Quick Access Toolbar is located in the upper left corner of all Office 2007 programs.Commands that you often use can be added to it so that they are easily accessible. You can add your most often used commands so that you do not have to search through different tabs in order to find them.

How do I adjust column size in Excel 2007?
This article explains the different ways to adjust the size of columns in Excel. You can do this by using the AutoFit feature, by dragging and dropping, or by specifying a certain width.

How do I remove duplicate items from a column in Excel 2007?
This article explains how to remove duplicate data from a column in Excel. It is important to make a copy of your data before following these steps, in case important information is lost.