logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Copy and Stack Rows or Columns from Multiple Sheets...

ASAP Utilities  › Sheets  ›  24. Copy and Stack Rows or Columns from Multiple Sheets...

Easily copy and stack rows or columns from multiple worksheets into a new sheet, either side by side (columns) or below each other (rows). You can choose to:
  • Tile vertically - Select specific columns or copy the used range from each selected sheet.
  • Tile horizontally - Select specific rows or copy the used range from each selected sheet.
  • Copy values or Create dynamic links (cell references) to keep data automatically updated. Note:
    When using Create dynamic links, Excel's Paste Link method is used.
    To avoid displaying zero values for references to empty cells, ASAP Utilities turns off Excel's 'Show a zero in cells that have a zero value' setting under 'Display options for this worksheet' for the new sheet.
    You can adjust this setting there or use the 'Display & Navigation' tool in ASAP Utilities.

    Screenshots

    Example screenshot: Put together rows or columns from several sheets
    Put together rows or columns from several sheets

    Starting this tool


    Sheets  ›  24 Copy and Stack Rows or Columns from Multiple Sheets...
    Additional keywords for this tool:
    Copy rows from multiple sheets in ExcelStack columns from multiple worksheetsCopy data from multiple sheets to one sheetCombine rows from multiple sheets into oneCopy used range from multiple worksheetsExcel stack data from different sheetsTransfer columns from multiple sheets to a new worksheetCopy data from different sheets to one master sheetExtract rows or columns from multiple worksheetsJoin data from multiple sheetsMerge data from multiple worksheets (not formulas)Consolidate rows and columns from multiple sheets (without calculations)What is the fastest way to extract data from multiple worksheets?



  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.