login about faq

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.

asked Jul 19 '12 at 08:50

Yashi's gravatar image

Yashi
21114


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

answered Jul 19 '12 at 10:31

Simon%20H's gravatar image

Simon H
5.0k62683

edited Jul 19 '12 at 10:34

1

Great answer @simon

(Jul 19 '12 at 13:32) Steve Steve's gravatar image

Great super answer Steve & Simon

(Jul 20 '12 at 08:47) Yashi Yashi's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:
    [text](http://url.com/ "title")
  • image:
    ![alt text](/path/img.jpg "title")
  • numbered list:
    1. Foo
    2. Bar
  • Code:
    • Within a paragraph:
      `code`
      surround code with grave accents (backticks)
    • Code snippet:
      Select the text and use the button on the icon of zeros and ones
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×9
×3

Asked: Jul 19 '12 at 08:50

Seen: 1,961 times

Last updated: Jul 20 '12 at 08:47

groovyAnswers © 2007 - 2011 All Rights Reserved | Privacy | Contact