How do I keep a particular tab in Word2007 from automatically disappearing? And other Word2007 and Excel 2007 questions inside. [more inside]
posted by jujube on Dec 17, 2009 - 15 answers

Macgyver IT: I want my team to use something like del.icio.us to share links. But since this is ask.metafilter, I can't use the obvious right answer. I need to make something like it myself, using bubblegum and string the MS Office 2000 suite and my knowledge of VB. What would be my best approach? [more inside]
posted by Monday, stony Monday on Nov 19, 2009 - 7 answers

I'm looking for a job doing presentation graphics (in law firms, possibly financial firms); this is about 30% of my current job at a law firm. I'm one of very few "experts" at my firm which isn't very technologically advanced in this area, so I'm afraid that my skills won't cut it in the outside world. I need advice on how to upgrade my skills. [more inside]
posted by kenzi23 on Sep 30, 2009 - 2 answers

Excel 2007 - How do I stop the scrolling function from jumping to the top/bottom of a cell? This happens using the mouse scroll wheel, when clicking the scroll wheel and moving the mouse (free scroll type of thing), and when using the scroll bars onscreen. [more inside]
posted by Merlin144 on Jul 18, 2009 - 3 answers

Asking_for_friendFilter/ExcelFilter: I’ve built a pretty basic calculator in Excel to help people figure out how much to bill for partial months vs. full months. As you can guess, there's... [more inside]
posted by littlerobothead on Jul 8, 2009 - 2 answers

Can I download only OpenOffice Writer? [more inside]
posted by ptsampras14 on Jun 18, 2009 - 4 answers

Has anyone taken the Office Proficiency Assessment and Certification (OPAC) test recently, or have documentation on what exactly it tests for in Word and Excel? [more inside]
posted by limeswirltart on Mar 6, 2009 - 3 answers

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]
posted by cheeken on Feb 5, 2009 - 14 answers

Spreadsheet question: Display Greater Value? I know this is one of those "you-either-know-it-or-you-don't" situations, and I just don't know. [more inside]
posted by guptaxpn on Feb 5, 2009 - 6 answers

Mac OS X / Microsoft Office 2004 (Excel) crash and failed file recovery has left excel in an endless loop of restore and crash. Can anyone help me to find and delete the (unwanted) auto-saved excel sheet that is causing this problem? [more inside]
posted by urban greeting on Dec 4, 2008 - 3 answers

MS Excel Question: If I have a column with a range of dates in it, is there a formula that will tell me how many years ago that date was from today? [more inside]
posted by Rock Steady on Nov 14, 2008 - 13 answers

How do I get 'rock hard' Microsoft Office skills? [more inside]
posted by greytape on Oct 29, 2008 - 8 answers

How to do a VBA version of the following array formula in Excel? The following array formula (entered with ctrl,shift,enter) will produce the string 'Bank statement'!H842, which is the name of a cell I would like to be able to manipulate via VBA: {="'Bank statement'!H"&MATCH(C1&D$39,'Bank statement'!A:A&'Bank statement'!C:C,0)} [more inside]
posted by Mokusatsu on Oct 17, 2008 - 3 answers

Automator as an antidote to Excel tedium. Can you help me get through repetitive tasks with favorite Automator tricks in Leopard? [more inside]
posted by lackutrol on Nov 18, 2007 - 6 answers

Question on converting numbers into formatted text with Excel. [more inside]
posted by Optimus Chyme on Nov 7, 2007 - 5 answers

What's wrong with my copy of Excel 2007? [more inside]
posted by phaded on Sep 6, 2007 - 7 answers

I need help writing a macro that will divide a 5000 row table into groups of 30 rows, and find the average of certain columns in each group. [more inside]
posted by beammeup4 on Jul 2, 2007 - 10 answers

I need some really REALLY basic spreadsheet help. I've been given the task of creating a spreadsheet that will work out for us several things - how many orders we need in total and per week, how much revenue this will bring, etc. I've got most of it worked out, but I can't for the life of me how to work out percentages. Yes, I did Google this before asking. :D [more inside]
posted by Solomon on Jun 16, 2007 - 8 answers

How do I get a the rows in a table to stay clumped in fives even if I add or change the data?I have a long list of data that I need to arrange in a table, and I want the rows grouped together in fives. I'm currently working in Microsoft Word, and what I've got looks something like this Google Doc. I want the table(s) to stay grouped like this even if I add, delete, or change the data. If I just use the Word tables, adding a new line to a group will just create an extra row. [more inside]
posted by bokinney on Mar 12, 2007 - 7 answers

Help me remove unwanted spreadsheet info - I want to archive a massive buch of data from years of Excel spreadsheets but, I don't want to save all the extra gumph associated with macros and links in spreadsheets. [more inside]
posted by moocheen on Jan 15, 2007 - 10 answers

MS Excel help needed. I need to set up some sort of automated merging macro in excel and am having trouble tracking down the best way. The details, and much [more inside]
posted by chrisamiller on Dec 27, 2006 - 3 answers

Any advice for my MacBook Word / Excel / Powerpoint woes? [more inside]
posted by roofus on Sep 29, 2006 - 17 answers

MS Excel XP: What is the keyboard shortcut to highlight a cell? My searches turn up no answers.
posted by bigmusic on Jul 8, 2006 - 8 answers

Elite Tech Support Needed. Where does what's left of this plugin live? This one is elusive.... [more inside]
posted by tiamat on Feb 22, 2006 - 6 answers

PivotTableFilter: Can I have columns by month if I have the full date? [more inside]
posted by pithy comment on Jan 13, 2006 - 17 answers

Suddenly, when I double click on an Excel document to open it, it won't open the document (specific details inside): can this be fixed without reinstalling Excel or Office? [more inside]
posted by anastasiav on Jun 16, 2005 - 4 answers

When I try running long complex macros in MS Word for OS X, created in Office for Mac OS 9.2, some of the macros are freezing/crashing. Perhaps even worse, the macros don't seem to be failing at the same point each time I try to run them. [more inside]
posted by ParisParamus on Jun 15, 2005 - 1 answer

I'm working on my MA thesis and so have an enormous jumble of books, articles, and references kicking around. I am looking for an easy way to manage this. [more inside]
posted by synecdoche on May 4, 2005 - 31 answers

Embedding linked Excel 2003 worksheets in a Word 2003 document for portability is giving me pains! [mi!] [more inside]
posted by hominid211 on Feb 4, 2005 - 3 answers

Excel formula question. Using Excel as an employee scheduler and need to help trying to create a formula for tracking. [more inside]
posted by cyniczny on Feb 1, 2005 - 3 answers

How do I format cells in EXCEL to accept numeric values in the form: -26:32 (or +26:32 ... that is, mm.ss but including the pos/neg sign)? I'm trying to compile a simply list of Messier Objects (astronomy) and can't figure out how to include declinations.
posted by RavinDave on Sep 14, 2004 - 13 answers

StupidQuestionFilter:
Microsoft Excel 2000 v 9.0 - is there some way to stop excel from automatically turning email addresses into hyperlinks? Not just turning off the 'blue and underlined' format but actually not making them links. I've done it before in other versions of excel but I can't find a way to do it in this version. Thanks!
posted by anastasiav on Jul 16, 2004 - 4 answers

ExcelFilter: I've got a specific problem in mind [inside for the curious/helpful], but more importantly I'm looking for an advanced tutorial for excel. I'm looking to go from someone who is confident with excel to being a full-on pro. Books are ok, but I'd prefer internet (i.e. free) resources. I am using Office v.X for Mac, but I think most techniques will translate pretty well across platforms. I'm looking for things like recursive formulas, modeling theory, little-known tools/techniques, pivot tables, etc. [more inside]
posted by rorycberger on Jul 15, 2004 - 16 answers

Is there a way to cut'n'paste charts from Excel into Word, without generating huge Word files? I've tried varieties of paste, 'paste special,' and so on, and I can't figure out why an Excel file of charts that's several hundred KB, always turns into a Word file that's at least several MB. I guess I'm missing something obvious, but have no idea what it is.
posted by carter on Jun 24, 2004 - 8 answers