Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    format (excel 2003)

    hi all,

    I have a 25 page table, I want to change the bottom line style, say from dotted to solid line, my question is there a way to apply the change to all pages instead of doing it page by page.

    TIA
    TIA
    dubdub

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: format (excel 2003)

    There is no really easy way to do that.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: format (excel 2003)

    Thanks Hans.
    Let me try to rephrase the question, in excel the print preview button gives the freedom to page break a table at your desired location, and my interest is to change the format of the table line at the page break line.

    Regards,
    dubdub
    TIA
    dubdub

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: format (excel 2003)

    Same answer.

  5. #5
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: format (excel 2003)

    Thanks.
    TIA
    dubdub

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: format (excel 2003)

    It doesn't have to take a lot of time to do it manually:
    - Select the last row of the first page.
    - Hold down the Ctrl key and select the last row of the second page, etc.
    - Click the Borders button on the Formatting toolbar or select the Border tab of Format | Cells...

    Alternatively, select the last row of the first page and apply the desired formatting.
    Then select the last row of the next page and press Ctrl+Y to repeat the formatting, etc.

    But if you insert, delete or move page breaks, you'll have to redo the borders.

  7. #7
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: format (excel 2003)

    Many thanks Hans.
    TIA
    dubdub

Posting Permissions

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