ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Weird formatting of type in box (https://www.excelbanter.com/excel-discussion-misc-queries/118951-weird-formatting-type-box.html)

Marilyn

Weird formatting of type in box
 
My excel program is only typing one letter/number in a box at a time.
Each time I type a new letter/number it replaces the old letter. I
can't figure out what I accidently hit to cause this problem. It is not
in the "vertical" mode. I have restarted excel and my computer, but
nothing helps.

Any ideas would be appreciated as I am in the middle of a complicated
spread sheet.

Thanks,
Marilyn


Gord Dibben

Weird formatting of type in box
 
What do you consider as a "box"?

A cell?

If you enter a letter in a cell and hit ENTER then select that cell again and
type a letter, the first letter will be replaced.

If you wish to add letters to a cell hit F2 to enter Edit mode.


Gord Dibben MS Excel MVP

On 15 Nov 2006 13:16:49 -0800, "Marilyn" wrote:

My excel program is only typing one letter/number in a box at a time.
Each time I type a new letter/number it replaces the old letter. I
can't figure out what I accidently hit to cause this problem. It is not
in the "vertical" mode. I have restarted excel and my computer, but
nothing helps.

Any ideas would be appreciated as I am in the middle of a complicated
spread sheet.

Thanks,
Marilyn




All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com