Calculated value to run across cells ??

  • Thread starter Thread starter Corey
  • Start date Start date
C

Corey

If i type text or numerical values into a cell, the value will run across
the next cells as they are empty.
If i place a formula into the cell, i cannot get the vlaue to overlay the
next empty cells ?
Why is it so?
I am using the cell in a reference in cade, and merged cells will not work.
Any solution to this ?
Corey....
 
Hi Corey,
Why is it so?
Click to expand...
This is by design. (ha ha) ;)
I am using the cell in a reference in cade, and merged cells will not
work.
Click to expand...

Try (sorry, translated from german):
Select A1:B1 with mouse
Format/Cells
then the second tab
the first selection is labeled "horizontal"
select the second from the bottom "center over selection"
press ok
type something into A1, it will be centered over both cells, no matter
if it is text or a formula.

arno
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
search across row for nearest value 4
VBA set thick borders around non empty cells in range 0
Trying to run excel vba code when cell value changes from empty to entered value. 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
want to track time while paste value in multiple column of same roe 1
If function across sheets prints value of cell 4
Scrabble Value calculation for Welsh words 0

Back
Top