Copying Non-Hidden Cells From A Worksheet

I learned something I did not know in Excel some time back and thought I would post it here, so I would not forget it.

I had a situation where someone gave me an Excel worksheet in which 90% of the records were hidden and I needed the un-hidden portion.

The first thing I tried is just a simple copy/paste to a new worksheet, but that copies all rows including the hidden ones. Not being an Excel guru, I had to ask around about how to copy just the visible rows and columns. Below is what I was told.

I have a simple worksheet with one hidden row.

If I do a straight copy <CTRL C>/paste <CTRL V> to a new worksheet, I get all the rows including the one I have hidden.

Below is what needs to be done to avoid hidden rows/columns:

1. Highlight the section to be copied

2. Access EDIT>GOTO or <CTRL G>

3. Access the [Special...] button

4. Select (Visible cells only) and click the [OK] button

5. Copy <CTRL C> the selection and paste <CTRL V> to a new worksheet

As you can see, only the visible data came across.

[-- Related Links --]
ExcelTip.com
Excel Tips