excel

As some of you may know, I tutor students in finance. I'm also a huge comic book fan, so when a student came in with a problem involving Scrooge McDuck, I was thrilled. In one of the most famous Scrooge stories ever, Back to the Yukon (rated the #1 Donald Duck story of all time at Inducks)...

You know how when you use the mouse to select a range of cells, Excel identifies the selected cells with a surrounding line? Well - I have a spreadsheet where this doesn't happen - the cells are selected, but there's no nice surrounding line. I guess I probably accidentally hit a key that does...

This surely cannot be the first time that I've noticed this but Excel doesn't allow me to have to workbooks/spreadsheets with the same name, but in different folders, open at the same time? :mad: This seems a bit backward to me. I just tested and I can have two Word Documents open with the...

Full disclosure - I have never used Microsoft Excel before, nor have I ever taken Statistics 101. I'm taking this online Computer 101 class (I've mentioned it on here before), and the teacher literally doesn't teach us anything. He just gives us an assignment each week and we do the research...

I'm getting some data from a trading software, and I want to use excel to make a composite of all the data together. The program in question (Tradestation) gives me a sheet with various statistical information for every stock using my algorithms, and what I want is to be able to "join" the data...

So my office recently switched over to Office 2007, and it's causing me fits. In Excel 2003, the formula bar used to automatically resize itself to fit the contents of the cel. Now in 2007, it appears to only function as a fixed size that I have to manually change. Is there any way to get it...

Hi there, My brain is just not working properly at the moment. I was asked to create some charts (my boss wanted line graphs) showing how our organisation was performing over time in certain measures. Easy enough. However, the problem I have is that for the first part of the year I have only...

How can I save a section of my worksheet (like one or 2 columns), as delimited txt ? Saveas saves the entire worksheet from what I understand. I could not google anything on this subject. Thanks.

I have a few hundred cells with formulas in them referencing other tabs in the same worksheet. All of them use "relative" cell references rather than "absolute". I need to be able to copy/paste these several times without the formulas changing, so I need the formulas to have absolute cell...

My Excel chart/graph skills were never good and are now rusty ;) Based on some imported data, I have generated a perfectly nice line graph that appears to show a trend. Is there an option to overlay any 'trend line' on the graph? Damned if I can see it. I'll do a :blush: in advance. ta.

I've got a spreadsheet on Google docs, and my experience with spreadsheets is very limited. There's a date column, with most dates like this 2009-09-07but also a bunch like this 2009-09-07-A01 2009-09-07-A02I want to lose the suffixes, and just keep the dates (yyyy-mm-dd). There are a lot of...

I have a string of text - it is a DNA sequence - and I want to import it into excel to do some calculations on nucleotide frequencies. What I would like to do is (essentially) import a 16,000 character word into excel, but I would like each character in a separate cell of a column or row. I...

I asked for some Excel help here before, and the resident Excel gurus were wonderfully helpful. So, I thought I'd try again. Here's a situation that seems like might be a challenge to sort out (it is for me certainly!). :) I have a column with several rows of unique text entries in it. In...

We have to do a bunch of analysis in Excel (not my choice!) When we copy a sheet into a report, which we need to do because of the formulas, pictures, and text-not wanting to re-do the whole damn thing--it shows up with that damn #VALUE! crap when you open the copied version. This in spite of...

Hopefully some Excel guru here will help me out with this. Here's the situation: I have some numeric values which correspond to certain years, but I only have values for the starting and ending year. I'm trying to find the average yearly growth rate which will yield the final year's value. For...

I just spent an afternoon making a sheet to take PayPal data and filter for actual balance-effecting payments and break down my item number. The good news it that it works great, the bad news is that its completely and utterly counterintuitive. Anybody else ever serve a turn in that hell?

I'd like to import data from http://www.rac.co.uk/web/routeplanner/ into Excel In columns A and B I'd have start town and country; B and D , the finish town and country and in E would be the mileage retrieved from the website. I've tried playing around with the web query function but don't...

I've a problem with opening a particular CSV (comma-delimited text) file in Excel. One of the data column consists of alphanumeric text. However, whenever a text such as "1234E5" appears, Excel automatically converts it to a number, assuming it to be 1234x10^5. My current method of overcoming...

To All: My thanks to those who responded to my last Excel poser. I've another one. I inhereted an iMac from my predecessor. She had Excel set on manual calc in the settings, which was driving me nuts. Y'all helped me with that, and I reset it to Automatic. Now, all the spreadsheets that...

I inherited a IMac from my predecessor. When I use Excel, I have to manually sum formulas in all my spread sheets. That means I have to find each and every cell that has a formula in it, click on it, click at the end of the formula in the formula box and then hit enter. Is it a bug, or is...

Hi folks. Here is what I am trying to do. I have a bunch of excel files, they are master lists of products. The prices on them are determined from several of the columns on the book. For example, column 'A' determines the base price, b determines if it goes up a bit, C may make it go down, and...

I like excel because it is easy to use and solves problems quickly. However at my office the new version of excel (2003) was installed and I have no way to go back to the previous one. The new version lacks some of the tasks that I use more, for example in HELP there was an option called...

I hope someone here knows how to do this.... I am working with two BIG datasets of student data in Excel. Each has a unique identifier (Example:"bug_girl") attached to a bunch of information. (major, degree program, favorite color, etc.) One data set is a subset of the other--in other words...

I only started using spreadsheets a few months ago so very new at this. Also I know virtually nothing about mathematics. Anyway I have thse values whereby y varies with x. I want to find a precise mathematical relationship between x and y so that if I input any x value I get the y value...

Don't know if anyone can help me, but I can't find anything through google that seems to fit this problem. I'm trying to make an Excel VBA macro to help pull info from various report files and but them on a spreadsheet for balancing at work. I hammered out some code that does the job pretty...

Greetings I have an excel file with birthdays in a column. They are typed in like this: 1955-08-07 Is there any easy way to change the format here to get each person's age (just by year would be fine?) listed in it's own column? Even just the year (e.g., 1955) would be awesome. I need to...

I currently have the entire OOo suite installed for the sole reason that i need to make a spreadsheet and send it each day. I really see no reason why i couldn't do this in a simple terminal/curses program. I've looked a bit, but i can't find any that support xls, nor any that had (good/any)...

I often need to strip control characters from excel spreadsheets for data imports...(tabs carriage returns etc) . I do it at the moment by saving as a text file and sticking it on a unix box to do it....but I reeeeeely would like to be able to do it in windows, preferably in excel. Anyone got...

I have a graph I'd like to post. Anyone know how?

Hi all... I'm working on an old application that uses DDE to transfer data to an Excel spreadsheet. It nearly works, except it treats all numeric data as numbers, which isn't always the case. So the app is using the following macro to get Excel to open the datafile: Open("c:\sheet.xls", 1)...