Cannot sort entire sheet

I'm working with a workbook created by someone else. There are 14 columns,
with the business name in the second column. I want to alphabetize on the
names. Columns A - H will sort properly, columns I - L are missing, and
columns M - R will not sort.

Help?
--
Linda

Hi Linda,

If there are empty columns in the sort area, Excel will (by default) only sort the area where the active cell is. You can see that
in the way it highlights an area when you sort.
To include more columns, select the whole area before you issue the sort command.
BTW, how 14 columns correspond to columns A to R is not at all clear to me

--
Kind regards,

Niek Otten

"Linda" <Linda@discussions.microsoft.com> wrote in message news:DA6C0E3E-488C-45D7-BACA-63A917B3DEA1@microsoft.com...
> I'm working with a workbook created by someone else. There are 14 columns,
> with the business name in the second column. I want to alphabetize on the
> names. Columns A - H will sort properly, columns I - L are missing, and
> columns M - R will not sort.
>
> Help?
> --
> Linda

I figured that was the problem, but the columns I - L aren't just blank,
they're gone. The column lettering jumps from H to M. I don't know how to
get those columns back.
--
Linda


"Niek Otten" wrote:

> Hi Linda,
>
> If there are empty columns in the sort area, Excel will (by default) only sort the area where the active cell is. You can see that
> in the way it highlights an area when you sort.
> To include more columns, select the whole area before you issue the sort command.
> BTW, how 14 columns correspond to columns A to R is not at all clear to me
>
> --
> Kind regards,
>
> Niek Otten
>
> "Linda" <Linda@discussions.microsoft.com> wrote in message news:DA6C0E3E-488C-45D7-BACA-63A917B3DEA1@microsoft.com...
> > I'm working with a workbook created by someone else. There are 14 columns,
> > with the business name in the second column. I want to alphabetize on the
> > names. Columns A - H will sort properly, columns I - L are missing, and
> > columns M - R will not sort.
> >
> > Help?
> > --
> > Linda
>
>
>

It sounds like they're hidden (columns can't actually be deleted--if you delete
a column, then everything shifts to the left and a "new" column IV is created.)

Try this:
Edit|Goto
type in:
I:L
and hit enter
then
Format|Column|Unhide



Linda wrote:
>
> I figured that was the problem, but the columns I - L aren't just blank,
> they're gone. The column lettering jumps from H to M. I don't know how to
> get those columns back.
> --
> Linda
>
> "Niek Otten" wrote:
>
> > Hi Linda,
> >
> > If there are empty columns in the sort area, Excel will (by default) only sort the area where the active cell is. You can see that
> > in the way it highlights an area when you sort.
> > To include more columns, select the whole area before you issue the sort command.
> > BTW, how 14 columns correspond to columns A to R is not at all clear to me
> >
> > --
> > Kind regards,
> >
> > Niek Otten
> >
> > "Linda" <Linda@discussions.microsoft.com> wrote in message news:DA6C0E3E-488C-45D7-BACA-63A917B3DEA1@microsoft.com...
> > > I'm working with a workbook created by someone else. There are 14 columns,
> > > with the business name in the second column. I want to alphabetize on the
> > > names. Columns A - H will sort properly, columns I - L are missing, and
> > > columns M - R will not sort.
> > >
> > > Help?
> > > --
> > > Linda
> >
> >
> >

--

Dave Peterson

They are most likely hidden, click the column H header, hold down shift and
click the M header, do format>column and select unhide


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Linda" <Linda@discussions.microsoft.com> wrote in message
news:CBAC0020-0145-4218-8199-DD104C70A748@microsoft.com...
>I figured that was the problem, but the columns I - L aren't just blank,
> they're gone. The column lettering jumps from H to M. I don't know how
> to
> get those columns back.
> --
> Linda
>
>
> "Niek Otten" wrote:
>
>> Hi Linda,
>>
>> If there are empty columns in the sort area, Excel will (by default) only
>> sort the area where the active cell is. You can see that
>> in the way it highlights an area when you sort.
>> To include more columns, select the whole area before you issue the sort
>> command.
>> BTW, how 14 columns correspond to columns A to R is not at all clear to
>> me
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "Linda" <Linda@discussions.microsoft.com> wrote in message
>> news:DA6C0E3E-488C-45D7-BACA-63A917B3DEA1@microsoft.com...
>> > I'm working with a workbook created by someone else. There are 14
>> > columns,
>> > with the business name in the second column. I want to alphabetize on
>> > the
>> > names. Columns A - H will sort properly, columns I - L are missing,
>> > and
>> > columns M - R will not sort.
>> >
>> > Help?
>> > --
>> > Linda
>>
>>
>>

Thanks so much for the help. I brought the hidden columns back. Copied the
information into those columns. And, now I can sort the entire sheet!!!!
--
Linda


"Peo Sjoblom" wrote:

> They are most likely hidden, click the column H header, hold down shift and
> click the M header, do format>column and select unhide
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> http://nwexcelsolutions.com
>
>
> "Linda" <Linda@discussions.microsoft.com> wrote in message
> news:CBAC0020-0145-4218-8199-DD104C70A748@microsoft.com...
> >I figured that was the problem, but the columns I - L aren't just blank,
> > they're gone. The column lettering jumps from H to M. I don't know how
> > to
> > get those columns back.
> > --
> > Linda
> >
> >
> > "Niek Otten" wrote:
> >
> >> Hi Linda,
> >>
> >> If there are empty columns in the sort area, Excel will (by default) only
> >> sort the area where the active cell is. You can see that
> >> in the way it highlights an area when you sort.
> >> To include more columns, select the whole area before you issue the sort
> >> command.
> >> BTW, how 14 columns correspond to columns A to R is not at all clear to
> >> me
> >>
> >> --
> >> Kind regards,
> >>
> >> Niek Otten
> >>
> >> "Linda" <Linda@discussions.microsoft.com> wrote in message
> >> news:DA6C0E3E-488C-45D7-BACA-63A917B3DEA1@microsoft.com...
> >> > I'm working with a workbook created by someone else. There are 14
> >> > columns,
> >> > with the business name in the second column. I want to alphabetize on
> >> > the
> >> > names. Columns A - H will sort properly, columns I - L are missing,
> >> > and
> >> > columns M - R will not sort.
> >> >
> >> > Help?
> >> > --
> >> > Linda
> >>
> >>
> >>
>
>
>