Helios Visions

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.
 

If you need to change the data in a cell there are several ways to do it. You can click on the cell and replace the contents by typing new data, but that isn’t always the best choice. This tutorial will show you the other three options.  This will work in Excel 2010, Excel 2007 and Excel 2003.