How can I "de-select" columns?

[Sputty]

I'm trying to insert columns but when I select a column, adjacent columns are also selected.
When I try to insert, I get the mssg:
"That command cannnot be used with selections that contain entire rows or columns, and also other cells. Try selecting only entire rows or columns or just groups of cells."

I need to "un-do" the memorised pre-select of multiple columns.
Anyone know what I am talking about?
Lynn[/i]

 

[Von Pookie]

Do you have any merged cells in the area you are trying to select?

 

[Sputty]

Do you have any merged cells in the area you are trying to select?

Hi Kristy
I don't think so but How do I idenify merged cells?

 

[Von Pookie]

As far as I know, the only way to locate merged cells--other than by searching through the sheet manually--is with a macro. I found a couple of examples here:
http://groups.google.com/group/micr...read/thread/996f5f3453a00430/a6b48862f0ee19ff

Other than that: I can not recreate the error in Excel 2002. Are you using Excel 97? I found a knowledge base article that may help:
http://support.microsoft.com/kb/156446/EN-US/

 

[Sputty]

Do you have any merged cells in the area you are trying to select?

Hi Kristy
Amazing! Thanks- you solved my problem.