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?
posted by bluefly
on Aug 16, 2012 -
9 answers
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]
posted by vacapinta
on Mar 12, 2012 -
3 answers
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]
posted by eisenkr
on Jan 20, 2011 -
14 answers
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]
posted by bibbit
on Apr 13, 2009 -
2 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
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]
posted by wumpus
on Oct 21, 2008 -
8 answers
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]
posted by Magnakai
on Mar 20, 2008 -
5 answers
Probably ridiculously obvious Excel question: how do I set it so that a URL is
never turned into a hyperlink?
[more inside]
posted by Dreama
on Dec 19, 2007 -
7 answers
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]
posted by michaelkuznet
on Sep 1, 2005 -
5 answers
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?
posted by AlexReynolds
on Jan 13, 2005 -
2 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
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?
posted by rorycberger
on Jun 18, 2004 -
4 answers
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?
posted by the biscuit man
on Apr 25, 2004 -
6 answers
