I suspect the issue is that Excel has created this as an "Excel List" (a
Table) and it will continue top manage the entire range as a list.
See the Excel help topic "Create a list". To revert to normal behaviour,
you need to remove the list. Which is not exactly intuitive...
1) Select the whole list
2) Use Insert>List to start the List Wizard.
3) A List toolbar will appear
4) At the bottom left of the toolbar there is a drop-down named "List"
5) Drop that down and choose "Remove list manager" from the items.
Hope this helps
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel I want
to sort a portion of a list of book titles and authors by the titles
associated with a particular author. When I highlight this portion of my list
and then go to "SORT" the entire list is then highlighted. I've never had this
problem before so what am I doing wrong?
--
The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:
[email protected]
