#1   Report Post  
eddie57
 
Posts: n/a
Default Copy and Paste


I copied this information on a website that has rows and columns. After
I pasted the information into an excel worksheet and tried to sort the
data and got the following message, "This operation requires the merged
cells to be identically sized". Is there anything I can do that will
allow me to sort the data? Any suggestions are appreciated.

TIA

Eddie


--
eddie57
  #2   Report Post  
jahoobob
 
Posts: n/a
Default


eddie57 Wrote:
I copied this information on a website that has rows and columns. After
I pasted the information into an excel worksheet and tried to sort the
data and got the following message, "This operation requires the merged
cells to be identically sized". Is there anything I can do that will
allow me to sort the data? Any suggestions are appreciated.

TIA

Eddie

You probably have merged cells in the data you sort. You will need to
eliminate the merged cell(s) from the sort range, either by restoring
them to two or more cells to match the cells in the other rows or
deleteing the row they are in. Sometimes, if you Paste Special as Text
from websites, you get more manageable data than just pasting.


--
jahoobob
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Copy and Paste or Paste Special between Excel Workbooks wllee Excel Discussion (Misc queries) 5 April 29th 23 03:43 AM
Can't Copy and Paste foumulas? Emory Richter Excel Discussion (Misc queries) 2 October 1st 05 08:27 PM
I cannot paste from one workbook to another. Copy works, paste do. JimmyMc Excel Discussion (Misc queries) 1 June 10th 05 03:54 PM
Can't Copy and Paste between Excel 2003 Workbooks wllee Excel Discussion (Misc queries) 6 March 30th 05 02:59 PM
copy paste cell character limit Fred Excel Discussion (Misc queries) 1 December 2nd 04 08:58 PM


All times are GMT +1. The time now is 04:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"