Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Create automatic bottom border at page break in table

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Cape Town South Africa
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    I work with tables that are varying in length between 10 and 100 pages.

    I am trying to figure how to automatically create a bottom border to the table at each page break. It is time consuming to do it manually ech time a row is removed or added within the table.

    To further complicate this, I use the top 5 rows as Print Titles. These rows are of varying heights.

    Thanks

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I know this might sound simplistic...but I would just set up a custom footer under page setup using all underscores (centered)
    ______________________________________

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Cape Town South Africa
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Thanks for replying.

    I have tried that before, but the problem with an underline in the footer is that the page width (in this case) is "print-to-fit". This means of underlining in the footer is wider than the actual table width.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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