strange thing when cutting and pasting in excel

  • Thread starter Thread starter panda_biodiesel
  • Start date Start date
P

panda_biodiesel

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
 
Check that you don't have any hidden columns on the destination sheet -
the data might be copied, but you will only see 10 columns' worth if
two of them are hidden.

Hope this helps.

Pete
 
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"
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top