So I highlighted the columns I want to specifically sort (ex. cols B - G) and
when I click DATA and then choose SORT, it also highlighted column A for me.
I do not want column A to be sorted along with columns B - G. I cannot
change the highlighted parts unless I cancel the sorting window. What am I
doing wrong and what can I do to fix this?

Additional info: I'm working on a shared workbook
--
life is good as a gopher

I think you'll find that this is the way excel works.

From Excel2003's help for "features unavailable in a shared workbook":

Unavailable feature Alternatives
Insert or delete blocks of You can insert entire rows and columns.
cells

While this doesn't address your situation, it does give the impression that
moving around less than the whole row isn't supported.


Lyn wrote:

So I highlighted the columns I want to specifically sort (ex. cols B - G) and
when I click DATA and then choose SORT, it also highlighted column A for me.
I do not want column A to be sorted along with columns B - G. I cannot
change the highlighted parts unless I cancel the sorting window. What am I
doing wrong and what can I do to fix this?

Additional info: I'm working on a shared workbook
--
life is good as a gopher

--

Dave Peterson