+ Reply to Thread
Results 1 to 4 of 4

How to edit a formula already validated?

Hybrid View

  1. #1
    Registered User
    Join Date
    02-19-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to edit a formula already validated?

    Hi, I validated formulas in my worksheet by doing the following: pressing F5, click Special, click ok, Check Formulas, click ok, click Data Validation, select Custom, write ="" in the formula space. The foregoing actions validated all formulas found in my worksheet. Now, I want to edit some formulas I placed but how should I do it?

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: How to edit a formula already validated?

    ladylex, Tips & Tutorials if for Tips & Tutorials, not for questions.

    Moved to Excel General

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: How to edit a formula already validated?

    The foregoing actions validated all formulas found in my worksheet.
    The actions did what? Can you explain what you think you achieved by this? What exactly are you trying to do?

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: How to edit a formula already validated?

    hmmmmmmmmmmmmmmmmmmmmmm!
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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