问题描述
我有大量数据.数据包括大学名称，其详细信息和所提供的课程.大约有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中复制包含特定文本的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！