HI there, Im just wondering if it is possible for excel to remember cells from workbook to workbook. What I mean is, when I type something in a cell of a workbook, whenever i start to type that into another cell it will automatically remember the word, and bring it up. (say the word was hello, when you type 'he' into another cell, it automatically fills the cell with hello.) however, if you open another workbook in the same excell spreadsheet and type the first letters, excel dosnt seem to fill it in automatically anymore. Is it possible for excel to remember all the words from other workbooks in the same spreadsheet too?

No. But you can create lists that it can remember. Tools, Options, Custom Lists. For example: It has a couple already such as Mon, Tue, Wed, Thu... or Jan, Feb, Mar and so on. If you type "Mon" in a cell and drag it down a column it will autofill Tue, Wed and so on. Similarly you can create a list such as: Tomatoes, Potatoes, Squash... or Billy, Mary, Sue, Gary and so on and these lists will do the same thing on any workbook when using the autofill feature of Excel once you create the Custom List. HTH Bryan