Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users

Dashboard
Notifications
Mark all as read
Q&A

How can Excel recognize a merged cell's value automatically, without using absolute address?

+0
−2

Unquestionably, it's too unproductive to change the formula for C2-C4 singly. Please don't ask me to

  1. un-merge A1-A4.

  2. or use absolute address of Cell A1 ($A$1) in Cell C2 and drag the formula down. Why? Undoubtedly, this is too unproductive if column A has many cells, and if only some cells in column A are merged. Then I must manually and singly locate the merged cells, to change their formula to absolute address.

Excel with formulas preview. Cells A1-A4 are merged and contains the number '5', cells B1-B4 contain the numbers 1-4, formula in cell C2 is =A2*B2, which is showing as 0, as are cells C3 and C4. C1 also contains the number '5'. All other cells are empty.

Why does this post require moderator attention?
You might want to add some details to your flag.
Why should this post be closed?

3 comments

Could you please say, in words, what you are trying to accomplish? I for one cannot work it out from just a screenshot. (Please apply that question to other questions that are primarily screenshots.) Thanks. Monica Cellio‭ about 1 month ago

@MonicaCellio I'm trying to perform arithmetic on a number in a merged cell. VLDR‭ about 1 month ago

Could you please edit clarifications into your questions? Thanks, and sorry for not being more clear about my request. We want all the information to be in the question itself, not down in the comments where people have to hunt for it. Monica Cellio‭ about 1 month ago

0 answers

Sign up to answer this question »