Basic Excel question, entering data masks/cover two cells

[TerpGT]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have a basic question with respect to entering data into excel on the Mac version of Excel. When I enter data (number or text), the enter box covers the cell where the entry is going and the cell above it. How do I force Excel to just occupy the cell that I want the entry to go in? I know there must be a quick setting that corrects this issue.

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
Intel I have a basic question with respect to entering data into excel
on the Mac version of Excel. When I enter data (number or text), the
enter box covers the cell where the entry is going and the cell above
it. How do I force Excel to just occupy the cell that I want the entry
to go in? I know there must be a quick setting that corrects this issue.

I'm not sure about a setting as I don't know for sure what you are
talking about. What entry box? the one you get when you double click the
cell? The formula bar? what hapens if you simple click on the cell and
then enter the text? does it no go where you expect it to?

 

[TerpGT]

I am talking about the cell, it overlaps two cells. The text goes into the correct cell but when enter any text or numbers it covers the cell above here the data is being typed into too.

 

[TerpGT]

> I'm not sure about a setting as I don't know for sure what you are
> talking about. What entry box? the one you get when you double click the
> cell? The formula bar? what hapens if you simple click on the cell and
> then enter the text? does it no go where you expect it to?
>
> --
>
> Bobgreenblattatmsndotcom
>

I am talking about the cell, it overlaps two cells when typing. The text goes into the correct cell but when typing any text or numbers it covers the cell above too.

 

[CyberTaz]

I'm afraid I've never seen what you describe although I guess it could be
possible depending on what combination of formatting has been used. The
normal behavior, though, is for excess content in the cell to flow to the
*right* rather than *up*. If the cell has 'Wrap Text' checked in the
Alignment formatting the cell extends *down* rather than *up*.

Either way, the extension of the cell only continues until you press return
to finish the entry. This has always been the nature of how Enter & Edit
mode work, so I'm not sure exactly why it should be a problem. AFAIK, The
only ways to alter/avoid the behavior would be;

1- Type content into the Formula Bar rather than directly into a cell, or

2- Increase the column width and/or row height before typing large volumes
of content.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[TerpGT]

I'm afraid I've never seen what you describe although I guess it could be

> possible depending on what combination of formatting has been used. The
> normal behavior, though, is for excess content in the cell to flow to the
> *right* rather than *up*. If the cell has 'Wrap Text' checked in the
> Alignment formatting the cell extends *down* rather than *up*.
>
> Either way, the extension of the cell only continues until you press return
> to finish the entry. This has always been the nature of how Enter & Edit
> mode work, so I'm not sure exactly why it should be a problem. AFAIK, The
> only ways to alter/avoid the behavior would be;
>
> 1- Type content into the Formula Bar rather than directly into a cell, or
>
> 2- Increase the column width and/or row height before typing large volumes
> of content.
>
> HTH |:>)
> Bob Jones
> [MVP] Office:Mac
>
>
> On 5/3/10 11:49 AM, in article (e-mail address removed)2ac0,
> "[email protected]" wrote:
>
>
>

The issue is not about excess content but when you enter anything into any cell by double clicking on the cell “an extra cell above” is occupied above while entering data but later goes away after you move on. Nothing is ever present in the extra space above. This spreadsheet file was first created in Windows Excel XP.