Share via

Excel Copy and Paste Issues

Anonymous
2025-03-04T04:32:16+00:00

All of the sudden i asm not able to copy a row of formulas down a column. I get a popup (see below) about data pasting is not the same size. If I answer yes do it anyway it only pastes one row. So now if I want to copy a formula down several lines in a column I have to do it one row at a time which is nuts. Example - I want to copy formula from cells a1 through f1 down 20 rows in the column. I used to be able to do it no problem, now I have to do it one row at a a time. That's all Excel will let you do. Don't know why all the sudden it is doing this but it really makes using Excel very difficult and tedious. 

                           [![](https://learn-attachment.microsoft.com/api/attachments/cb6e8720-9de5-44ef-9b1c-bee25dc17af7?platform=QnA
Microsoft 365 and Office | Excel | For home | MacOS

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

Andreas Killer 144.1K Reputation points Volunteer Moderator
2025-03-04T04:52:21+00:00

Select only one cell before you paste, that way Excel determines the size of cells/formulas to paste automatically.

Andreas.

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bob Jones AKA CyberTaz MVP 436K Reputation points
    2025-03-04T18:35:47+00:00

    Other methods to consider assuming the formula is in A11:

    • Select A11 then use the Fill Handle at the lower right corner of A11 to drag down to A20, or
    • Select cells A1I:A20 then press Command+D to Fill Down, or

    Was this answer helpful?

    0 comments