Basic Excel question, entering data masks/cover two cells

[Ter...@officeformac.com]

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]

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

[Ter...@officeformac.com]

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.

[Ter...@officeformac.com]

> On 5/3/10 9:50 AM, Ter...@officeformac.com wrote:

> 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

On 5/3/10 11:49 AM, in article 59bb7...@webcrossing.JaKIaxP2ac0,

[Ter...@officeformac.com]

> 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 59bb7...@webcrossing.JaKIaxP2ac0,

> "Ter...@officeformac.com" wrote:
>
> > 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.
>
>

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.

[alandu...@gmail.com]

Did you ever get a solution to this? I am seeing the same problem now

[Rob]

I have the same problem - it can be vertical or horizontal. Adjacent cells are blocked from view. I have a png file to show it but don't see how to attach it here. Office for Mac 16.17 (Office 365), MacOS High Sierra (10.13.6). It has happened on prior versions as well.

[alandu...@gmail.com]

I found a solution. The problem is because the font size is too big for the row. Try increasing the row height