more than one column activated

[mbertel]

I am using excel 2007 and the file format is xlsm. When I click on one column header two additional columns are activated. Example: I click on column "C" header to highlight the entire column and columns "D" and "E" are highlighted. I only would like to highlight one column at a time. I have looked at settings in the office button, but did not see anything. Aprreciate any assistance on this. Thank you in advance!!!

Markus

 

[JoeMo]

You may have a macro for the sheet where you see this, or for the entire workbook, that's firing when you select a column. You can do a quick test for this by doing a SaveAs of the existing workbook using a .xlsx extension. This will be a duplicate of the current workbook with the .xlsm extension except it will not contain any macros. If the problem is resolved, you can then search for and remove the offending macro from the file with the .xlsm extension, or if you don't need a macro-enabled workbook, simply discard the file with the .xlsm extension and use the one with the .xlsx extension.

 

[Boller]

This might help :-

http://www.computing.net/answers/office/excel-click-1-cell-selects-multiple/7549.html

 

[mbertel]

So everyone can benefit. I noticed that the three columns had merged cells across the columns(Ex In columns "A" "B" and "C" two cells per column merged) I highlighed the column("A") or the column which triggered the other two columns to be highlighted automaticly and right clicked, format cells, alignnment tab and uncheck the merged cells check box. I clicked ok and I went back to column("A") clicked(either left or right) and that column was only highlighted. Hope this helps others who may or might have ran into this issue.