General

Using Cartesian Cell Names
Is there a way to get Excel 2007 to treat cell coordinates as Cartesian coordinates instead? I'd like to be able to input fill colors into cells using x/y numbers I know I could set up to columns. . . X and Y. . . and then enter in my numbers under them. And from there I could even create an XY Scatter Chart.... 5 Apr 2010 10:30

Calculation of Credit Card %
Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE CHARGES on XL? TX. ... 4 Apr 2010 14:52

Tabbing through input worksheet
Rather than creating a complex form with all the associated VBA coding I have created a worksheet which will transfer information to another sheet - using one macro The input worksheet has input boxes all over the place and I was wondering if it is at all possible to tab or use enter to jump from cells A1 to C4... 6 Apr 2010 11:56

Using Picasso Photo Viewer to Open Excel Hyperlink in MS 2007?
I want to use Picasso Photo Viewer (PPV) to open images that are HTML linked within a MS Officer 2007 - Excel spreadsheet. I've looked at file associations (using MS 7 OS) - but to no avail. Currently, IE opens up, then prompts me for an Active X overide and opens it with Quicktime. Any solutions please? In XP... 4 Apr 2010 02:52

Link Cells (Read for more info) -- HELP PLEASE
Ok, this is for more advanced Excel users. Here's the issue. Lets say I have two sheets in Excel, S1 and S2 respectively. Let's say in S1, if I type a 4-digit number IN COLUMN A, which is actually an ID number for a person, I want their name to automatically appear in COLUMN B from a list in S2. This is how... 4 Apr 2010 01:47

Chart Goal Lines
How do I add a goal line on my charts using Office 2007? ... 4 Apr 2010 07:11

How do I recover a prior version of a saved document?
I had two documents open and somehow, one document was saved to both file names. Now I have two documents with the same data and I am missing all the data from one of the documents. It's like I hit "file" "save as" and saved one document under another documents name. I did not do that but what has happened is t... 3 Apr 2010 23:38

Dropdown List That Accepts Other User Input
I cannot find if there is a way to have a dropdown list that contains pre-defined data validation entries and also allow a user to input their own. Is there a way to do this in Excel? ... 5 Apr 2010 01:50

Delete entire row if older then 365 days
How do I create a macro that will delete entire row if older then 365 days. Dates are on col "A" last col of data = "U" Data is kept in sheet "details" Thank you ... 4 Apr 2010 18:13

hide formula in cells till data is available for calc
I recall being able to copy a formula in a column and hiding it until data becomes available to complete the calculation. This way you don't have a series of #value# in the work sheet. The formula contains an absolute reference as well. Thanks, Kiwi ... 3 Apr 2010 20:21