How to combine numerous sheets into a single sheet

I recently receive the following question:
Is there a way to combine numerous Sheets into a single Sheet? I have an Excel document with 72 sheets, that I would like to be 1 continuous sheet. Thanks again for your help.

You can use the following tool to put together the rows or columns from multiple sheets in your workbook:
Columns & Rows » Put together rows or columns from several sheets...

As an alternative, you can also export the sheets a separate files and then import them into one new workbook:
Export » Export worksheets as separate files...
Import » Merge and/or import multiple files...

This second approach is sometimes a bit easier when the amount of rows or columns in your worksheets vary and it has more options to choose from.

Comments are closed.

Pinterest