Excel 97 Spreadsheet

[walk12]

Hi,
I have a question about excel 97
I'm setting up an excel spreadsheet for a Reading Teacher.
She needs 4-columns called Names,Hearing/Sounds, Stanine, and
Writing/Vocabulary.
The question I have is the columns called (Writing/Vocabulary) and
(Hearing/ Sounds)will have scores and the teacher would like to clic
on Desceding or Acsending and sort the scores to see which studen
needs more help by checking lower scores.
How do I do that so that the scores will move with the names when sh
sorts them?
Basically what I need is the 1st column would be (Names)
the 2nd would be (Hearing/Sounds) the 3rd would be (Stanine)
and the 4th would be Writing/Vocabulary.
The 2nd and 4th column would have scores. The teacher wants to sort b
scores to determine which student needs more help by looking at th
lower scores.
The names need to sort with the students scores.
If you could setup an example I could try out that would be awsome.
The way I gave for an example is how the spreadsheet needs to b
set-up
Any help would be greatly needed.

thanks walk12 :confused

 

[RagDyer]

If you select the *entire* data list (A1 to Dwhatever), and then invoke
<Data> <Sort>,
and then select the particular column that you wish as the sort key,
*everything* will stay together.

I definately advise *against* using the sort icons on the toolbar.

To ease the repeated selection of the whole data list, you could name it as
a range, and then simply call it up prior to initiating the sort.

Select the *entire* data list, *including* the header labels.
Click in the "name box", and type a short, descriptive name, such as "Srt1"
(no quotes), and then hit <Enter>.

Now, when you're ready to sort, simply click the small down arrow beside the
name box, and click on the "Srt1" name, and the entire list is
*automatically* selected.
Then just start the <Data> <Sort> procedure.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi,
I have a question about excel 97
I'm setting up an excel spreadsheet for a Reading Teacher.
She needs 4-columns called Names,Hearing/Sounds, Stanine, and
Writing/Vocabulary.
The question I have is the columns called (Writing/Vocabulary) and
(Hearing/ Sounds)will have scores and the teacher would like to click
on Desceding or Acsending and sort the scores to see which student
needs more help by checking lower scores.
How do I do that so that the scores will move with the names when she
sorts them?
Basically what I need is the 1st column would be (Names)
the 2nd would be (Hearing/Sounds) the 3rd would be (Stanine)
and the 4th would be Writing/Vocabulary.
The 2nd and 4th column would have scores. The teacher wants to sort by
scores to determine which student needs more help by looking at the
lower scores.
The names need to sort with the students scores.
If you could setup an example I could try out that would be awsome.
The way I gave for an example is how the spreadsheet needs to be
set-up
Any help would be greatly needed.

thanks walk12