office suite excel

  charlie12 11:33 06 Nov 03
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 03

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

  pj123 11:46 06 Nov 03

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 03

Sorry Taff36 you beat me to it.

  charlie12 10:44 09 Nov 03

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 03

In Excel, Help/About

What version does it say you have?

  charlie12 11:07 09 Nov 03

i have version 5

  VoG II 11:37 09 Nov 03

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

  charlie12 11:49 09 Nov 03

in that case i would be better off reinstalling 2000!

  VoG II 11:49 09 Nov 03

Definitely!

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

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

How to install MacOS Sierra on an older Mac: Get Sierra running on Macs & MacBooks from before 2009