+ Reply to Thread
Results 1 to 6 of 6

Formatting Table duplication

  1. #1
    Forum Contributor
    Join Date
    01-18-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    641

    Formatting Table duplication

    I have three identical tables down the left-hand side of the page , and am trying to paste another identical three next to them.

    Whatever I do , they just won't paste or copy correctly. They lose their formatting every time. I'm hoping someone can put me out of my misery.

    The outcome should be 6 tables on the page , three on the left and three on the right , with a space between.

    Can someone advise? I'll attach a sample document.

    Grateful for any help.

    Attached Files Attached Files
    Last edited by CDandVinyl; 12-29-2020 at 05:27 PM.
    Using Excel , Word and Access 2003 - For the whole of 2024

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,088

    Re: Formatting Table duplication

    Go to the bottom of the page and press Enter to start a second page. Insert a new Table, three across by five deep. Adjust the column widths as necessary; I set them to 3.5, 0.3 and 3.5 respectively.

    Select one of your Tables and copy it. Now select the top left cell of the new Table and paste the original Table. Repeat the paste for top right, middle left, middle right, bottom left and bottom right. You should now have six copies of your original Table with blank rows and column separating them. Select the new Table and remove the borders.

    Fine tune as required.

    See the updated example.
    Attached Files Attached Files
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    01-18-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    641

    Re: Formatting Table duplication

    Many thanks - that's perfect. Problem solved!


  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,088

    Re: Formatting Table duplication

    I've adjusted the alignment of the cells in your original Table. See if you like it.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    01-18-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    641

    Re: Formatting Table duplication

    Yes , good idea. Much neater , I agree.


  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,088

    Re: Formatting Table duplication

    You're welcome. Thanks for the rep.

+ 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. Replies: 3
    Last Post: 11-20-2020, 01:09 PM
  2. Conditional Formatting - Duplication Values
    By ionelz in forum Excel General
    Replies: 1
    Last Post: 03-29-2020, 12:34 PM
  3. Conditional Formatting - duplication icons across another range
    By Tacalabala in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-04-2018, 04:03 AM
  4. [SOLVED] Conditional formatting for duplication - Two columns are involved
    By RookA1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-30-2017, 02:13 PM
  5. Formatting and Duplication Questions
    By senjoim in forum Excel General
    Replies: 0
    Last Post: 02-21-2015, 03:26 PM
  6. Duplication in rows condional formatting
    By MAXIM in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-11-2010, 11:53 AM
  7. Record Duplication & Formatting Advise Please.....
    By Dermot in forum Excel General
    Replies: 9
    Last Post: 11-12-2005, 12:15 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