"Selection is too large" problem

  • Thread starter Thread starter Alan Howes
  • Start date Start date
A

Alan Howes

I'm getting this message when copying two cells to an area 36x2 cells in MS
Excel 2007, in a workbook of about 5 Mb.

I can work round by (say) copying 1x2 into 4x2, then 4x2 into 36x2 - but
this should not be happening! It's not the first time I've had this, but it's
not a problem I always have.
 
This problem most often occurs when you try to "select" too many
discontinuous cells. Are you copying/pasting merged cells? This is the most
common cause.
 
Back
Top