1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Hide #N/A in Excel

Discussion in 'Business Applications' started by Gram123, Sep 22, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. Gram123

    Gram123 Thread Starter

    Joined:
    Mar 15, 2001
    Messages:
    1,829
    Hello,
    I'm using a series of VLOOKUP tables in an Excel sheet, and when there is no data in the sheet, or erroneous data, the lookup fails and shows #N/A.

    Can I hide this #N/A error, so the cell remains blank until the user enters a valid code in the adjacent cell?

    Ta

    Gram
     
  2. Gram123

    Gram123 Thread Starter

    Joined:
    Mar 15, 2001
    Messages:
    1,829
    Also, can you make it so you automatically skip certain cells when you're tabbing through data - in the same way that you can set Tab Stop to No in Access?

    Gram
     
  3. putasolution

    putasolution

    Joined:
    Mar 20, 2003
    Messages:
    4,823
    Use the following

    =If(Iserror(cellref or formula),0,cellref or formula)

    Then go to Tools | options | View and uncheck Zero Values in the Window options section
     
  4. RandyG

    RandyG

    Joined:
    Jun 26, 2000
    Messages:
    7,762
    The only way I know of doing that is to unlock the cells you want to tab to, and then protect the worksheet. The locked cells will not be "tabable".
     
  5. Gram123

    Gram123 Thread Starter

    Joined:
    Mar 15, 2001
    Messages:
    1,829
    Thank you both!
    Problem solved.

    Gram
     
  6. RandyG

    RandyG

    Joined:
    Jun 26, 2000
    Messages:
    7,762
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/166545

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice