shortcut to copy visible cells only

[pedie]

What is the shortest way to copy visible cells only? Not vba?

 

[VoG]

Select the range, press F5, click Special, tick Visible cells, click OK. Then copy.

 

[MrKowz]

1. Highlight the range you want to find the visible cells in
2. Press CTRL+G to load up the Go To Window
3. Click Special
4. Tick "Visible Cells Only"
5. Press OK

The above method will select all visible cells. Then just copy/paste as normal

 

[pedie]

Thanks guys. 'Ve seen something with alt + something something... Just can't remember it....

 

[pedie]

Thanks again guys!!!

Here is another way

Press Alt + ; then copy...


Happy weekends guys!!!

 

[TrumpExcel]

Its Alt + ;

This selects visible cells only