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? |
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 |
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