Copying data without hidden rows.

I am trying to copy data and not include the rows and columnc that I have
hidden.
I know there has to be an easy way but for some reason I am playing stupid
this morning.
Thanks in advance.

After selecting the range, press the F5 key, click on the Special button, and
check Visible Cells Only

"Cube Farmer" wrote:

> I am trying to copy data and not include the rows and columnc that I have
> hidden.
> I know there has to be an easy way but for some reason I am playing stupid
> this morning.
> Thanks in advance.
>

After selecting the range, press F5 > Special > Visible cells only > OK.
Then do the copy > paste, and only the visible cells get copied/pasted
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Cube Farmer" <Cube Farmer@discussions.microsoft.com> wrote in message
news:8229E867-E6F2-4ED0-87B6-2994532FE1FC@microsoft.com...
> I am trying to copy data and not include the rows and columnc that I have
> hidden.
> I know there has to be an easy way but for some reason I am playing stupid
> this morning.
> Thanks in advance.
>