Re: Merged cells

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I couldn't duplicate it either (still xl2003).

To eliminate any pesky addins, you could start excel in safe mode:

Close excel
windows start button|Run
excel /safe

and test what you tried.

====
And just because I don't trust anyone <bg>, can you double check this:

Open excel normally, do that same test (so it fails) and then
Help|about Microsoft Excel

What version do you see?

(I'm still hoping that you're looking at something besides version 11 (xl2003).)

R Ormerod wrote:

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


--

Dave Peterson
.

Quantcast