That's why I asked how you do your copy and paste. I highlighted the table in Word, right clicked and chose 'Copy', then went to Excel, right clicked on Cell A1 and chose 'Paste'. Worked fine every time. To have the headings going down the column sounds like you've transposed the data. Or are you trying to actually import the Word table?