"Selection is too large" problem

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

Luke M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The picture is too large and will be truncated 1
Font is changing when editing a cell 0
"Fields Nested Too Deeply" Error in Simple Word Document 5
CSV->Excel Data Problem 1
Copying functionality lost 1
Data selection.. 0
Problem with SET & REF function 0
Excel 2007 Selection too large 5

Top