FREE Excel STUFF
SearchSearch Excel Content
PRODUCTS
Development
Contact
Excel Online

Dynamic Named Ranges

Complete Excel Excel Training Course. Instant Buy/Download, 30 Day Money Back Guarantee

BUY | Excel Named Range Add-in Manager Start

The Dynamic Ranges page is arguably the add-ins most powerful and useful feature. Dynamic Named Ranges are ranges that will expand/contract according to the data in the range. The great part about this is your named ranges will only include those cells that house data. This makes them ideal for Pivot Tables, Charts, Validation Lists, and restricting formula calculations.

There are 8 different types of Dynamic Ranges you can create;

  1. Numbers Only: The range will expand/contract as many rows or columns as there are numeric cells (cells housing numbers) in your Lead Column, or Row of your specified specified range.
  2. Text and Numbers: The range will expand/contract as many rows or columns as there are text and numeric cells (cells housing numbers or text) in your Lead Column, or Row of your specified specified range.
  3. Last Text Entry: The range will expand/contract to the last row or column, of your Lead Column, or Row, that houses text. The great one about this is you can have blank cells between your entries.
  4. Last Numeric Entry: The range will expand/contract to the last row or column, of your Lead Column, or Row, that houses a number. The great one about this is you can have blank cells between your entries.
  5. Monthly: The range will expand/contract one row or column per month up to 12. This one is ideal for charts and Pivot Tables that need updating only once per month. Set your dynamic range, use it in your chart or Pivot Table reference and leave it for the year. Your chart will update automatically the 1st day of each month!
  6. Weekly: The range will expand/contract one row or column per week up to 52. This one is also ideal for charts Pivot Tables that need updating only once per week. Set your dynamic range, use it in your chart or Pivot Table reference and leave it for the year. Your chart will update automatically the first day of each week!
  7. Day of Month: The range will expand/contract one row or column per day for any month, max of 31. This one is also ideal for monthly charts or Pivot Tables that need updating only once per day of each month. Set your dynamic range, use it in your chart or Pivot Table reference and leave it.  Your chart will update automatically each day of each month.
  8. Linked to Single Cell: The range will expand/contract one row or column according to the number you have in your specified Linked Cell. This makes the Linked to Single Cell choice one of the most generic and flexible.

30 Day Money Back Guarantee On All Excel Add-ins! Big Discount for Unlimited LicenseYou will be able to download your Excel Add-in immediately after ordering.

Excel Named Range Add-in Manager Start

Excel Named Range Manager 30 Day Money Back Guarantee Excel 97 or above. Payment Problems/Options SAVE by buying as part of a Add-ins collection
Order Type:

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.

See Also: Excel Duplication Manager Add-in | Excel Formula Manager Add-in | Excel Number Manager Add-in | Excel Text Manager | Excel OzGrid Plus Add-in | Excel Time Sheet | Excel Time Wage and Pay book


Instant Download and Money Back Guarantee on Most Software

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Add to Google Search Tips FREE Excel Help

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft