PLZ Help with Excel cell format or cut/paste problem

[Debbie]

I have created a NBA game scheduler and I did copy and pasted the info
from the NBA web site. So it is about 3 pages of signal lines. Some of
the columns are all single rows across but some of them end up being
as discribbed below.

Whenever I want to copy/cut one of the cells to another cell it will
then take up 2 places.

Meaning if I copy something
----------
| | like this, it will paste
----------

----------
| | like this
| |
----------

If I cut and paste the whole row that looks like this to start out
---------- -------------- ---------- --------
| | | | |
---------- -------------- ---------- --------
it will end up looking like this. And ends up deleting whatever is on
the second row.
---------- -------------- ---------- --------
| | | | |
----------| | |--------
-------------- ----------

I tried checking the cell format and they all look the same. This is
driving me nuts, what am I doing wrong?

Thanks,
Debbie

 

[Dave Peterson]

It's difficult to be certain, but it kind of sounds like you have merged cells.

You may want to try this against a copy of your workbook.

Select the all the cells on the worksheet (Ctrl-A is a quick way)
Then Format|Cells|Alignment tab
Look for the "merged cells" checkbox
Is there a black checkmark in there? How about a grey one? Or is it blank?

If it's blank, then mergedcells aren't the problem?

If it's grey, that means that there are some cells in the selection that are
merged together. Try getting rid of that check mark.

But removing the merged cells may do a little damage to the layout of your
worksheet--you'll want to look at it before you continue (and save).

(If that mergedcells checkbox were black, then that would mean the selection
(the whole workbook since you did a ctrl-A was merged--it would only look like
one cell--so that shouldn't happen).)

 

[Debbie]

I found out that it was exactly what was going on. I checked the
format again and it was the "Merge Cell" that was check on the one's I
was having problems with.

Thanks,
Debbie