EXCEL 2010 highlight and copy a column

[matthewR]

I am trying to highlight one column in an inherited excel spreadsheet. When I highlight the column I want to copy, as I am going down it includes the next column which I don't want. What is it doing and how can I just copy the one column?

[HansV]

I suspect that the column contains cells that are merged with the cell to the right. You can select the two columns, then on the Home tab of the ribbon, click the arrow on the right hand side of the Merge and Center button, and select Unmerge Cells from the dropdown menu. This will of course change the formatting of the sheet...

[Rudi]

Instead of merged cells its better to use center across selection. This simulates merge and center without the irritations. You can find the command in the alignment dialog in the horizontal alignment dropdown.

[matthewR]

Thank you both very much.