Results 1 to 4 of 4

Thread: How to turn Automatic Completion on/off in Excel 2007

  1. #1
    Junior Member
    Join Date
    Aug 2017
    Posts
    9
    Rep Power
    0

    How to turn Automatic Completion on/off in Excel 2007

    My worksheets don't auto complete as I type text into cells. I have not (knowingly) turned that off. It seems to be the same for all workbooks.

    Googling yields . . . "Click the Microsoft Office Button, and then click Excel Options".

    I don't see Excel Options. I only see New, Open, Save, SaveAs, Print, Prepare, Send, Publish, Close

    Right clicking gives toolbar & ribbon choices.

    I'm using Windows 10 and Excel 2007.

    Maybe I've gone brain-dead . . . I don't understand the "Code Tags" instructions above.

  2. #2
    Senior Member DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    378
    Rep Power
    4
    Hello jarhtmd

    Code Tags:
    If you want to post a code in a Forum such as excelfox, then it is usual to use code tags.

    That means that if this is your code:

    Sub
    ‘ Anyfink
    End Sub

    Then instead of posting that, you post this

    [code]
    Sub
    ‘ Anyfink
    End Sub
    [/code]


    If you do that, then in the final posted post, you will actually see the code inside a code window like this

    Code:
    Sub
    ‘ Anyfink
    End Sub
    The code tags tell the forum software to put your code in a code window.
    The advantage of the code window is that all indent formatting is preserved, and you get scroll bars similar to what you have in the VB Editor code window.

    If you want to practice doing that sort of thing, then you should start a Thread here
    http://www.excelfox.com/forum/forumd...p/17-Test-Area
    Give the thread a title such as “Just Testing Posting techniques. No Reply needed”

    _.________________

    Excel Options

    This is how I get that for Excel 2007

    _1 Click the Microsoft Office Button,
    _2 Click Excel Options

    XL2007MicrosoftButton_1Options_2.JPG https://imgur.com/2kY2rVx
    XL2007MicrosoftButton_1Options_2.JPG

    This is how I get that for Excel 2010
    _1 Click Home Tab
    _2 Click Excel Options

    XL2010Home_1Options_2.JPG https://imgur.com/uyauCRP
    XL2010Home_1Options_2.JPG

    _.________________________________

    This is a simple code I often use to “turn everything on”.
    I am not too familiar with what auto complete actually means. I am not sure if that is “turned on” with Application.Calculation = xlCalculationAutomatic.

    Code:
    Sub Oops()
     Let Application.ScreenUpdating = True
     Let Application.Calculation = xlCalculationAutomatic
     Let Application.EnableEvents = True
     Let Application.DisplayAlerts = True
    End Sub
    If you need help on how to run that code then let me know


    Alan
    Last edited by DocAElstein; 02-12-2018 at 12:21 AM.
    Google first, like this site:ExcelFox.com "Short Title or Theme of wot you’re looking for"
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE:
    Tools for that:
    http://www.excelfox.com/forum/showth...=9821#post9821
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/

  3. #3
    Junior Member
    Join Date
    Aug 2017
    Posts
    9
    Rep Power
    0
    Thanks, Alan. I was looking right past it. As my Mom used to say, "If it had been a snake it would have bitten me". Thanks also for explaining code tags.

    Using the (newly found) Excel options, I see that "Enable AutoComplete for cell values" is checked, but still isn't working.

    Auto-complete seems to have limited capabilities. It appears (to me) that the number of cells checked is limited and all must be adjacent. Is that correct?

    My worksheet has data in colA, but only in alternating rows. Is there a way to auto-complete based on all the rows above (no matter how many) and even if some cells are empty?

  4. #4
    Senior Member DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    378
    Rep Power
    4
    Hi jarhtmd ,
    Thanks for the feedback
    Sorry I have no experience with auto complete ( to be honest I have no idea what it is .. lol.. ).
    I mostly use VBA for anything I do. I learnt to run ( badly ) before I learnt to walk, and missed out on a lot of spreadsheet things
    Hope someone else might pop by that can help further on that one.
    Alan
    Google first, like this site:ExcelFox.com "Short Title or Theme of wot you’re looking for"
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE:
    Tools for that:
    http://www.excelfox.com/forum/showth...=9821#post9821
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/

Similar Threads

  1. Automatic Email from an Excel Cell Data Entry
    By jpcedotal in forum Excel Help
    Replies: 1
    Last Post: 07-02-2015, 11:30 PM
  2. Excel 2003 Classic Menu in Excel 2007-2010
    By Excel Fox in forum Classic Menu
    Replies: 7
    Last Post: 09-10-2014, 10:59 PM
  3. Extract Outlook 2007 global address List in excel 2007
    By superman in forum Outlook Help
    Replies: 0
    Last Post: 09-03-2014, 07:45 PM
  4. Replies: 1
    Last Post: 02-14-2013, 11:38 AM
  5. Amount to Words [EXCEL 2007]
    By msiyab in forum Excel Help
    Replies: 7
    Last Post: 06-10-2012, 03:44 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •