ExcelBanter - won't automatically repeat 1 item already entered in column?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - won't automatically repeat 1 item already entered in column? (https://www.excelbanter.com/excel-discussion-misc-queries/177272-wont-automatically-repeat-1-item-already-entered-column.html)

Debby_Jo

won't automatically repeat 1 item already entered in column?

I have a column of text but one item only will not automatically repeat, any
suggestions as to why?

Jim Thomlinson

won't automatically repeat 1 item already entered in column?

How are you repeating the text? Are you using
Format - Format Cell - Alignment - Horizontal - Fill
or are you using some other method???
--
HTH...

Jim Thomlinson

"Debby_Jo" wrote:

I have a column of text but one item only will not automatically repeat, any
suggestions as to why?

Gord Dibben

won't automatically repeat 1 item already entered in column?

Are you talling about "Autocomplete"?

Is the item within a contiguous range above or below the point at which you are
typing?

Does the item have a preceding <space ?

Gord Dibben MS Excel MVP

On Wed, 20 Feb 2008 06:46:04 -0800, Debby_Jo
wrote:

I have a column of text but one item only will not automatically repeat, any
suggestions as to why?

All times are GMT +1. The time now is 05:43 AM.