{"id":756,"date":"2022-07-03T11:55:02","date_gmt":"2022-07-03T11:55:02","guid":{"rendered":"https:\/\/bandittracker.com\/?p=756"},"modified":"2022-12-31T18:18:22","modified_gmt":"2022-12-31T18:18:22","slug":"excel-adds-filter-to-wrong-row","status":"publish","type":"post","link":"https:\/\/bandittracker.com\/excel-adds-filter-to-wrong-row\/","title":{"rendered":"Why Is Excel Putting A Filter On The Wrong Row? (Solved)"},"content":{"rendered":"\n

I recently encountered the problem where I was trying to add a filter on the top row but Excel kept putting it on the second row.<\/p>\n\n\n\n

Here\u2019s a picture of this annoying problem:<\/p>\n\n\n

\n
\"\"
Filter Problem<\/em><\/figcaption><\/figure><\/div>\n\n\n

Although I have placed the cursor on the first row and the B1 cell is highlighted, Excel insists on putting the filter on the second row.<\/p>\n\n\n\n

I finally found an old solution in a forum post dated back in 2007. Microsoft has changed the interface a lot since then, so I had to \u201ctranslate\u201d the information to get it to work.<\/p>\n\n\n\n

I\u2019ll give you the quick solution first and then go into the reasons behind the problem.<\/p>\n\n\n\n

\n

Table of Contents<\/p>\n