Copy and skip hidden cells

**imerial** · 03-22-2013, 03:09 PM

I'm trying to copy a list of cells into another worksheet. The worksheet I'm trying to copy into has some cells hidden and Excel keeps pasting into those cells. I don't want it to. Is there a way to skip the hidden cells when pasting?

**dilipandey** · 03-23-2013, 08:23 AM

Yes.. you can use alt + ; key combination to work on visible cells

Regards,
DILIPandey
<click on below * if this helps>

**NeedForExcel** · 03-24-2013, 02:50 PM

Yes You Can...

Select the range

1) Press Ctrl+G
2) Special
3) Visible Cells Only
4) Click OK
5) Then Copy

Hope it helps!

**Careless** · 03-25-2013, 02:47 AM

Hi, if you want copy visible cells , ignore hidden cells .

try following step

1> SELECT THE RANGE OF YOU WANT TO COPY
2> PRESS ALT+;
3> PRESS CTRL+C or Menu Edit > copy or speedbutton
4> Paste to new sheet

**imerial** · 03-25-2013, 08:46 AM

Those methods only work if the sheet being copied from has hidden cells. In this case, the sheet with hidden cells is the one being copied to.

**dilipandey** · 03-25-2013, 09:32 AM

I don't think that is possible with simple copy - paste.. and the only option would be VBA (macro) but I am not sure.. why you want to do that.. better use lookup formulas to fetch the information instead of copy-paste.

Regards,
DILIPandey
<click on below * if this helps>