How do I get rid of the sort down arrow on a cell when I don't wa.

T

Tinkerbelle

This is dumb, but I just started a simple chart, and I accidently pushed sort
and got a down arrow on 2 cells that I don't want to sort. How do I get rid
of it? I'm using Excel 2003.
 
G

Gord Dibben

Tink

Perhaps you hit Data>Filter>Autofilter and the drop-down arrows appeared at
top of column?

Try Data>Filter and click on Autofilter button.

Gord Dibben Excel MVP
 
E

ExcelGuru

Sounds like auto filter, higtlight the cell(s) with the arrow the
click on Data>filter>autofilter you should be able to declic
it
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working on birthday "book" for my wife and having layout/editing trouble 0
Sorting problem. My header rom is getting sorted with the rest. 1
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Text in note pane of "normal" display suddenly much larger 1
How do I get rid of horizontal arrows? 4
How do I match values in a sub set after a sort? 1
How can I sort "oldest to newest?" 5
my right and left arrows won't move to next cell 1

Top