The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Excel Tables question

    Discussion in 'Windows OS and Software' started by AmazingGracePlayer, Feb 17, 2013.

  1. AmazingGracePlayer

    AmazingGracePlayer Notebook Deity

    Reputations:
    236
    Messages:
    1,737
    Likes Received:
    12
    Trophy Points:
    56
    Hi guys, I have a question regarding Excel tables:

    I have a table with 2 columns x 2000 rows. I want to copy and paste this table into Word, but it adds an extra 60 pages. Is there a way to make this table split at every 50 or 100 rows so when pasted into Word, I will have multiples of 2 columns per page?
     
    AmazingGracePlayer, Feb 17, 2013
    #1
  2. TANWare

    TANWare Just This Side of Senile, I think. Super Moderator

    Reputations:
    2,548
    Messages:
    9,585
    Likes Received:
    4,997
    Trophy Points:
    431
    Maybe the best bet is too setup the page under layout with multiple columns before pasting the data to the page.
     
    TANWare, Feb 17, 2013
    #2
  3. AmazingGracePlayer

    AmazingGracePlayer Notebook Deity

    Reputations:
    236
    Messages:
    1,737
    Likes Received:
    12
    Trophy Points:
    56
    Should have tried that before I posted here, silly me. Thank you
     
    AmazingGracePlayer, Feb 18, 2013
    #3