View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.newusers
George Gee George Gee is offline
external usenet poster
 
Posts: 109
Default keeping the rows together

Faulty, no, probably not!
Is the worksheet protected .... Tools Protection?

George Gee


"king_reggie" wrote in message
...
it still won't let me select sort. do you think that my program is faulty?

"George Gee" wrote:

Click the letter A above your column of names.
Hold down the shift key and click the header letter of the last column
that
you wish to sort.

Data Sort ...... as previously described.

George Gee

"king_reggie" wrote in message
...
That didnt work either...after i highlight the worksheet i go into Data
but
the Sort option is not available, i cant select it. i don't know whats
going
on...is there a way to do it without highlighting the whole worksheet?

"Sameer Nagi" wrote:

select the entire worksheet by "ctrl+A".
select Data-Sort
Select "Column A" in Ascending order...ensure that in "Options" it is
selected to be columns and NOT rows...

Let us know if this also doesnt work...

"king_reggie" wrote:

I'm Creating a directory based on new clientele and i want it
alphabetical.
now my problem is tha if i enter for example in A1 Kim Smith, B1 111
rogers
rd, C1 555-555-5555, then continue with other names addresses and
phone
numbers, how can i get all the info per row to stay together when i
sort
column A? Is there a way to make the each column in the row work as
one
when
it sorts?