ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automatically finish a word I begin typing in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/262915-automatically-finish-word-i-begin-typing-excel.html)

bile

Automatically finish a word I begin typing in Excel?
 
How do you order the computer to finish off words once you've begun typing if
it's come across them already?

Dave Peterson

Automatically finish a word I begin typing in Excel?
 
Excel has a limited way of doing this.

In xl2003 menus:
Tools|Options|Edit tab|check "AutoComplete for cell values"

It uses the recent cells above the cell you're entering data as the list to
choose from.

If you only need this for a few entries, you may find that it's irritating to
toggle on/off.

You can rightclick on a cell and choose "Pick from drop-down list". It may be
sufficient for you.

bile wrote:

How do you order the computer to finish off words once you've begun typing if
it's come across them already?


--

Dave Peterson

FSt1

Automatically finish a word I begin typing in Excel?
 
hi
perhaps autocomplete?
on the menu bartoolsoptionsedit tabcheck enable autocomplete for cell
values

regards
FSt1

"bile" wrote:

How do you order the computer to finish off words once you've begun typing if
it's come across them already?



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

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