Merging Cells with Same Values

[dineshtendulkar]

Hi Friends,

Could Anyone Help This Issue.

I am having an Excel Spreadsheet which has the values as follows

A1 = 1000
B1 =
C1 =
D1 =

(B1, C1, D1 are Nil Values)

I have Merged all these four Cells so that it displays only 1000 in the range A1:D1

But what is the problem now is

If I am using Formula

=A1 It is displaying 1000
=B1 It is displaying nil
=C1 It is displaying nil
=D1 It is displaying nil

What I need now is, all should display 1000

Is it possible in Excel, Anybody could Advice.

 

[JamesW]

Hi,

Personally I would always avoid using merged cells as you cannot reference them correctly (as you have discovered).

Merging Range A1 - D1 will set the reference to A1 only - as far as I am aware there is no way of referencing B1-D1 after merging them.