Microsoft Office Productivity

This operation allows you to extract specific data for review. You can create a ‘set’ of specific criteria to use to ‘Filter’ the data. In this example we will pull out specific information from a list of employees. We will create criteria that will display employees that were employed before a specific date, make more than $40,000 and work in one of three departments.  This will work the same in Excel 2010 and Excel 2007.

If you have multiple non-adjacent cells and you need to make a change the contents in the cells at once, there is an easy way to do this without copying and pasting the new data. In this example the name of one of the products has changed, we are going to change the name in multiple cells at the same time.  This will work the same in Excel 2010, Excel 2007 and Excel 2003.

When typing text into a cell in Excel you may have reason to start a new line. There is a keyboard shortcut to force the text on the next line in Excel.
 

If you have hidden cells (individual, rows, or columns) in Excel, and you try to select or copy only the visible cells, you will end up selecting the hidden cells as well.  This tutorial will show you how to add “Select Visible Cells” to the Quick Access Toolbar and to use the command to select ONLY visible cells.  This command is not in the Ribbon, which is why it has to be added to the Quick Access Toolbar before using it.  This will work the same in Excel 2010 and Excel 2007.

If you are typing the same data in a column you can use the mouse to “Auto-Complete” your entries.  This will work the same in Excel 2010, Excel 2007 and Excel 2003.