Copy only visible rows from Microsoft Excel Worksheet

17 Feb 2008 by Chetan Shah.

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!

Posted in Technology | 1 Comment »