+ Reply to Thread
Results 1 to 2 of 2

Named Cells & Ranges

  1. #1
    Registered User
    Join Date
    02-24-2013
    Location
    USA
    MS-Off Ver
    Microsoft Excel for Mac v16.38
    Posts
    35

    Named Cells & Ranges

    I have a large financial model I am building with over 100 named cells and ranges.
    As I have building the model, I notice that I want to keep like kind cells named with the same prefix and etc.
    There is no name manager in Microsoft Office 365 Excel for Mac.

    To create an organized and easily understood list of named cells and ranges I have found that I am in need to changing many of the names already defined.

    Is there a way to change the name and the change promulgate through the workbook so I dont have to find every use of the old name and change it to the new name?

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,802

    Re: Named Cells & Ranges

    Have you tried: https://jkp-ads.com/OfficeMarketPlaceNM-EN.asp
    Rory
    I drink, and I know things

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Blank cells in named ranges
    By JaSonic75 in forum Excel General
    Replies: 37
    Last Post: 04-09-2018, 02:18 PM
  2. #ref!#ref error for named cells or ranges
    By StuCram in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2015, 07:32 PM
  3. Replies: 0
    Last Post: 10-15-2012, 07:24 AM
  4. [SOLVED] Comparing corresponding cells between multiple named ranges
    By srob in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-28-2012, 08:13 AM
  5. Copy & paste from cells below named ranges
    By Glio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2007, 08:15 AM
  6. Testing for named cells (i.e., ranges)
    By John Wirt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2005, 07:06 AM
  7. Dynamic Named Ranges with Blank Cells
    By andibevan in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-17-2005, 01:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1