ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   data in cell repeating (https://www.excelbanter.com/excel-discussion-misc-queries/204088-data-cell-repeating.html)

Michele

data in cell repeating
 
I am trying to assist a coworker with a problem, but I am stumped. When they
are entering data into a cell, it is automatically repeating in the same
cell. For example, if they type Directive, the cell with display
DirectiveDirective. When I double clicked on the cell to edit, Directive
would only appear once. I can delete the cell entirely, but this probem
continually occurs with them. Does anyone know why this is occurring?

Mike H

data in cell repeating
 
Hi,

Is it just the word 'Directive' that does this?
If so have a look in
Tools|Auto Correct Options
Type Directive in the left box and see if something appears in the right. If
it does delete the auto correction.

Mike

"Michele" wrote:

I am trying to assist a coworker with a problem, but I am stumped. When they
are entering data into a cell, it is automatically repeating in the same
cell. For example, if they type Directive, the cell with display
DirectiveDirective. When I double clicked on the cell to edit, Directive
would only appear once. I can delete the cell entirely, but this probem
continually occurs with them. Does anyone know why this is occurring?


RagDyeR

data in cell repeating
 
It sounds as though the "Fill" format has been applied to the cell(s) by
accident or by design, perhaps as a joke.

Click in the "bad" cell and from the Menu Bar:

<Format <Cells <Alignment tab,
and see if the Horizontal window displays "Fill:.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Michele" wrote in message
...
I am trying to assist a coworker with a problem, but I am stumped. When
they
are entering data into a cell, it is automatically repeating in the same
cell. For example, if they type Directive, the cell with display
DirectiveDirective. When I double clicked on the cell to edit, Directive
would only appear once. I can delete the cell entirely, but this probem
continually occurs with them. Does anyone know why this is occurring?



Michele

data in cell repeating
 
That was it! Such a simple fix, and I was stumped for a half hour! :)
Thanks for everyone's help!

"RagDyeR" wrote:

It sounds as though the "Fill" format has been applied to the cell(s) by
accident or by design, perhaps as a joke.

Click in the "bad" cell and from the Menu Bar:

<Format <Cells <Alignment tab,
and see if the Horizontal window displays "Fill:.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Michele" wrote in message
...
I am trying to assist a coworker with a problem, but I am stumped. When
they
are entering data into a cell, it is automatically repeating in the same
cell. For example, if they type Directive, the cell with display
DirectiveDirective. When I double clicked on the cell to edit, Directive
would only appear once. I can delete the cell entirely, but this probem
continually occurs with them. Does anyone know why this is occurring?




RagDyeR

data in cell repeating
 
You're welcome. and thank you for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Michele" wrote in message
...
That was it! Such a simple fix, and I was stumped for a half hour! :)
Thanks for everyone's help!

"RagDyeR" wrote:

It sounds as though the "Fill" format has been applied to the cell(s) by
accident or by design, perhaps as a joke.

Click in the "bad" cell and from the Menu Bar:

<Format <Cells <Alignment tab,
and see if the Horizontal window displays "Fill:.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Michele" wrote in message
...
I am trying to assist a coworker with a problem, but I am stumped. When
they
are entering data into a cell, it is automatically repeating in the same
cell. For example, if they type Directive, the cell with display
DirectiveDirective. When I double clicked on the cell to edit, Directive
would only appear once. I can delete the cell entirely, but this probem
continually occurs with them. Does anyone know why this is occurring?







All times are GMT +1. The time now is 05:26 PM.

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