I unpacked a bunch of boxes, took photos of what was inside, and then packed them back up. I would like to create a simple inventory of the boxes with columns for box #, a photo of the contents, and a description of the contents. Here is sort of an idea of what I am trying to accomplish. [more inside]
I am using Excel 2011 on Mac OS X Lion. I have a workbook created by a colleague with 25 worksheets in it. I would like to export all of these to individual csv files. Is there a way to do it all in one batch? [more inside]
I'm on a mac. A colleague sent me an Excel file (.xls) which I looked at in Excel 2011. It looks fine. I would like to save the file in some sort of text format, so that I can open Terminal and look at it in less. I realize that the columns won't align nicely, that's fine. What I don't want are all the weird characters that show up (from differently formatted line endings, etc). I've tried saving as "Tab delimited text," but that has the problem with the line endings. Which format should I use?
Excel-Filter: I am using Excel 2011 (for Mac, if it matters). I want to create a simple X-Y chart of two columns. That's it. Should be simple. But I must be missing something. [more inside]
Excel 2011: How do I create custom styles for Conditional Formatting? [more inside]
In Excel 2011 for Mac, everything slows to a crawl if I cut or copy a large number of cells. Is there any way to fix this? If not, is there a different spreadsheet program that could do this quickly? [more inside]
How can I find common words in two (or more) lists? [more inside]
How can I compare the text in two excel cells for common terms? [more inside]
Why would Excel 2008 cause a lot of network traffic while typing in a cell? [more inside]
My main computer is a Mac (iBook) and I use the Address Book and Apple Mail. I also manage the email list for a group, and I need to be able to export the list of email addresses to either Excel (preferably) or Word. I haven't figured out how to do that. [more inside]
Why is Excel so incredibly slow on my Mac? [more inside]
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]
My parents just bought a MacBook to replace their ailing old PC laptops. They do their business management in Excel 2003 on those machines, but want to switch to 2008. This process is apparently an exercise in frustration. [more inside]
Excel filter-filter: How do I set up an easily adjustable filter for a 7000-odd row spreadsheet in Excel Mac 2004 or 2008? The data's not well organised and needs to be filtered over multiple columns. [more inside]
How do I add x and y axis labels to a chart in Excel 2008 for Macs? [more inside]
Probably ridiculously obvious Excel question: how do I set it so that a URL is never turned into a hyperlink? [more inside]
I need help finding or creating a macro to transliterate Cyrillic characters to their Latin-alphabet, English-language "equivalents" without doing a massive find-and-replace by hand. [more inside]
Is there a plug-in or macro for Excel v.X or Excel 2004 for Macintosh that adds PivotChart (from Excel 2003 for Windows) functionality or compatibility?
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]
I've recently realized that Crystal Ball is incredibly powerful and cool. Unfortunately, it isn't available on a mac. Anybody know of equivalent software/plugins for the Mac version of Excel?
Using Excel 2001 for Mac, is there any way to set up a column that can autocomplete using data from another column? If not, is there something that can handle this sort of thing?