Monday, January 3, 2011

How to hide dropdown arrows in Excel 2007 tables

I searched the internet in vain for this before reverting to the fool-proof strategy of clicking at random things in Excel. To turn the arrows off, go to the "Data" tab. The "Filter" button is highlighted. Click it and the arrows disappear. Click it again to reactivate the arrows on column headers. That's what I've learned today :-)

Happy new year!

8 comments:

  1. Oh my goodness. Thank you so much. The graphic designer in me was about to have a panic attack because I couldn't get those ugly and overlapping arrows to go away...this is the only solution that solved the problem.

    ReplyDelete
  2. Bless you. Yours is the only answer that worked without programming!

    ReplyDelete
  3. Thank you so much! You just saved my neck as I am editing my masters dissertation. And I loved the intro with the "fool-proof strategy " ;)

    ReplyDelete
  4. thank you for sharing nice-person-who-makes-the-world-a-better-place

    ReplyDelete
  5. thanks a bunch. Was clicking a lot of random stuff till i decided to google

    ReplyDelete