Using Auto Complete to Fill Data in a Worksheet (Excel All Versions)

Using Auto Complete to Fill Data in a Worksheet (Excel All Versions)

If the first few characters you type in a cell match an existing entry in that column, Excel automatically enters the remaining characters for you.  Excel will only complete entries that contain text or text and numbers.  This function will not work for entries that only contain numbers.  You can turn Auto Complete OFF if makes entering data difficult.  This will work in Excel 2010, Excel 2007 and Excel 2003.

 

This post is only available to members.
Related Posts

How to Change Time Increments in Outlook Calendar

You can change the time increments shown in your Outlook calendar to allow for smaller more detailed calendar entries.  This will work in Outlook 2003, Outlook 2007, and Outlook 2010.

This post is only available to members.
Back To Top