ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why doesn't the automatic fill feature work in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/87701-why-doesnt-automatic-fill-feature-work-excel.html)

JenniferO

Why doesn't the automatic fill feature work in excel?
 
When I start typing text into a cell, isn't excel supposed to automatically
fill the cell with the completed word or phrase it it's already been used in
the same column?
This seems to only work sporadically for me. Has anyone else had this
problem?

Paul B

Why doesn't the automatic fill feature work in excel?
 
Jennifer, do you have any blank cells between your data?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JenniferO" wrote in message
...
When I start typing text into a cell, isn't excel supposed to
automatically
fill the cell with the completed word or phrase it it's already been used
in
the same column?
This seems to only work sporadically for me. Has anyone else had this
problem?




JenniferO

Why doesn't the automatic fill feature work in excel?
 
Yes, there are blank cells in the column.

"Paul B" wrote:

Jennifer, do you have any blank cells between your data?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JenniferO" wrote in message
...
When I start typing text into a cell, isn't excel supposed to
automatically
fill the cell with the completed word or phrase it it's already been used
in
the same column?
This seems to only work sporadically for me. Has anyone else had this
problem?





Paul B

Why doesn't the automatic fill feature work in excel?
 
Jennifer, autofill will only work up to the blank cells
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JenniferO" wrote in message
...
Yes, there are blank cells in the column.

"Paul B" wrote:

Jennifer, do you have any blank cells between your data?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JenniferO" wrote in message
...
When I start typing text into a cell, isn't excel supposed to
automatically
fill the cell with the completed word or phrase it it's already been
used
in
the same column?
This seems to only work sporadically for me. Has anyone else had this
problem?







JenniferO

Why doesn't the automatic fill feature work in excel?
 
Paul, Never would have guessed that. Thanks for the information!

"Paul B" wrote:

Jennifer, autofill will only work up to the blank cells
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JenniferO" wrote in message
...
Yes, there are blank cells in the column.

"Paul B" wrote:

Jennifer, do you have any blank cells between your data?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JenniferO" wrote in message
...
When I start typing text into a cell, isn't excel supposed to
automatically
fill the cell with the completed word or phrase it it's already been
used
in
the same column?
This seems to only work sporadically for me. Has anyone else had this
problem?








All times are GMT +1. The time now is 03:38 PM.

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