在Excel中复制包含特定文本的行 [英] Copy rows which contains a specific text in Excel

问题描述

我有大量数据.数据包括大学名称，其详细信息和所提供的课程.大约有500多门课程.我的Excel的列从A到FO.课程列是从T到FO.我想根据课程名称创建单独的工作表.
我想要的是:-
当我搜索特定的文本(显然是课程名称)时，excel仅应显示包含该课程名称的那些行，以便我可以使用CTRL + A复制这些行并将其粘贴到另一行上.
谢谢！!!!

I have huge amount of data. The data consist of College Name, their details and courses they are offered. There are about more than 500 courses. My Excel have Columns start from A to FO. Courses columns are from T to FO. I want to create seperate worksheets according to course names.
What i want is :-
When i search for the specific text (which is obviously course name) , the excel should only show those rows which contains this course name so that i can copy these rows with CTRL + A and paste onto another.

THANKS IN ADVANCE!!!

推荐答案

选择整个列集并创建一个表.

为此，在西班牙语Excel版本中为Ctrl + T，在以前的版本中为Ctrl + Q( ^ ]).

这样，您就可以在该列的顶部创建一个过滤器，然后仅复制要复制的寄存器.

祝你好运！

Select the entire set of columns and create a table.

To do that in the Spanish Excel version is Ctrl+T, in previous versions it was Ctrl+Q (http://office.microsoft.com/en-us/excel-help/excel-shortcut-and-function-keys-HP010073848.aspx[^]).

This will allow you to create a filter just on top of the column and then copy only the registers you will want to copy.

Good luck!

这篇关于在Excel中复制包含特定文本的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！