EXCEL 2010 highlight and copy a column
-
- 5StarLounger
- Posts: 627
- Joined: 03 Feb 2010, 15:02
EXCEL 2010 highlight and copy a column
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?
-
- Administrator
- Posts: 78534
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: EXCEL 2010 highlight and copy a column
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...
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: EXCEL 2010 highlight and copy a column
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.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 5StarLounger
- Posts: 627
- Joined: 03 Feb 2010, 15:02
Re: EXCEL 2010 highlight and copy a column
Thank you both very much.