Need help setting up a simple Access database. I'm trying to reconcile a bunch of inventory, which is all recorded in multiple Excel spreadsheets. I want to import all the Excel files into an Access database so I can match them up all at the same time. [more inside]
Need list of trade publications. Found huge one on Ulrich's web. How can I remove all information except for the (hyperlinked) titles, ideally in a way that keeps the titles on separate lines so I can then paste them into Excel? [more inside]
I need MS Excel and Word to play together nicely. I can do what I need to in Word, and I can do what I need to in Excel; it's the Relationship that's Complicated. Maybe I need workflow advice? Basic knowledge? Please, please keep reading. [more inside]
Very average PC user here. The MS Excel document I use everyday has become huge over time. One sheet with 6 columns going down more than 4000 lines. It weighs 7,6 Mbyte. Too much? [more inside]
I've done something odd to Excel. Please help! (more inside) [more inside]
MS Excel XP: What is the keyboard shortcut to highlight a cell? My searches turn up no answers.