+ Reply to Thread
Results 1 to 5 of 5

Getting headings including (but not limited to) column headers repeated automatically

  1. #1
    Registered User
    Join Date
    02-22-2014
    Location
    Teesside, England
    MS-Off Ver
    Excel 2007, 2010
    Posts
    3

    Getting headings including (but not limited to) column headers repeated automatically

    Dear All,

    I was wondering

    a) would it be possible to get a basic header above a table (as well as the table column headings) repeated on as many pages of a table as a user may care to take up when filling in content in the table - not just for printing, but as viewed on-screen? So: On the first page, some standard blurb in each of a number of boxes (cells) in certain relative positions first, followed by a table with column headers, and then for every subsequent page that the table spills over onto, the blurb header/boxes above the table repeated prior to continuation of the table (also with repetition of the column headers at the top of each new page table continuation)?

    b) if a) be possible, would it also be possible to have separate sections (/ tables) each starting on different pages, each with different header blurb at the top of the page, and with its distinctive, section-specific blurb on each continuation page of that section (as well as the repeated column headers)?

    Also, as an additional complication, the header blurb boxes on the first page of each of these sections take their input from the front cover (on a separate tab, the first tab), and in some cases, the contents are the result of a conditional statement that depends on what is filled in in a couple of boxes on the front cover.

    Whew, yeah, that's quite a lot. I hope that made sense!

    Thanks very much for your kind attention.

    Yours,


    Tim

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Getting headings including (but not limited to) column headers repeated automatically

    You can have repeated rows to show on each page and they will show up on each page as you add enough data to go to the next page. You have to be in Page Layout View to see this. If you include the header row of the table in the repeated rows, then they will show on each page as required.

    This is done in the Page Layout tab, Print Titles, Sheet tab.

    The second part of the question isn't possible as far as I can find out.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    02-22-2014
    Location
    Teesside, England
    MS-Off Ver
    Excel 2007, 2010
    Posts
    3

    Re: Getting headings including (but not limited to) column headers repeated automatically

    Thanks newdoverman,

    What you reckon can be done corresponds to what I also seem to have found. I've used it and it works; however it isn't sufficient for the ultimate purpose. In fact the latter is even worse, because as things are there also needs to be a 'bottomer' at the bottom of each page (and this also depends on which section and is conditional based on the front cover). Ouch! I'm feeling that a fundamental rethink may be required and/or give up on making this (template, actually) too sophisticated / automated.

    Thanks anyway.

    Regards,


    Tim

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Getting headings including (but not limited to) column headers repeated automatically

    Excel is a number "cruncher" and not a word processor so is lacking in some of the things that would be "nice" to have when creating reports.

    Have you thought of using a database where you can create various reports formatted the way that you want?

  5. #5
    Registered User
    Join Date
    02-22-2014
    Location
    Teesside, England
    MS-Off Ver
    Excel 2007, 2010
    Posts
    3

    Re: Getting headings including (but not limited to) column headers repeated automatically

    Thanks for that, newdoverman, that's a good suggestion. I'll bear it in mind and see if there are possibilities in that direction.

    Regards,



    Tim

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] how to copy worksheet including headers & footers
    By jmac1947 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2014, 06:41 AM
  2. Excel 2007 : Sorting columns without including headings
    By wisedave in forum Excel General
    Replies: 4
    Last Post: 06-01-2011, 11:40 AM
  3. Can headers be repeated on different worksheets in excel?
    By Tom Reynolds in forum Excel General
    Replies: 1
    Last Post: 03-02-2006, 05:00 PM
  4. [SOLVED] repeated custom headers and footers
    By Jewelz in forum Excel General
    Replies: 1
    Last Post: 08-30-2005, 05:05 PM
  5. [SOLVED] Can I invert a table so row headings are now column headings etc
    By Sharon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-10-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1