Author: Oscar Cronquist Article last updated on August 13, 2018

This article shows you a way to display all named ranges you have in a workbook. This is a powerful feature in Excel if you have many named ranges and Excel defined tables and you want a better overview.

Instructions on how to build a list with all your named ranges

  1. Go to "Formula" tab on the ribbon
  2. Press with mouse on "Use in Formula" button
  3. Press with mouse on "Paste Names..."
  4. Press with left mouse button on "Paste List" button
  5. The list of named ranges is created.