error on spreadsheet

K

Kp7131

I am copying a large spreadsheet - I am getting an error.
THIS OPERATION REQUIRES THE MERGED CELLS TO BE IDENTICALLY SIZED

CAN ANYONE TELL ME WHAT THIS MEANS?

I WOULD APPRECIATE IT.

THANK YOU

KP
 
F

FSt1

hi
somewhere on the large spreadsheet that you are coping are merged cells.
you can copy merged cells but you can only paste the merged cells in merged
cells of the same size. excel rule.
solution.
1. find and un-merge the cells on the copy sheet
2. set up merged cells on the paste sheet - same size-same place.

note: this is one reason i recomment that merged cells NOT me used.

regards
FSt1
 

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

sorting problems - error message: identically sized merged cells. 2
sorting merged cell question 1
trying to sort excel data. won't allow. merged cells sizing.?? 2
Problems sorting spreadsheet - Please Help 6
Sorting Rows 2
how can I find merged cells in a large xl-file 5
Can't copy & paste - "merged cells must be identically sized" 2
Excel 07 Sort & Filter A to Z 2

Top