| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter Sort Columns in a table.
I have a table in a worksheet with column headings in 5A through 5BC each
transaction is entered in rows, starting with row 6 through row 250. The Filter is turned on in the column headings. When I click on the arrow I can choose a filter sort. Do the formulas prevent the filtering??? When I do nothing happens. If I copy the sheet to another sheet and paste using Special Paste and paste only Values and Number Formats the filter and sort works perfectly. What am I doing wrong??? Thanks, Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I control the sort order of a filter in a pivot table? | Excel Discussion (Misc queries) | |||
| Sort choices in filter in pivot table | Excel Discussion (Misc queries) | |||
| Columns A - BY and 336 rows.Too much to filter&sort?Lose info. | Excel Worksheet Functions | |||
| Columns A - BY and 336 rows.Too much to filter&sort?Lose info. | Excel Worksheet Functions | |||
| two columns of numbers, need to sort/filter to find one number th. | Excel Discussion (Misc queries) | |||
Threaded Mode
