How to Merge XLS Files

Silver iphone 11 and 11 pro.jpg

Microsoft Excel files are organized into a set of worksheets, each containing its own set of data. By default, a file has three worksheets, but you can merge the worksheets from one XLS file into another. The process is completed using the worksheet tabs at the bottom of the XLS file.

1 Start Microsoft Excel

Start Microsoft Excel and open the existing sheet into which you want to merge information (call it file1.xls) from another file. Open the other file (file2.xls) from which you want to merge information. Both files must be open at the same time.

2 Right click the first tab

Right-click the first tab at the bottom of file2.xls (which contains the information you want to merge into file1.xls). Select "Move or Copy…" from the list of options. The program loads a new dialog box.

3 Choose the name of the other file

Choose the name of the other file (file1.xls in this example) from the "Move Selected Sheets to Book" drop-down box.

4 Click

Click "(move to end)" from the "Before Sheet" box. Click "OK" to merge the worksheet from file2.xls to file1.xls.

5 Select the next worksheet in the open file2.xls document

Select the next worksheet in the open file2.xls document. Repeat this process (steps two to four) to merge all worksheets into the first file (file1.xls).

Louise Balle has been writing Web articles since 2004, covering everything from business promotion to topics on beauty. Her work can be found on various websites. She has a small-business background and experience as a layout and graphics designer for Web and book projects.

×