Copy only visible rows from Microsoft Excel Worksheet

For example :
There are total 10 rows in a worksheet (Let’s say : Sheet 1). Only 4 of them are visible. The other 6 are hidden (using the row–>hide feature)

You want to copy only the 4 visible rows to a another excel worksheet.

Following are the steps which will allow you to achieve that :

1. On Sheet 1 which has hidden rows, hit F5.
2. On the “Go To” dialog box which appears, click “Special” button.
3. Select the “Visible Cells Only” radio option.
4. Click “Ok” button.
5. You will notice that all the visible rows are selected.
6. Hit “Ctrl-C” on the Sheet 1.
7. All the visible rows will have the dotted border.
8. Go the sheet (Let’s say : Sheet2) where you want to paste these rows.
9. Hit “Ctrl-V” on Sheet 2.
10. Done!

This entry was posted on 17 Feb 2008 at 10:52 and is filed under Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response or trackback from your own site.