Copy & Paste Visible Cells Only in Excel for Windows or Mac

Use this simple keyboard shortcut to select the visible cells only when copying and pasting a range with hidden rows or columns or filtered data.
Windows: Alt+;
Mac: Cmd+Shift+Z

[davidsanchezplaza]

Really nice, really good video. Clear explanation, no small talk, just to the point. Plus the extra explanation on how to add the fast button. Really professional!

[jenniferparis]

Perfectly Now I need to know how to then paste it into a sorted spreadsheet.

[Motassem]

Though it is a simple task and a very old video, I wanted to add the icon and totally forgot where is it located and this simple video reminded me that it is listed under the "S" with the "Select Visible ...." - Thank you.

[stevewages]

Thanks for this. Simple thing that I use infrequently. I took your advice and added to "Select Visible Cells" to the menu bar!

[theresalee]

On macs with Office 365, the keyboard shortcut is now also alt + ;

[rosenovotny]

This is great! I had it on my work computer because someone installed it for me. Now I've just done on my home computer thanks to your video! Thank you!

[HalcyonHavoc]

Thank you for this. But it doesn't show how to paste only in visible cells in a different worksheet. I have been searching the internet for this to no avail :(

[lizj]

Very helpful. I like how you explained both the shortcut and the quick step!

[BillGrubbMDHomesAndLoans]

Terrific. Clear and simple. Plus...additional education on saving this as a shortcut as well.

[husseinmahmoud]

kindly clarify how to paste these visible cells into another filtered column in the same table range, regard.

[steffic.b.]

Clear and to the point w/ alternatives to specific action of interest.

[viveksharma]

Thanks. That was crisp and to the point.

[HeenasView]

Thanks for sharing this simple formula

[AJ-rdng]

Thank you so much!! That was great! Exactly what I needed. Used Alt-; and then copied and pasted those cells into a new spreadsheet. Thanks again!

[mustafaamustafa]

I did the"Alt + ; " for selection and " Ctrl + C" then "C+ V" for paste but didn't get the same visible cells I copied! Thank you for the video

[brendasinclair]

Great! Thank you very much for the shortcuts and the clear and concise instructions. 

[RakeshKumar-yswy]

Thanks so much sir....i was just having troubles with this task...thanks for help

[christinabickley]

Is there any way to paste into only visible cells from another speadsheet?

[geetasaini]

Well I ran into a problem - everything goes well until after selecting visible cells only it gives this error: "You can't copy here because the copy area and paste area aren't the same size". I went and changed the row height and column width of the copy and paste areas in my 2 separate spreadsheets and it still did not work. What do you suggest?

[tennesseetravelr]

Is there a formula that will "cut" specific cells from column "B" and insert them into column "C"? Essentially swapping places? Like move the cell in column "B" containing "Keep on Truckin' [SM Karaoke]" to the position in column "C" containing "Keep on Truckin'".