Donate SIGN UP

why is the data sort on excel not working properly?

Avatar Image
ludditefreak | 14:01 Wed 08th Mar 2006 | Technology
1 Answers
I have added together two sets of information to an excel sheet that I need to sort by page number. I cut and paste section A to the top of the page and section B below it, ensuring the the cells matched up, but when i go to data sort it doesn't mix the information to display it by page order. Section A goes from 1 to 147 then B kicks in with the same numbers. I need to get all same page numbered material together etc. what am I doing wrong?
Gravatar

Answers

Only 1 answerrss feed

Best Answer

No best answer has yet been selected by ludditefreak. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

Once you have selected the entire range of cells to sort, and brought up the Data > Sort box, you need to ensure that the column containing your page numbers is the column listed in the 'sort by' field, and that should definitely work.


Only 1 answerrss feed

Do you know the answer?

why is the data sort on excel not working properly?

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.