menu
  • Register

Recent Badges

Notable Question peterlaw
Popular Question jwilliam
Lecturer amna

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

0 votes
46 views

Problem :

Need solution for bellow problem
the cell reference for the merged cell is the upper-right cell reference.
6.9k points

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.

36.1k points

Related questions

1 vote
2 answers 204 views
204 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 stewart 4k points
0 votes
1 answer 113 views
113 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
2 answers 33 views
33 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 maddi86 5.4k points
0 votes
1 answer 62 views
62 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
Dark theme