How to Select Visible Cells Only in Excel 2007

Using the 'Select Visible Cells Only' Button
1. Launch Excel and open the file that you'd like to work on.
2. Right-click on the menu bar and then click on 'Customize Quick Access Toolbar.'
3. Click the drop-down menu under 'Choose commands from' and then choose 'Commands Not in the Ribbon.'
4. Choose 'Select Visible Cells' from the list and then click the 'Add' button. Click 'OK.' The 'Select Visible Cells Only' button should now be visible on your Quick Access Toolbar.
5. Select a range of cells that contains hidden rows or columns. Click the 'Select Visible Cells Only' button. This removes all hidden cells from your selection.
Using the 'Go to Special' Window
6. Launch Excel and open the file that you'd like to work on.
7. Select a range of cells that contains hidden rows or columns.
8. Press 'F5.' Click on the 'Special' button. You may also do this by holding down the 'Alt' key and then pressing 'S.' This opens the 'Go to Special' window.
9. Press 'Y' to select 'Visible cells only.' Click 'OK,' or press 'Enter' to close the window. This removes all hidden cells from your selection.