Forum home » Delegate support and help forum » Microsoft Excel Training and help » Autocomplete

Autocomplete

ResolvedVersion 2007

Wed 8 Oct 2008, 17:16 Delegate Mary said...

Mary has attended:
Excel Introduction course

Autocomplete

How can I switch off this function (it fills in postcodes incorrectly!)

Fri 24 Oct 2008, 15:56 Trainer David said...

RE: Autocomplete

Hi Mary

You can turn it off by going to Tools - Options.
Select the Edit tab.
Remove the tick from next to the "Enable AutoComplete for cell values" option.
Click OK.

Hope that helps.
David

Mon 27 Oct 2008, 10:16 Delegate Mary said...

RE: Autocomplete

I think your tip referred to an earlier version of Excel. As I am using Excel 2007 this command was not that easy to find but I have now located it via the Microsoft office button and then Excel options/ advanced.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips

Autocomplete

Autocomplete

RE: Autocomplete

RE: Autocomplete

Excel articles

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines