excel 筛选 粘贴_在筛选的Excel列表中粘贴快捷方式

excel 筛选 粘贴

Last week, I shared a couple of workarounds for pasting data into a filtered list. Today, see how to paste with shortcut in filtered Excel list.

上周，我分享了一些解决方法，可以将数据粘贴到过滤列表中 。 今天，请参阅如何在过滤的Excel列表中使用快捷方式粘贴。

简单粘贴到过滤列表中 (Simple Paste in Filtered List)

If you use a simple copy and paste, you could end up overwriting data in the hidden rows.

如果使用简单的复制和粘贴，最终可能会覆盖隐藏行中的数据。

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:

Khushnood Viccaji在我的前一篇帖子中发表了评论。 感谢您的提示-这对我来说是一个新的提示，并且可以节省时间！ 要将数据复制到过滤列表的相同行中：

• Select the cells that you want to copy
  选择您要复制的单元格
• Press Ctrl and select the cells where you want to paste (in the same rows)
  按Ctrl键，然后选择要粘贴的单元格(在同一行中)
• To select only the visible cells in the selection, press Alt + ; (the semi-colon)
  要仅选择所选内容中的可见单元格，请按Alt +； (分号)
• To copy to the right, press Ctrl + R
  要复制到右侧，请按Ctrl + R

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

即使列不相邻，数据也会被神奇地复制到右侧的可见单元格中

视频：在筛选的Excel列表中粘贴快捷方式 (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.

要查看粘贴到过滤列表中同一行中的步骤，请观看此简短视频教程。 您还将看到如何在过滤后的行的左侧填充数据。

演示地址

更多数据输入提示 (More Data Entry Tips)

For more time-saving tips, go to the Data Entry Tips page on my Contextures website. There are videos, screen shots and written instructions there, to help you get your Excel work done.

有关更多节省时间的提示，请转到Contextures网站上的“数据输入提示”页面 。 那里有视频，屏幕截图和书面说明，以帮助您完成Excel工作。

And for a full list of Excel keyboard short cuts, go to my interactive Shortcuts List. ________________

有关Excel键盘快捷键的完整列表，请转到我的交互式快捷键列表 。 ________________

翻译自: https://contexturesblog.com/archives/2014/04/29/paste-with-shortcut-in-filtered-excel-list/

excel 筛选 粘贴