Repetitive Formatting

[BJS]

Not sure my terminology above is correct but when i am using Excel 2010 and inputing in a worksheet, some columns when inserting the same text as already contained in that column, the information comes up automatically as soon as I type in 1 or 2 of the letters but in other columns in the same worksheet I have to still insert the information in full. Thanks for any help

[ABerrant]

Excel's cell AutoComplete feature occassionally misfires but it is meant to predict text using the previously input text (not numbers) within the same column from cells above the active cell. Any blank cells in the column break the link to the text above them. I do not know the limit of cells which can be accessed to provide the list of text.

[SeaJayPea]

Yes, it only works for text in the relevant column, not all over the spreadsheet.

Or rather, that's the only way I can make it do it!!!

[BJS]

Thanks for the replies. How can I switch on the Auto Complete feature for a column or better still for the whole worksheet/book. Have tried looking for myself but am having serious problem with my eyesight at present so any pointer would be welcome.