How can I convert data files from Works 8 to Office & Student 2007

I'm trying to do a "what-if analysis" for my beginning Excel class and when I click on the appropriate cell and then the Data ribbon, all of the options are...

Can anyone give me a formula that will return the value in a cell that is diagonally opposite. If the value I search for is found in say B2 I want to return...

I own Excel 2000, but for some reason when I had to install it after my old computer crashed I couldn't use the "search workbook" function. (Edit-Find-look...

PP 2007 Why doesn't a Sort sort what is also included in Hidden Columns?

Hey everyone, I have a math project I am doing. This is what I have to do: There is a mass attached to a spring. The mass of the block is M and the spring...

I have a worksheet with the following details Object Name Last Database Backup NZ01_root 24/10/09...

I have a list of over 1000 names in my a column but need to add @gmail.com to the end of all of them. How can i do that in excel?

I am running Windows 7 and Office 2007. When I open an Excel file from the Jump List, none of the commands on the ribbon are clickable. It is just as though...

Dear Experts, I have 28 separate worksheets (classes of drugs) and from column O on each of those worksheets I want excel to look down the column and detect...

At start-up of Excel I get a pop-up which states: "Unable to Find Quit on the File Menu. Instant Access not enabled." I can then choose to press OK on the...

Is it possible to easily subtract two tables and place the results into another table? I have two 4x4 tables. The left corners are at A1 and F1. I would like...

Hi, I've got certain data in an excel sheet horizontally and vertically. Eg Product A Product B Product C Sales ...

I have a workbook with multiple worksheets, the worksheets are structured identical to each other. I need to name certain ranges in each of the worksheets. ...

In Excel 2007 I have a question... I have a cell in a column B1: MJTB1001 I need to paste to approximately 235 new rows in the column B1 as...

How do I collect data from many workbooks from select columns into a single workbook automatically. I don't want to open each one manually and copy and...

Hi I would like to use a scoring method in percentages which would recognise 1 to 5 as 0% - 100%. e.g 1= 0-24%, 2= 25-49%, 3= 50-74%, 4= 75-99% and 5= 100%,...

Is it not possible to freeze the titles at the top of the screen (always show row 1 at the top of the screen) AND then split the screen so that I can view one...

I'm trying to tabulate a survey using Office 97. ONE of the things I need to tabulate is dependent on two critera. If the first column is "O" (a text field, as...

As a low key user, I can calcualte the slope of a line from the x and y values, but I don't know how to determine how good the estimate is. Can someone...