Is it possible to automate a citation style change on an entire column in Excel, or do I need to do this by hand? [more inside]
posted by min on Nov 24, 2009 - 11 answers

I have an xls file I got from a survey I created on Google docs. Now I want to make it pretty without copy-pasting every bloody cell into an Indesign document… [more inside]
posted by monocultured on May 17, 2009 - 7 answers

What formulae do I need to cause Excel to highlight a cell on one worksheet if the data is found in a different worksheet? Formulae I have attempted (using named ranges) under the cut. [more inside]
posted by mccn on Apr 21, 2009 - 5 answers

How to bypass Excel macro warning or alternative to macro. [more inside]
posted by emjay on Nov 4, 2008 - 13 answers

How can I conditionally format an entire row in Excel 2007 based upon the contents of a particular column in that row? [more inside]
posted by ChasFile on Feb 1, 2008 - 8 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

Excel Experts: Is there a way to apply a custom formatting template to an unformatted worksheet? [more inside]
posted by kmtiszen on Dec 12, 2007 - 4 answers

It's not how I'd choose to spend my Friday evening, but for the last few hours, I've been trying to replace carriage returns that have turned up in an Access and Excel file, and drawing a blank. [more inside]
posted by godawful on Feb 10, 2006 - 9 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