I sat on the phone with Microsoft support and they weren't able to help me. I've scoured the internet trying to find a solution to this problem and I'm just about ready to give up. Can Metafilter rise to the challenge?
How do I stop Microsoft Excel from formatting numbers into scientific notation? No matter what I do, Excel keeps doing this. Please make it stop.
See the
youtube video I made explaining my problem (45 seconds).
[more inside]
posted by crios
on Apr 16, 2013 -
37 answers
So I upgraded from Microsoft Office Starter 2010 to Microsoft Office 2010. I uninstalled the Office Starter program. Then things went wrong. Please help!
[more inside]
posted by merocet
on Jan 26, 2013 -
3 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
I have a data set of user activity. It records every time an activity is completed by a user, with the date and user ID attatched. I need to tally up the number of times, by user, the user completes the activity on a unique day.
[more inside]
posted by Patbon
on Mar 5, 2012 -
13 answers
Need help setting up a simple Access database. I'm trying to reconcile a bunch of inventory, which is all recorded in multiple Excel spreadsheets. I want to import all the Excel files into an Access database so I can match them up all at the same time.
[more inside]
posted by smoothvirus
on Feb 22, 2012 -
8 answers
Help me understand how to make a macro do what I want it to do - automatically select the relevant area instead of a previously recorded cell range.
[more inside]
posted by komara
on Jan 2, 2012 -
6 answers
I have about 200 separate Excel spreadsheets that I need to change one field in. There is a date in G4 that needs to be the same in each sheet. Is there way way to do this without opening, editing, and saving each sheet one at a time?
posted by keep it tight
on Dec 19, 2011 -
10 answers
Excel issue. Tried looking on the internet, had no success. Can y'all help? Selecting and deleting multiple nonadjacent rows.
[more inside]
posted by crush-onastick
on Dec 2, 2011 -
18 answers
How can I find the average of multiple columns in excel without selecting each individual row that I want averaged?
[more inside]
posted by gibbsjd77
on Sep 2, 2011 -
8 answers
Excel question (debt management/budgeting): what formula gets me the first instance of something in a row, and then how I can pull the date from the top of that column? More inside.
[more inside]
posted by WCityMike
on Jun 23, 2011 -
8 answers
Can anyone recommend a good, well-trafficked forum for Microsoft Office (particularly 2010) questions? Seems like this should be eminently Googleable, but maybe because there are so many of them, I'm not finding the one that is
the one. Thanks!
posted by The Dutchman
on Mar 19, 2011 -
7 answers
There has to be an answer for this, but I just can't figure it out. In Excel, I've got 5 columns (A-E). I need to return a list of values from column A if either column B or C equals 'foo', *and* if either column D or E equals 'bar'. What's the magical formula (or whathaveyou) that will make this happen? For bonus points, results need to appear on a separate tab than the source data.
asking on behalf of mrs spinturtle, I personally have no idea what I'm talking about.
posted by spinturtle
on Mar 17, 2011 -
6 answers
Microsoft Excel 2003 Question: Can I manually set the Page Breaks in Page Break Preview, and THEN print the document so that each manually set page will fill the entire printed sheet of paper?
[more inside]
posted by ThePinkSuperhero
on Feb 1, 2011 -
3 answers
Excel 2007 filter: How do you change the dictionary language for specific cells/columns/rows?
[more inside]
posted by bethist
on Oct 1, 2010 -
3 answers
Need list of trade publications. Found huge one on Ulrich's web. How can I remove all information except for the (hyperlinked) titles, ideally in a way that keeps the titles on separate lines so I can then paste them into Excel?
[more inside]
posted by randomname25
on May 19, 2010 -
10 answers
Can you reccomend me a good Excel 2007 Book?
I'm currently studying a foundation degree in Renwable Energy in the UK, and am struggling with Excel 2007. A general book would be handy, but the main topic I'm really struggling with is 'visual basic', so it would need to include detailed information on how to use that and the coding system of Excel.
Can anyone reccomend a good book to get that would include information relative to that?
posted by sockpim
on May 5, 2010 -
9 answers
Need to print Excel spreadsheet so it turns out like a vertically-folded half-sheet card.
[more inside]
posted by beammeup4
on Mar 23, 2010 -
7 answers
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
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
How can I count certain things in a range of cells in Excel that fall between two dates?
[more inside]
posted by SansPoint
on Sep 2, 2009 -
5 answers
I need to make a template for an in-print events calendar, and I'm not sure what the best way to approach this project is. Advice please!
[more inside]
posted by soviet sleepover
on May 5, 2009 -
2 answers
I need a custom number format for Excel that only gives me a decimal when I need it.
[more inside]
posted by lou
on Apr 26, 2009 -
5 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
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
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
I want to build a web app based on an Excel spreadsheet using VBA and some Excel Solve functionality. Should I try to build my own online spreadsheet? Or is Microsoft about to release some nifty online development components compatible with Excel and VBA?
[more inside]
posted by Mokusatsu
on Sep 12, 2008 -
2 answers
Can I use Excel to loop through lists of names and sum up numbers for each name, without having to define the cell ranges that correspond to each name?
[more inside]
posted by korres
on Feb 5, 2008 -
4 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
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
How do I cut/paste a project in MS Excel and not have my formula cells change with the movement of my cells?
[more inside]
posted by mi6op
on Feb 5, 2007 -
4 answers
Excel question: How to define a range so that it always adds up to a constant value.
[more inside]
posted by corpse
on Jan 16, 2007 -
20 answers
My girlfriend is going for an interview where she will be tested on Microsoft Word and Excel. Is there an online tutorial where she can take some sample tests or run through some applications? We've googled a few, but they seem to stop at beginner levels and to be rather cumbersome. Just wondered if anyone had some first hand knowledge of a site to head to.
Regards/p &k
posted by patrickje
on Nov 16, 2006 -
5 answers
I've got an Excel spreadsheet with numbers ranging from 2,000 to 600,000. I want Excel to look at each cell and essentially categorize all of those into five categories in a new column. If the value is less than 10,000, I want Excel to give it a 1, if the value is between 10,000 and 50,000 I want it to be 2, if the value is between 50,000 and 100,000, I want it to return 3, if it's between 100,000 and 500,000, I want a 4, and if it's above 500,000, I want a 5.
I tried the IF function, but I can't figure out how to a) make it recognize multiple variables, and b) I don't know how to tell it to look for numbers within a range. The Excel help section about arrays and lookups is fairly mystifying. Anyone got an idea?
(I know I could sort the data and do this manually, but I'd like to learn how to do this Excel's way.) Thank you!
posted by stonefruit
on Nov 9, 2006 -
14 answers
Some colleagues are trying to export a MS Access report to Excel. Here's the error they get:
[more inside]
posted by ao4047
on Nov 6, 2006 -
4 answers
It's very clear in Microsoft Excel how to calculate formulas using external references, but what isn't clear is how, in several worksheets, to have the same data in certain columns. How do I do this?
[more inside]
posted by arimathea
on Aug 8, 2006 -
9 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
A friend has a large list of address labels in column format which were created in Excel, then exported to Word. He no longer has the original Excel file.
[more inside]
posted by empyrean
on Jun 6, 2006 -
6 answers
ExcelFilter: I need help creating a pie chart as a separate worksheet in Excel that counts how often values appear in a column and creates a pie graph based on that data. I'm stumped, I'm not using the right Google terms, and my company's help desk couldn't guide me through the process, either. (That sounds awkward, so I describe it more comprehensibly inside.)
[more inside]
posted by WCityMike
on May 19, 2006 -
9 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
ExcelFilter: How do I convert a column of names formatted
Smith, John into
John Smith. Feasible?
posted by furtive
on Feb 9, 2006 -
8 answers
I've got two columns in MS Excel. They each share 200 numbers. However, one of the columns has an additional 700 numbers. I want the column with 900 sorted in ascending order, with like numbers from the column of 200 beside those in the column of 900. How do I do that?
posted by panoptican
on Feb 8, 2006 -
18 answers
Basic Microsoft Excel question. How do I join two databases together when they share elements but are not coextensively equal? (More)
[more inside]
posted by Mr. Justice
on Jan 22, 2006 -
8 answers
