how do I copy only visble cells in office10

[Tantalus24]

i can't remember how this is done in this version

 

[Eva]

Click Go to then special and "visible cells only" and then CTRL+C (copy)

Click yes if helped

 

[RyGuy]

Ctrl+g > Special > Visible Cells Only > OK

Click Go to then special and "visible cells only" and then CTRL+C (copy)

Click yes if helped

 

[Ashish Mathur]

Hi,

Select the range and press Alt+; to select visible cells

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com