Excel Questions

How do I get Excel to repeat words in a cell when I start to enter them? What I mean is, if I've already entered the words Storage Cupboard 2 and I type St in a cell, I want it to show Storage Cupboard 2. I've got it working perfectly in several of my documents and don't remember how I got it to work. However, in one doc it doesn 't work.

I understand how it works when you've got two similar entries, eg if I already had entered Storage Shed as well it would automatically show Storage and then Shed (or cupboard 2) would be highlighted ready for me to accept or type something different.

Also, sometimes when I click on a cell, it puts the frame around several other cells as well. I can get rid of the extra by moving the mouse but it's really frustrating, particularly when trying to work quickly, and it didn't used to do it.

Can anybody help please?

Thanks.

As my truly dodgy memory recalls, autocomplete (I think that's what it is called) works if there are no blank cells in the column. If there is a blank cell then Excel will only autocomplete entries from the blank cell down. So if the Storage Cupboard 2 is above a blank cell, it won't be autocompleted below it. You can turn autocomplete on an off in Tools, Options and then the Edit tab.

You can also click on Alt + down arrow to get a pick list.

Clicking on the cell thing is ringing a vague bell but I can't think why....it may come to me []

Cheers
Kate

Thanks.

It must be because I've got blank cells in some columns. It actually works in the columns which have every cell filled.

Alt + down key works though.

It's Office 2007 so doesn't have Tools. However, Autocomplete must be somewhere & I'm sure it has been checked or it wouldn't be working in those cells that it is.

Thanks again.

Hi toast, in excel 2007 you will find a whole bunch of options by clicking on the coloured MSbutton in top left corner of the sheet, then selecting excel options bottom right corner and autocomplete is under "advanced".
Also are you aware of the auto fill capability by "pulling" the bottom right corner of a highlighted cell. You will see little black square on the corner. It is very useful when entering multiple entries. It can also be used to repeat a group of entries by highlighting the selection of cells then pulling the bottom corner of the selected series. Will repeat down a column or across a row.
Have a play.
Hope this makes sense.
I think Excel is by far the best of the MS office products, very powerful.
cheers
Dave B

Hi again, with the drag cell capability for instance, if you put "mon" in the first cell then drag across it will complete the days of the week. Very useful when doing calenders etc.
As you can tell Im an excel fan!

and you can create your own lists for autofill