strange thing when cutting and pasting in excel

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
 
P

Pete_UK

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
 
B

Bernard Liengme

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"
 
P

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.
 
Top