Excel save autocorrect entries

[Thefalcon]

Hi,

Each week I have to inventory check by filling a new table. By the end of the week I fill some entries multiple times, and excel helps me autofilling/autocorrect the cell when I type the first few words. But when I open a new table all the entries are gone again. I have to type the full word manual. Happens each week when I open a new table.

Seems like the autocorrect/fill is assigned to current table only

Is there a way the apply autocorrect to all tables?

EDIT: Basically I want to use this
[url]http://www.dummies.com/how-to/content/using-or-disabling-excel-2010s-autocomplete-featur.html[/url]

But that only works for me when entries are in same table/row/column