Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting in a shared workbook
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 |
#2
|
|||
|
|||
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???) Mark Jackson wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My Shared workbook is driving me crazy!!! | Excel Discussion (Misc queries) | |||
Shared workbook | Excel Discussion (Misc queries) | |||
Shared workbook - one at a time? | Excel Discussion (Misc queries) | |||
Shared workbook protection | Excel Discussion (Misc queries) | |||
Problem with shared workbook (history sheet) | Excel Worksheet Functions |