• Register
0 votes
180 views

Problem :

Need solution for bellow problem
the cell reference for the merged cell is the upper-right cell reference.
6 5 3
6,930 points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

The statement  "the cell reference for the merged cell is the upper-right cell reference" is incorrect.

Ussually the reference for a set of merged cells in Microsoft Excel is the top left cell. And any content that was present in this cell before merging will be distributed into the new large cell, also after splitting the cells, all of the content is shifted into the top left cell.

9 7 4
38,600 points

Related questions

0 votes
1 answer 3 views
3 views
Problem: I'm trying to reference another sheet in excel, particularly merged cells. Everytime I do = (cell from another sheet) it says #value. I've turned format to General already, this hasn't worked.
asked 4 days ago muktaa 34.4k points
0 votes
1 answer 1 view
1 view
Problem: Please help me … how can I solve it? google sheets highlight row based on cell
asked Mar 26 Ifra 34.7k points
0 votes
1 answer 31 views
31 views
Problem: string data, right truncated: 1406 data too long for column.
asked Feb 17 Ethan ross 2.7k points
0 votes
1 answer 3 views
3 views
Problem: Copy multiple rows of cells in excel and paste them as multiple rows in a textbox in excel.When I copy multiple rows in excel and paste them in a text box, they get pasted in a single line. Are there ways to keep the multiple lines?
asked Apr 12 sumaiya simi 43.9k points
1 vote
1 answer 6 views
6 views
Problem: How to store number as text in excel ?
asked Mar 6 Raj Tyagi 14.4k points
0 votes
1 answer 6 views
6 views
Problem: I have this date format: 2011-09-28 18:01:00 (in varchar), and I want to convert it to DateTime changing to this format 28-09-2011 18:01:00. How can I do it?
asked Apr 20 ummesalma 29.2k points
0 votes
1 answer 13 views
13 views
Problem: Please solve it … Because I am unable to find out the solution... Java format float to 2 decimal places
asked Mar 25 Ifra 34.7k points
0 votes
1 answer 5 views
5 views
Problem: Can anyone tell me what dose excel reference another workbook based on cell value mean?
asked Apr 26 salim1 60.6k points
0 votes
1 answer 4 views
4 views
Problem: Does anyone know about Excel reference cell in another sheet dynamically ?
asked Apr 26 salim1 60.6k points
0 votes
1 answer 3 views
3 views
Problem: anyone who know this problem please help? a formula in a cell that contains a reference back to itself
asked Apr 12 Rohit kr 17.5k points