We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Excell 2002 autofilter

Options
Hi
I have set up and autofilter on an excell spreadsheet with a list of names and another list of numbers.
How do I edit,delete and add to the list?

Its diving me mad!

Ta

Comments

  • More4me
    More4me Posts: 258 Forumite
    Part of the Furniture 100 Posts Combo Breaker
    All of the edit,delete and add (Insert) options are available in autofilter mode, however, you can not delete or add single cell it has to be whole row. after editing cells click filtered column and click ok to refresh the list.

    What happens when you edit,delete and add?
    More
  • Thanks for replying
    I have it sorted now
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 351K Banking & Borrowing
  • 253.1K Reduce Debt & Boost Income
  • 453.6K Spending & Discounts
  • 244K Work, Benefits & Business
  • 598.9K Mortgages, Homes & Bills
  • 176.9K Life & Family
  • 257.3K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.