Sorting

R

Richard

I want to sort from cell a1 to a10 in a column. However, I can only able to
sort from cell a2-a10 eventhough I selected cell a1-a10 and clicked sort.
What is going on?
 
W

WLMPilot

After clicking on SORT to open the sort window, make sure the button at the
bottom for "No Header Row" is selected.

Les
 

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

Sorting Multiple Tables 1
Excel - Wich Function should I use? 1
Cannot sort a table containing text 5
column to row draging 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Outlook Web - Sorting Calendars by Alphabetical order? 0
cell reference 4
Help needed for inexperienced MS Excel 2003 user 2

Top