how can we sort data as we could do it in works? Select one colum.

  • Thread starter Thread starter Paul B
  • Start date Start date
P

Paul B

MP, not sure of you question because I do not have works, but in excel,
using the sort buttons on the too bar, if you have data in A:C and if you
select column A only column A is sorted, if you select a cell in column A
then A will sort but the data in B:C will be move with it. If this does not
answer your question post back with more info.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
Hi
not really sure what your question is. Please post your question as
BODY of your post
 
Better to select the whole range and not leave the choice to excel.

If you have gaps in your data (rows or columns), excel could guess the wrong
range and really screw up your data.



MP wrote:
 

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

Sort Contiguous Columns - Danger 3
how do I sort data excluidng headings? 2
Select all columns with data for sorting. 2
How do we Sort dates in Excel? 6
Prevent SORT from asking to expand selection in Excel 2007? 4
excel is only sorting some columns - please help 5
Excel 2007 data corruption using sort within a filter. 4
Sorting while protected - this question may not have been covered. 1

Back
Top