Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default DropDown aand Auto Fill

If you have your three (or any other) values, above or below, in same column
"continued without line-gap", then this works the way you are asking.

If its Excel 2007, then;
Click on round "Office Button" at left-top
Click on "Excel Options" at right-bottom
Click "Advanced" at left
Find & tick for "Enable AutoComplete for cell values"


If you found my answer suitable for you, please click "Yes" for my post.

Regards,
Pritesh


"Maanu" wrote:

Hi,

I have column with DropDown List.. The items are

a. Documentation
b. Logic
c. Optimization

Is there a option to automatically fill a cell, if I type the first letter
of an item?

Also when I type alt+ down arrow the list appears. I would like to fill the
cell when the first letter of an item is typed.

Is that possible?

Thanks!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Populate fields based upon dropdown selection Del Excel Discussion (Misc queries) 4 September 14th 09 09:43 PM
selecting from dropdown--have related info auto carry over Susan Excel Worksheet Functions 2 August 17th 07 02:07 PM
Auto-populate, Auto-copy or Auto-fill? Jay S. Excel Worksheet Functions 4 August 10th 07 09:04 PM
using auto fill edit or fill handel fill handle or auto fill Excel Worksheet Functions 0 February 10th 06 07:01 PM
Dropdown menu auto recognition? Patty via OfficeKB.com Excel Discussion (Misc queries) 4 August 9th 05 05:30 PM


All times are GMT +1. The time now is 08:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"