Consolidate with the Consolidate command (Overview)

For more complex situations, particularly when sheets have similar labels but those columns and rows are not in the exact same place, press F1 and search for help with the keyword: Consolidate.

The bottom line is that Excel can intelligently consolidate ranges as long as you use labels. It can analyze the labels in the columns and rows of each range and "crunch" them together. Pretty amazing!

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.