Excel Questions

More
11 years 11 months ago #23763 by Toast
Excel Questions was created by Toast
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.

[SIGPIC][/SIGPIC]Toast is the best food in the world
Whisky is the best drink in the world

Please Log in or Create an account to join the conversation.

More
11 years 11 months ago #337930 by kate
Replied by kate on topic Excel Questions
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 [:I]

Cheers
Kate

Web Goddess

Please Log in or Create an account to join the conversation.

More
11 years 11 months ago #337935 by Toast
Replied by Toast on topic Excel Questions
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.

[SIGPIC][/SIGPIC]Toast is the best food in the world
Whisky is the best drink in the world

Please Log in or Create an account to join the conversation.

  • Doin' the BOP
  • Doin' the BOP's Avatar
11 years 10 months ago #338966 by Doin' the BOP
Replied by Doin' the BOP on topic Excel Questions
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

Please Log in or Create an account to join the conversation.

  • Doin' the BOP
  • Doin' the BOP's Avatar
11 years 10 months ago #338968 by Doin' the BOP
Replied by Doin' the BOP on topic Excel Questions
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!
:D

Please Log in or Create an account to join the conversation.

More
11 years 10 months ago #338973 by kate
Replied by kate on topic Excel Questions
and you can create your own lists for autofill :D :D

Web Goddess

Please Log in or Create an account to join the conversation.

Time to create page: 0.159 seconds