Paste With Shortcut in Filtered Excel List

Last week, I shared a couple of workarounds for pasting data into a filtered list. If you use a simple copy and paste, you could end up overwriting data in the hidden rows.

filtercopypaste02

You can use those workarounds, if you are pasting into the filtered list, with data from another location. However, if you are copying and pasting data from one column to another, within the filtered list, there is a better solution.

Paste With a Shortcut

Instead of using one of the workarounds for copying and pasting, you can use a keyboard shortcut. It’s much quicker and easier!

This tip was shared by Khushnood Viccaji, in a comment on my previous post. Thanks for the tip – it’s a new one for me, and a real time-saver!

To copy data into the same rows in a filtered list:

  • Select the cells that you want to copy
  • Press Ctrl and select the cells where you want to paste (in the same rows)
  • To select only the visible cells in the selection, press Alt + ;  (the semi-colon)
  • To copy to the right, press Ctrl + R

The data is magically copied to the visible cells on the right, even though the columns are not adjacent

filterpastefillright01

Video: Paste With Shortcut in Filtered Excel List

To see the steps for pasting into the same row in a filtered list, please watch this short video tutorial. You’ll also see how to fill data to the left in filtered rows.

Or watch on YouTube: Use Shortcut to Paste in Excel Filtered List

________________

You may also like...

12 Responses

  1. Jay says:

    Fill “right” does not work(greyed out) if the data you want to copy is on column “A”.

  2. Mike Rempel says:

    Nice tip, Debra. I enjoy many of your tips. Finally listened to your interview with Chandoo – very enjoyable and picked up a couple things from that, too!

  3. Usama says:

    hey,
    I am using excel 2010, I tried this but it didn’t work the time as was instructed. However, it worked when I first selected the cells “to paste to” then hold CTRL key and select the cells “to be copied from”, then use CTRL+R .

    Thanks to Both Debra and Khushnood :)

  4. sam says:

    @Debra,
    Select Cells E6:E44
    Type =b6
    Ctrl+Enter

  5. Adi says:

    Great Tip! Thankd Debra & KV.
    I am using Excel 2007 and I encountered something similar to Usama.
    I need to select the empty cells first and then the filled ones for Ctrl right to work.

    Thanks again!!!
    Adi

  6. Luis Maldonado says:

    Hi, many thanks for sharing this.
    This technique doesnt work if the values you want to fill are with formula. How can i do if i want to paste the values only. If i click fill series the reference will move.

  7. Philipe says:

    Thank you very much, was trying to find a workaround for this for quite a while, and this saved me a lot of time on some complex engineering tables i´ve been making!

  8. Tum says:

    Thank you

  9. Mahmoud says:

    Hi,
    Unfortunately this trick can only work when you copy and paste within the same exact sheet.
    I would appreciate if you told us whether it is possible to copy cells from a sheet to another different filtered sheet.

Leave a Reply to Debra Dalgleish Cancel reply

Your email address will not be published. Required fields are marked *