office suite excel

  charlie12 11:33 06 Nov 2003
Locked

with excel from the office suite why does it not remember previous text i.e in 2000 after typing the first three letters of repeated text in cells it would automatically insert the text for you to accept or change

  Taff36 11:43 06 Nov 2003

Try TOOLS > OPTIONS > EDIT tab and ensure the "Enable autocompleter" box is ticked.

  pj123 11:46 06 Nov 2003

I am using Office 2000 and my Excel "fills in" for me. I installed it "as is" with no customisaton. In Tools, Options on the Edit tab there is a box for "Enable AutoComplete for Cell Values" is that ticked?

  pj123 11:47 06 Nov 2003

Sorry Taff36 you beat me to it.

  charlie12 10:44 09 Nov 2003

could not find auto complete on tools so looked at what version of office i had (still got my L plates on) i have office 4-3 proffessional not 2000

  VoG II 10:52 09 Nov 2003

In Excel, Help/About

What version does it say you have?

  charlie12 11:07 09 Nov 2003

i have version 5

  VoG II 11:37 09 Nov 2003

Excel 5 is now rather old. It does not have the AutoComplete feature which was introduced in Excel 97.

  charlie12 11:49 09 Nov 2003

in that case i would be better off reinstalling 2000!

  VoG II 11:49 09 Nov 2003

Definitely!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017