Hello, when entering repetitive text such as category names, I need the auto-recognition feature to work across multiple Sheet tabs. This is where you start typing the text it into a new cell and it predictively pre-fills it in for you, giving you the chance to press Enter instead of fully retyping the text. However, I haven't found a way to make it work across multiple Sheet tabs in a single Excel 2000 document. Correct me if I'm wrong, by Sheet tabs I'm referring to the bottom left of an Excel 2000 document.
I've set up a 12 Sheet tabbed spreadsheet, each Sheet tab being used as a checkbook register for a different month of the year. I enter my debit and credits, and along each row I enter a descriptive category name for type of purchase, vendor etc. I want to keep these categories the same across the different Sheets for every month, but can't always remember them from the last Sheet, and I'm always having to flip back to the last Sheet to look at exactly what I called that type of purchase last time.
Hope I didn't sound too jumbled there! I'd also like to learn how to do a summary or budget analysis kind of comparison chart annually.
Any ideas? I'm all ears, thanks!
I've set up a 12 Sheet tabbed spreadsheet, each Sheet tab being used as a checkbook register for a different month of the year. I enter my debit and credits, and along each row I enter a descriptive category name for type of purchase, vendor etc. I want to keep these categories the same across the different Sheets for every month, but can't always remember them from the last Sheet, and I'm always having to flip back to the last Sheet to look at exactly what I called that type of purchase last time.
Hope I didn't sound too jumbled there! I'd also like to learn how to do a summary or budget analysis kind of comparison chart annually.
Any ideas? I'm all ears, thanks!