logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Tuesday August 19th, 2025

Tip of the Day | Tuesday August 19th, 2025

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

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


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

    Choose your language preference below

    English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

    Trustpilot
    Download  


    • 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.