Share via

Copy entire worksheet starting at a cell other than A1

Anonymous
2019-06-15T13:57:18+00:00

This seems that it should be so obvious that I'm embarrassed to be asking but...

I want to copy the entire contents of a worksheet into a different Workbook but I don't want the copy to start at A1.  

Clicking the "Arrow" at the top right selects the entire sheet.  

Right Click > Copy

Select Cell A5 (or whatever) in the target workbook

Right Click > Paste

Message -  Alert -To copy all cells from another worksheet to this worksheet, make sure you paste them into the first cell (A1 or R1C1).

But I don't want to copy it to A1!  :(

These are large worksheets so it's difficult to Drag and Select the rows which is one option.

Suggestions?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Bob Jones AKA CyberTaz MVP 434.7K Reputation points
    2019-06-15T14:20:06+00:00

    I'm not sure I understand what you are trying to do...

    If you copy an entire sheet it cannot be pasted into a smaller range. IOW, you cannot paste A1:XFD1048576 (17,179,869,184 cells) starting anywhere other than in A1 because the right & bottom portions of the copied material would extend off the sheet. No additional rows or columns can be created.

    I think what you may actually need to do is select the specific range you want to copy rather than selecting the entire sheet. The simplest way to select a range is to use the Name Box at the left end of the Formula Bar. Click in that, type the reference of the range you want to select [e.g., A1:K1000], then press return & copy the range. You then will be able to paste it anywhere on the destination sheet as long as the starting cell doesn't cause the copied content to exten off the sheet.

    20+ people found this answer helpful.
    0 comments
Answer accepted by question author
  1. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2019-06-15T14:06:27+00:00

    Hi FlyntM

    Greetings! I am Vijay, an Independent Advisor. I am here to work with you on this problem.

    Press CONTROL + FN + RIGHT ARROW to reach to the last cell in your Excel sheet. Then you can select A1 to this particular cell to select your range and copy this select range.

    This copied portion can be pasted into target workbook.

    Do let me know if you have any more question or require further help.

    10 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-06-15T14:58:58+00:00

    Got it.  It now makes sense what it's trying to do when copying the whole sheet. 

    Thanks!

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2019-06-16T16:32:39+00:00

    That works too!

    0 comments