Please help me create a calender on Microsoft Excel as I can't find any help online. [more inside]
posted by sockpim
on Jun 25, 2012 -
Is it possible to create an amortization schedule in Excel when the payment amount, the principal amount, and the interest amount each year is unique? [more inside]
posted by lea724
on Mar 29, 2012 -
Which programming languages are best suited to creating a timetabling application? [more inside]
posted by bister
on Jun 26, 2011 -
Is there a way to insert into a text string in Excel a "hard enter" so that when a series of rows of text are copied into Word that it automatically incorporates paragraph breaks between them? [more inside]
posted by notcostello
on Jun 29, 2010 -
How do I obtain a list of all words associated with a list of word roots / stems? [more inside]
posted by hooves
on May 13, 2010 -
Excel filter: How do I print a specific column on every printed page without having to physically insert the column to the beginning of every page? [more inside]
posted by jujube
on Apr 22, 2009 -
I want to simply my recording-keeping. Seeking an *easy* method for tracking multiple sources of income. [more inside]
posted by mintchip
on Jan 2, 2008 -
OfficeApp Filter: How can I seamlessly convert lists of project assignment names and deadlines to a calendar view that can be shared? Or can I? [more inside]
posted by Marnie
on Aug 22, 2006 -
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 -
I would like to make a chart like this
to track my daily computer usage. Any ideas on how I could do this? Any free software you can recommend? Any way of doing it with Excel? [more inside]
posted by bubukaba
on Jun 1, 2006 -
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 -
I am looking for software that will generate charts and graphs that isn't Excel. [MI] [more inside]
posted by donovan
on Feb 16, 2005 -
I have an Excel document listing dates times and other information. I'd like to import this "calendar" to iCal but cannot figure out to get the information imported properly. I found this tool
, but couldn't get it to work. I also found this application, iCal Maker
but it doesn't seem to work either. Anyone have an idea on how to import a bunch of events listed in an Excel document to iCal? [More Inside] [more inside]
posted by pwb503
on Dec 19, 2004 -
Is there a way to cut'n'paste charts from Excel into Word, without generating huge Word files? I've tried varieties of paste, 'paste special,' and so on, and I can't figure out why an Excel file of charts that's several hundred KB, always turns into a Word file that's at least several MB. I guess I'm missing something obvious, but have no idea what it is.
posted by carter
on Jun 24, 2004 -
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 -
! How do I keep Excel from hotlinking URLs as I paste them into cells? I use spreadsheets to store, sort, and transform lots of URLs. But Excel seems to think that anything beginning with "http://" is something I want blue and underlined and hotlinked for easy clicking. It doesn't happen right away, only once I leave the cell does it become a hot link. I'd like Excel to just leave my text strings alone. I don't want to launch a browser window every time I click in a cell that contains a URL. And I'm tired of doing the right-click-remove-hyperlink thing every single time. Formatting the column as plain text before dropping in the URL *doesn't* work. As soon as you paste a URL into a cell, Excel wakes up, decides to "preserve the formatting" of your pasted text, and voila! A nice blue hot link. Is there a preference I can un-check for this?
Sorry if this is a stupid one. I can't find anything in the help documentation or via Google that solves my stupid problem.
posted by scarabic
on May 28, 2004 -
Excel query. I have two Excel spreadsheets that I want to have automativally update each other. But, the format that they are in is generally incompatible. These are used as scheduling documents for the place where I work.
One spreadsheet is very wide. It lists each individual person at the top and their personal schedule below it. It lists breaks using "ONE" as the first half of a 30 minute block, "TWO" as the second half of a 30 minute block, and "LONG" as the entire 30 minute block.
The other spreadsheet is much less wide. It has 7 days listed and three columns. One is for "LONG" one is for "ONE" and the third is for "TWO." In each column, each person's name is entered in the appropriate block as defined in the first spreadsheet.
Can I get those two to talk to each other? Can I tell the first spreadsheet that if the word "TWO" is in a certain field to put the name of that person in another field on another spreadsheet?
posted by ajpresto
on May 11, 2004 -
MS Excel appends a 1 to the name of every file I open. How do I get rid of this? [more inside] [more inside]
posted by trillion
on Feb 20, 2004 -