Thread: Merged cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
R Ormerod R Ormerod is offline
external usenet poster
 
Posts: 37
Default Merged cells

Just opened a new workbook.

Merged cells A2:C2

Tried to select column B on its own by clicking the column header and as
soon as I released the mouse the selection highlighted was columns A:C.

--
R Ormerod


"Dave Peterson" wrote:

Maybe you can share details (what range is merged) and how and what you
selected.

In my simple tests in xl2003, I couldn't duplicate your results.

R Ormerod wrote:

I am using Excel 2003 and have never seen this before until very recently -
the only cause I can think of is a few add-ins which may have affected things.

--
R Ormerod

"Dave Peterson" wrote:

I don't think so.

If I remember correctly, this was the behavior in xl97. Each version of excel
seems to behave a bit differently.

For instance, xl2003 doesn't behave this way.

R Ormerod wrote:

When I am selecting columns (e.g. to insert a single new column) above a
merged cell Excel is then selecting all the columns incorporated by the
merged cell.

I don't remember this ever happening before - is there an option somewhere
that I can change?

--
R Ormerod

--

Dave Peterson


--

Dave Peterson