Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Mango Mango is offline
external usenet poster
 
Posts: 4
Default Sorting by number

It did indeed work. However the F9 key did not update the cells/fields for
me so I did a print-preview and that did it. Then I was able to sort as I
wanted.

Thank you both. I didn't expect my request to be so involved in working
below the surface of things, so I had been very frustrated trying to
understand what was wrong or why I couldn't find an answer.

"Jay Freedman" wrote:

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.


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Emrys Davies New Users 5 May 8th 09 01:16 PM
Sorting a Table by Number Nelson Tables 1 August 2nd 08 05:17 AM
sorting Melissa Mailmerge 3 December 1st 06 01:53 PM
Can you number a column in a database and keep it from sorting jeannette Tables 3 March 20th 06 07:05 PM
Sorting mail merged labels by unique number Caledonia93514 Mailmerge 1 April 1st 05 08:23 AM


All times are GMT +1. The time now is 07:04 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"