Jump to content
groovyPost Forums

Sorting problem in word 2010


Go to solution Solved by Simon H,

Recommended Posts

I made a table 4 colums wide and 4 pages long. The colum titles on each page are Name, Surname, Number, Date. I do an a to z sort on the Name column ascending and the titles on page 1 are ok. The problem is that the titles on pages 2, 3, 4 get sorted and move up the list. What sort settings do use to not sort the Name, Surname, Number, Date so they stay at the top of page 2, 3, 4.Thank you.

Link to comment
Share on other sites

  • Solution

Your sort settings are fine, this problem occurs on multiple sheet tables when the titles have been manually added to the table on additional pages.

You need to use the repeat headers function as follows:

  1. Click anywhere in the title header row on page 1
  2. Click the “layout” tab.
  3. In the “Data” Group click “Repeat Header Rows”

Now the titles that you typed at the top of the table will be automatically added to the top of each page.The A to Z sort will ignore them so they will always stay at the top of each page.

You will need to locate and delete the titles that you added manually to pages 2,3 and 4, this shouldn’t be a problem since they will now all be sorted together.

alt text

Link to comment
Share on other sites

Your sort settings are fine, this problem occurs on multiple sheet tables when the titles have been manually added to the table on additional pages.

You need to use the repeat headers function as follows:

  1. Click anywhere in the title header row on page 1
  2. Click the “layout” tab.
  3. In the “Data” Group click “Repeat Header Rows”

Now the titles that you typed at the top of the table will be automatically added to the top of each page.The A to Z sort will ignore them so they will always stay at the top of each page.

You will need to locate and delete the titles that you added manually to pages 2,3 and 4, this shouldn’t be a problem since they will now all be sorted together.

alt text

 

Great answer @simon

Link to comment
Share on other sites

Your sort settings are fine, this problem occurs on multiple sheet tables when the titles have been manually added to the table on additional pages.

You need to use the repeat headers function as follows:

  1. Click anywhere in the title header row on page 1
  2. Click the “layout” tab.
  3. In the “Data” Group click “Repeat Header Rows”

Now the titles that you typed at the top of the table will be automatically added to the top of each page.The A to Z sort will ignore them so they will always stay at the top of each page.

You will need to locate and delete the titles that you added manually to pages 2,3 and 4, this shouldn’t be a problem since they will now all be sorted together.

alt text

 

Great super answer Steve & Simon

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Similar Content

    • By Beyond_Life
      Since yesterday, Im using Office 2010 at the office. Everything is going well so far. But Im having some printing problems. We have standard letters we use. When I have to write one, I just grab an empty standard letter and fill it in. But then with printing it goes wrong. The first page of the letter needs to be printed on our office stationary (is that the correct english translation?), the seconde, thirds, fourth etcetc pages need to be printed on normal white paper. But its printing everything on office stationary, including logo's and stuff.
      If I check the options Im able to change a standard macro. But Im not able to point out which page needs to be printed on what paper. Is there a sollution?
    • By Pigletshs
      How can I convert a page/pages in Word to Publisher without losing the format?
    • By Abby
      I have a an Excel table with a high medium and low column. I want to sort items into high medium and low but the table sorts the words alphabetically so i get all the highs then the lows with the mediums at the bottom of the list.
      Is there a way to get excel to sort the column so the highs all come first followed by the mediums with the lows at the bottom of the list.
    • By The Baldy Man
      Hi,
      I manage numerous policy documents. I use a Cover Page to provide details about the policy - see example below:
      Document InformationDocument Title:
      Policy Reference:
      Version:
      Version Issue Date:
      Supersedes Version:
      Functional Area:
      Department:
      Division:
      Group Policy Officer:
      Owner:
      This information (plus more) using up the first two or three pages of the policy. Want I want to try and achieve is hvae this info part of the WORD Properties and it display at the END of the document.
      Help!
      ThanksAndrew
    • By Amit
      Hey i Encrypt one of my Msword2010 doc in Windows 7 operating system...but due to some reason i forgot my password n unable to unlock it...is there is any soln to it..pls tell me how to crack it or how can i recover my password...i was also trying word password recovery 5.0 but it unable to crack it..it's not working..pls help me out..i really need that documents..if possible send me the soln on my mail id..pls help me out man...
      Thanks Amit kumar(im.amit009@gmail.com)
  • Who's Online   0 Members, 0 Anonymous, 6 Guests (See full list)

    There are no registered users currently online

×
×
  • Create New...