FILTERS: Probably a very silly question

Hey all! New to the site. Thanks for having me! Doubtful that I'd ever be able to help anyone on here, but I will try when I can.

I have a couple of things I'd like to do with a spreadsheet that I've put together that I'm mostly happy with... See partial screen shotby default 2013-02-02 at 4.46.04 PM.jpg

1. I have filter buttons attached to the top of each column that I don't like the functionality of. Once you use the filter once I can't seem to remove the filter afterward. The data stay permanently sorted. I can undo the action immediately after, but if I for example, close and re-open the document there's doen't appear to be anything I can do to un-sort the column.

2. When applying a filter to any one column, I would like for the value in each row to remain intact and be moved accordingly.

3. I started this spreadsheet from the "Customer List" template so the filters were already inserted on each column. How do I remove them from some of the columns?

Thx in advance for helping out :-)

Thank you shg. Answers 1 & 3 understood.

Question #2 explained: All the data in each original row needs to remain in a row together. So when I move any cell up or down in any column, that the rest of the data in that row moves with it. I'm not explaining this very well am i

Oh I see the problem here... Ya all my data appears contiguous but my spreadsheet is made from a template table ("Customer List"), and some 'non-table' columns that I added myself (see attached pic) so when I apply a filter on the "Status" column for example, it only changes the 'non-table' columns. Same thing applies when I apply a filter in column that was part of the original template table.

How do I rectify this with out having to build this sheet again?

Just wanna thanks again for the help. Selecting, then sorting does nothing except what just described. Here's my workbook.

K apply a filter to the "Status" column. Now notice that the values in the "Company Name" column don't change with the rest of the data that changes (left of "Market ID"). No mater what I highlight, or select, this column will not change. Furthermore, I think it would be rather bothersome to have to "select all of the relevant columns" before applying a filter.

Oh. Well I can honestly say that I haven't a clue what that means. I tried, I really did. LOL. I just wanna enter data man. Any chance you can make the changes to the file and re-post?

Hey thanks for your time friend. It's so nice to know that when you're in pinch that there's always someone out there that'll give a helping hand when you really need it. Great job humanity!!!

I decided to to start fresh with a new table, rather than spend then any more time trying to fix what I screwed up earlier. Lesson learned.

Cheers!