View Single Post
  #4   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Sorting by number

A much more sensible solution than my attempt!

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Jay Freedman" wrote in message
...
I'm not sure which "numbering function" you're using (there are several),
but
remove it and try this instead:

- In the first cell of the column, use Insert Field and choose the Seq
field
name. In the "advanced field properties" box of the dialog, after the
letters
SEQ and the space character, type any letter. Click OK.

- Copy the first cell to the clipboard. Select the whole column and paste.
You
should now see the number 1 in each cell of the column. Press the F9 key
to
update all the fields, and they'll become sequential numbers.

- Use Table Sort and choose to sort by that column, in descending order.

If you update fields again (which usually happens when you print or
print-preview), the Seq fields will renumber themselves in ascending
order,
although the rest of the table won't change. If you don't want that to
happen,
select the whole table (before or after sorting) and press Ctrl+F11 to
lock the
fields, or press Ctrl+Shift+F9 to "unlink" (change them to plain text).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so all
may benefit.

On Sat, 9 May 2009 08:12:01 -0700, Mango
wrote:

If I number a long column of cells by clicking the numbering function, I
am
unable to sort the cells by those automatically inserted numbers.

I'm trying to reverse the order of the cells displayed by my table.

For instance I have a table of daily data. I want to use the numbering
function to identify the cells and then reverse the order in which they
are
displayed by sorting them in descending order (from the highest or last
number to the first) But Word won't sort numbers I assign to the column
of
data.

If, however, I manually number an empty column one cell at a time, Word
will
sort the column (and each row of cells associated with it) by number. But
that process is much too slow.