+ Reply to Thread
Results 1 to 3 of 3

Pre-written formula

  1. 06-05-2008, 04:30 AM #1
    Newton1234
    Newton1234 is offline
    Registered User
    Join Date
    12-17-2007
    Posts
    38

    Pre-written formula

    Hi,

    I have a spreadsheet which has pre-written formulas (which only show you the name) in the left hand box. However when I click on one it is not taking me to the place which it should.

    Does anyone know how to look behind the name and change the formula ?

    Please let me know if I have not explained this well.

    Thanks
    Reply With QuoteRegister To Reply
  2. 06-05-2008, 04:36 AM #2
    dominicb
    dominicb is offline
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good morning Newton1234

    When you click on a cell in Excel, if a name comes up in the box on the left hand side, then it is the cell (or range) that is named - not the formula. Click on the downward arrow to see all the names.

    To create your own, or see the ranges behind the current named ranges go to Insert > Name > Define.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.
    Reply With QuoteRegister To Reply
  3. 06-05-2008, 04:51 AM #3
    Newton1234
    Newton1234 is offline
    Registered User
    Join Date
    12-17-2007
    Posts
    38
    Brilliant, thanks :-)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Array Formula: What I am trying!
    By Chrisrob in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-25-2007, 03:22 AM
  2. Need help with formula please!!!!
    By alexferfa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-29-2006, 01:13 PM
  3. Entering variable data into a formula
    By Althas in forum Excel General
    Replies: 8
    Last Post: 10-30-2006, 05:15 PM
  4. named formula VBA insert error
    By Hammer_757 in forum Excel General
    Replies: 14
    Last Post: 10-14-2006, 08:53 AM
  5. Applying a formula to a list of values
    By TrooperFarva in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2006, 04:34 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1