Sorting in a shared workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am using a shared workbook over a network and I am having problems sorting
my worksheet. When I highlight the data I want to sort (A2:M20) it
automatically highlights the entire row (2:20). How can I get it to sort
only the data I have Highlighted? If I take the spreadsheet off of "shared"
it works fine. I am using Excel 2000 on Windows XP. Thanks in advance.

Mark
 
That's the way excel works with a shared workbook.

Maybe just putting the data on that row that should be sorted would be
sufficient.

(Move the data to the right/left to another worksheet or lower on that same
worksheet???)
 
You must log in or register to reply here.

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

Excel Highlighting duplicates 0
Sorting Datain a Shared Workbook 2
Sharing workbooks limitations - Merged Cells 12
sort behavior in shared workbook 1
Sorting formula cells not same as sort of value cells? Yikes! 4
Data Sorting Is Taking Columns That I Don't Want To Be Sorted 1
help with sorting 2
sorting problem 7

Back
Top