• Register
0 votes

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

1 vote
2 answers 1K views
Problem : I am very new to VBA. Recently I was using VBA code to execute the solver. On executing my VBA code I am facing below error. Integer constraint cell reference must include only variable cells . I wanted my cells C87:K93 as integers but somehow my constraints ... ="0"    SolverOk SetCell:="$N$95", MaxMinVal:=1, ValueOf:="0", ByChange:="$C$87:$K$93"    SolverSolve UserFinish:=True End Sub
asked May 9, 2020 stewart 4k points
0 votes
1 answer 215 views
Problem : I am having the following error whenever I am trying to open Excel Online in Chrome, But Excel Online in Safari is working fine for me. Does anyone know how to fix this issue? Sign in Something went wrong and we can't sign you in ... . Please try again later. The Microsoft account login server has detected too many repeated authentication attempts. Please wait a moment and try again.
asked Nov 26, 2019 alecxe 7.5k points
0 votes
1 answer 4 views
Problem: I have a project that requires me to display any text file that I browse into my page. How to do this using javascript?
asked Nov 4, 2020 robin_gallo 420 points
0 votes
2 answers 62 views
Problem: Can anyone give the right solution by filling in the blanks? A database is used instead of a spreadsheet when ________? A) lists of data involve a single theme B) structures of data lists are simple C) lists involve data with multiple themes D) users do not want to store all data in one place
asked Feb 23, 2020 maddi86 5.4k points
0 votes
1 answer 73 views
Problem : We have a few Windows Desktop Apps written in VB.2010 and VB.2017 that have been running for quite a while at numerous clients. At that point a week ago Tues, Nov 13, 2018 we began getting clients messages and considers saying the applications are getting a mistake 1004/ ... are real. I am certain this is a MS bug. Would someone be able to point me the correct way and ideally a MS fix?
asked Nov 29, 2019 alecxe 7.5k points
0 votes
1 answer 12 views
Problem I am developing some application using PHP, HTML and JavaScript. Now I am developing a feature, which will expose to user a download button, upon clicking it, server executes MySql query (I am using MySql as data base) and from data base response a file report is ... : “Hey, this is CSV you can open it with Excel!”. Tried to use “echo” it did not help a lot.
asked Dec 4, 2020 alexh 2.2k points
1 vote
1 answer 7 views
0 votes
1 answer 14 views
0 votes
1 answer 11 views
How do you convert a numerical number to an Excel column name in C# without using automation getting the value directly from Excel.?
asked Aug 28, 2020 Aliza313 720 points