Copying data without hidden rows.

C

Cube Farmer

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.
 
D

Duke Carey

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

Max

After selecting the range, press F5 > Special > Visible cells only > OK.
Then do the copy > paste, and only the visible cells get copied/pasted
 
Top