Join 3,497 readers in helping fund MetaFilter (Hide)

21 posts tagged with excel and mac. (View popular tags)
Displaying 1 through 21 of 21. Subscribe:

How to add multiple images at a time in Excel

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]
posted by thebrokenmuse on Mar 25, 2014 - 1 answer

How to Export All Sheets in an Excel File?

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]
posted by bluefly on Jul 22, 2013 - 2 answers

How do I save to a text file in Excel 2011?

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

Dumb Excel question

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

EXCELerate My Workflow

Excel 2011: How do I create custom styles for Conditional Formatting? [more inside]
posted by 47triple2 on Mar 15, 2011 - 2 answers

How to copy and paste quickly in Excel 2011 for Mac.

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

How can I find common words in two lists?

How can I find common words in two (or more) lists? [more inside]
posted by pantufla on Dec 13, 2010 - 9 answers

How can I compare the text in two excel cells for common terms?

How can I compare the text in two excel cells for common terms? [more inside]
posted by pantufla on Dec 6, 2010 - 5 answers

Slow typing in Excel 2008 and unexplained network traffic

Why would Excel 2008 cause a lot of network traffic while typing in a cell? [more inside]
posted by lbergstr on Nov 27, 2009 - 10 answers

Mac Address Book to Microsoft Excel?

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

Why is Excel so incredibly slow on my Mac?

Why is Excel so incredibly slow on my Mac? [more inside]
posted by kdern on Apr 9, 2009 - 7 answers

Mac OS X / Excel problem - recovered file causing endless crashing

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

Parents and Mac switch, regarding Excel

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

Help me tame the Advanced Filters!

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

StupidExcelQuestionFilter: Adding x and y axis labels

How do I add x and y axis labels to a chart in Excel 2008 for Macs? [more inside]
posted by peacheater on Feb 15, 2008 - 2 answers

Eliminating Hyperlinks in Excel X for Mac?

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

Mass Cyrillic to Latin translation in Excel?

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

Excel for Mac and PivotChart functionality?

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

Advanced Excel tutorial suggestions

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

Crystal Ball software for the Mac?

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

Excel Help

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

Page: 1