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.