+ Reply to Thread
Results 1 to 3 of 3

strange thing when cutting and pasting in excel

Hybrid View

  1. #1
    Registered User
    Join Date
    03-27-2006
    Posts
    2

    strange thing when cutting and pasting in excel

    HI,

    I am dealing with a block of data that is 8X12. The data is generated on a networked piece of lab equipment and I save the results into my folder. When I get back to my workstation to retrieve the data, I open the folder and then perform "move or copy" to copy this opened worksheet into another workbook. Then I copy data from one worksheet to another in the same notebook so I can arrange the data. The strange thing is when I highlight the block of data and copy and then move to the other worksheet and paste only 10 of the columns are pasted. I need to return to the previous worksheet and copy the remaining two columns and paste them separate.

    Why does excel only copy 10 columns at a time?

    Thanks,

    pand_biodiesel

  2. #2
    Bernard Liengme
    Guest

    Re: strange thing when cutting and pasting in excel

    Please clarify terms "folder", "notebook", "move or copy"
    Is the original data collected in an Excel workbook?
    Are you doing a simple Copy and Paste to another Excel workbook?
    We want to help but the question is a little unclear.
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "panda_biodiesel"
    <[email protected]> wrote in
    message news:[email protected]...
    >
    > HI,
    >
    > I am dealing with a block of data that is 8X12. The data is generated
    > on a networked piece of lab equipment and I save the results into my
    > folder. When I get back to my workstation to retrieve the data, I open
    > the folder and then perform "move or copy" to copy this opened worksheet
    > into another workbook. Then I copy data from one worksheet to another
    > in the same notebook so I can arrange the data. The strange thing is
    > when I highlight the block of data and copy and then move to the other
    > worksheet and paste only 10 of the columns are pasted. I need to
    > return to the previous worksheet and copy the remaining two columns and
    > paste them separate.
    >
    > Why does excel only copy 10 columns at a time?
    >
    > Thanks,
    >
    > pand_biodiesel
    >
    >
    > --
    > panda_biodiesel
    > ------------------------------------------------------------------------
    > panda_biodiesel's Profile:
    > http://www.excelforum.com/member.php...o&userid=32866
    > View this thread: http://www.excelforum.com/showthread...hreadid=526749
    >




  3. #3
    Registered User
    Join Date
    03-27-2006
    Posts
    2

    copy/paste

    Folder refers to my personal folder when I log into my organization's system.

    Sorry, I used the wrong terminology. I create an Excel workbook to organize my data.

    I right-click on the worksheet I want to move to another workbook. I check the "create copy" and select my other book.

    I export from the software application directly to Excel.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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