Easily combine multiple worksheets/workbooks/CSV files into one worksheet/workbook

It may be tedious to combine dozens of sheets from different workbooks into one sheet. But with Kutools for Excel’s Combine (worksheets and workbooks) utility, you can get it done with just several clicks! Full Feature Free Trial 60-day!

Recommended Productivity Tools for Excel/Office

Office Tab: Bring tabbed editing to Excel and other Office software, just like Chrome, Firefox and Safari.30-day Unlimited Free Trial

Kutools for Excel: 300 powerful features make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial

Add all outside borders with shortcuts of Ctrl + Shift + &: Select the cells you want to add all outside borders, and then press the Ctrl + Shift + & keys at the same time, now you will see the outside borders are added for selected cells immediately.

Remove all borders with shortcuts of Ctrl + Shift + _: Select the range you want to clear all borders, and press the Ctrl + Shift + _ keys simultaneously, then you will see all borders are removed from selected range.

In addition to hotkeys, we can also apply the Border command to add all borders to selected cells easily in Excel.

Step 1: Select the cells you want to add all borders in Excel.

Step 2: Go to the Home tab, and then click the Border > All Borders. See screen shot:

Then you will see all borders are added to selected cells at once.

Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

300 New Features for Excel, Make Excel Much Easy and Powerful:

• Merge Cell/Rows/Columns without Losing Data.
• Combine and Consolidate Multiple Sheets and Workbooks.
• Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
• Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
• More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...