Cannot sort entire sheet

[Guest]

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?

 

[Niek Otten]

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

 

[Guest]

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.

 

[Dave Peterson]

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

 

[Peo Sjoblom]

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

 

[Guest]

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!!!!