1

I am new to Excel. I want to merge three Excel files into one. They all have the same column headers.

I have three files of students. Each file contain only 100 students. Each file has the same headings: Student_name, Rollno., and Class.

How can I merge all 300 students into one file?

4
  • 6
    I think what you are describing is just a copy/paste problem. You open all three files, copy from one and paste at the end of the other, repeat and then you have all your data in only one file May 2, 2017 at 17:24
  • 1
    If there is only 3 files with only one sheet each, I think copy-pasting is faster than waiting for an answer here
    – Vylix
    May 2, 2017 at 17:37
  • 1
    @fernando.reyes That was a lot easier then I thought . Thanks:)
    – beginner
    May 2, 2017 at 17:42
  • @fernando.reyes, you should post your response as the answer - get the credit and get this one off the unanswered list.
    – DeNaeL
    May 23, 2017 at 21:29

1 Answer 1

2

I think what you are describing is just a copy/paste problem.

When you have data spread into several files, with the same headers, the easier way to merge them is to open all three files, copy from one and paste at the end of the other, repeat and then you have all your data in only one file.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .