I have 2 excel documents. One is the 2nd part of the 1st one. When i select all in the 2nd one and click copy and/or cut , then go to the other excel and try to press paste- it doesn't work. In fact, the paste button isn't even blackened(it's grey=nothing to paste)
Help?
2007-08-30 08:05:09 · 8 answers · asked by antomicbomb91 2 in Computers & Internet ➔ Software
Select the entire sheet by clicking the button above 1 and to the right of A. Copy the cells. Switch to the sheet that you want to paste to and select cell A1. Paste the cells. Both spreadsheets must be open during the entire operation.
Alternatively you can right click on the tab that you wish to move. Select Move or Copy. Select the box at the bottom of the dialog box that says Create a Copy. From the drop down box, select the alternate workbook. Select the tab that you would like the sheet to appear before or (move to end). Be sure to select the checkbox at the bottom of the dialog or you will move the sheet, not copy the sheet.
God Bless
Frank Pytel
2007-09-02 02:18:19 · answer #1 · answered by Frank Pytel 4 · 0⤊ 0⤋
If you are trying to insert the copied cells between existing cells, then you need to do this:
1. On the Insert menu, click Copied Cells.
2. In the Insert Paste dialog box, click the direction in which you want to shift the surrounding cells.
Note: If you insert entire rows or columns, the surrounding rows and columns are shifted down and to the left.
2007-08-30 08:23:16 · answer #2 · answered by Anonymous · 0⤊ 0⤋
It's probably because the amount of cells you've copied does not equal the amount of cells that highlighted to paste. If you "select all" the cells to copy in the first document, then you need to "sellect all" the cells to paste.
When you copied the cells, did you see the border blinking? If no, you haven't copied yet.
2007-08-30 08:17:34 · answer #3 · answered by Mrs Apple 6 · 0⤊ 0⤋
Hi,
Try selecting the area where you have the actual data instead of selecting the entire document. For eg you can select from cell A1 to G90. Den CTRL + C and then go to the end of 1st doc and press CTRL+V. Hopefully dis shud work.
2007-08-30 08:16:14 · answer #4 · answered by shalakasudip 2 · 0⤊ 0⤋
You are probably trying to paste all of the cells you copied into either a lesser amount of cells or just one cell. You must select either more or the same amount of cells to paste it to as you have copied. If the buttons dont work, try to use ctrl+v to paste and ctrl+c to copy. Hope i helped.
2007-08-30 08:09:12 · answer #5 · answered by dustyalford 3 · 0⤊ 0⤋
Does the structure match exactly?
Are you copying data only (not headers)?
Are you trying to copy more than your RAM can handle?
Try to copy the data only of a couple of rows by selecting them, Edit, Copy.
Go to the other file and right-click in the first empty cell of Row A and paste.
If it works, it may just be RAM overload. It's worth a try.
2007-08-30 08:13:56 · answer #6 · answered by TheHumbleOne 7 · 0⤊ 0⤋
Copy the whole CELL and copy it and switch to other document and Select the whole CELL where you want it to be pasted and paste it.
2007-08-30 08:09:22 · answer #7 · answered by Sagun 2 · 0⤊ 0⤋
Put this code in you source.xls marco coding and specify which Range you need to copy "Range("C7:D7").Select" and paste it destination file with "Range("C7:D7").Select" done. Windows("source.xls").Activate Range("C7:D7").Select Selection.Copy Windows("Destination.xls").Activate ActiveWindow.WindowState = xlNormal Range("C7:D7").Select ActiveSheet.Paste
2016-05-17 08:09:10 · answer #8 · answered by ? 3 · 0⤊ 0⤋