How To Use The Keyboard Shortcut Alt + ; To Select Visible Cells Only In Excel

Here’s how to copy and paste visible cells only in Excel:

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

Let’s say I have a table of sales by month for 2013, and I only want to copy and paste the first quarter and total to another area of the worksheet:

vso1

I hide the columns I don’t want to copy, highlight the visible area, and use the keyboard shortcut Ctrl + C:

vso2

As you can see, it only put the “dancing ants” around the entire area, so when I paste it, Excel pastes not only what was visible, but all the cells in the highlighted area:

vso3

Alternatively, prior to copying the area, after highlighting it, use the keyboard shortcut Alt + ; (Alt key plus the semicolon). Then when you copy the data, it will only highlight the visible cells:

vso4

Now, when you paste it, only those cells that were visible are copied and pasted:

vso5

This will obviously work for hidden rows as well:

vso6

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , ,

7 Responses to How To Use The Keyboard Shortcut Alt + ; To Select Visible Cells Only In Excel

  1. Brian Zimmeman February 25, 2014 at 9:16 am #

    Great tip! That is a lot better than ‘Ctrl + G’, ‘Special…’, ‘Visible Cells Only’.

  2. Kawser Ahmed February 28, 2014 at 1:22 pm #

    Nice trip. I like your posts very much. You are a pro, I am trying to reach something up like you 🙂 Wish you more success in coming days.

  3. Kawser Ahmed February 28, 2014 at 1:23 pm #

    Nice Tip***

  4. Bunny June 9, 2014 at 6:20 am #

    Hey, what is the similar command in office for macbook?

  5. RIhab August 14, 2014 at 3:18 am #

    please tell me how to paste data in to visible cells only excel 2010

Leave a Reply