Forum Discussion

FirasShaker's avatar
FirasShaker
Copper Contributor
May 24, 2021

Filter function with Excel 2019

Hello,

 

I have excel 2019 and suddenly the filter function disappeared, please advise.

excel

4 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    May 24, 2021

    FirasShaker 

    It can be different.

    Since the explanation of the problem was not detailed and no file (without sensitive data) was attached, I can only guess. It is understandable that it can be annoying for you if a problem arises and you need a solution immediately.

    Please note that it can be just as annoying for someone who wants to help and does not have a precise description of the problem / situation.

     

    Nonetheless, the motto also applies here: Help to be helped

     

    Assumption 1. Perhaps a filter function is open somewhere on the table / worksheet, namely a function that makes the remaining data disappear. Please delete the complete filter, maybe the data will be back.

    Assumption 2. Perhaps the workbook or worksheet comes from an older Excel that does not allow any filter functions. Do not think so much that it could be so, but it is possible.

    Assumption 3. Remove table; Select the entire worksheet or just the cells of the table and remove all formatting, remove coloring and background from the table if any. This allows you to evaluate the error step by step. So you can follow step by step where the error could be, time and nerves are all this time.

     

    I would be happy to know if I could help.

     

    Nikolino

    I know I don't know anything (Socrates)

     

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

     

    • SELAJG's avatar
      SELAJG
      Copper Contributor
      May 24, 2021

      NikolinoDE When you say 'the filter function disappears' do you mean from the sheet you're working on? You can add a filter using the Filter button in the Data menu. We can probably help further if you are able to explain the issue a little more clearly (perhaps you can upload a suitable screenshot). Good luck!

      • NikolinoDE's avatar
        NikolinoDE
        Platinum Contributor
        May 26, 2021

        SELAJG 

        Hello Mr. SELAJG the answer was from Mr. FirasShaker posed, not by me.

        I'm just trying to suggest a solution that might help.

        No more and no less.

         

        You can put your questions to Mr. FirasShaker accordingly.

         

        Thank you for your time and understanding

         

        Nikolino

        I know I don't know anything (Socrates)

Resources