menu
  • Register

the cell reference for the merged cell is the upper-right cell reference.

0 votes
104 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

1 vote
2 answers 1K views
1K views
Integer constraint cell reference must include only variable cells.
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
215 views
Something went wrong and we can't sign you in right now. please try again later. microsoft
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
4 views
read text file and display in html using javascript
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
62 views
A database is used instead of a spreadsheet when ________?
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
73 views
Installation of the proof of purchase from the acpi table failed. error code: 0xc004f057
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
12 views
Export data to excel in php example
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
7 views
I need detail about new data type in Excel
asked Oct 6, 2020 miki 1.9k points
0 votes
1 answer 14 views
14 views
how to write data into excel sheet using selenium webdriver
asked Sep 6, 2020 Jack Ryan 2.4k points
0 votes
1 answer 11 views
11 views
Convert a numerical number to an Excel column name in C#
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
Dark theme