i need help in finding the area under the graph in excel as it is a complicated curve for the pressure vs volume of a combustion...

When trying to outling gridlines on an excell spreadsheet, i can get them on print and print preview. However, even after going through the print options and...

In privious Excel versions I use to do it by selecting text and next row and simply choose Justify from Format menu?

I have data fro a las file which i have opened in excel. due to the number of columns the las file grouped the data line by line instead of column by colmn....

I've used an add in that allowed me to save graphics to JPG and other formats, but can't seem to remember where I found it. Can someone assist. Thanks, Barb...

Hi, I have been using pivot tables and suddenly the arrow (cursor) that we get to select specific colums is not to been seen. It just shows the normal + cursor...

Hi Group This is driving me crazy.... I have a third party file that I use in conjunction with some of my own files. If I open their file alone the file...

I currently use both Excel 97 & Excel XP, is there a way by formula to include the worksheet tab name in a cell similar to & in the header/footer? -- Mark

As the title says, every second time i open Excel 2003(opening Excel itself, not an Excel document) the document recovery pane opens. I have tried to open each...

I have the below table in a pivot table. When I change the sub total field to a 'count' I would expect it to change to 2 but it stays on 3. 1st Jan heading...

I am hoping to create a macro that upon opening a file it will do the following: 1)Copy A1:B:2 (just as an example; also - there is only one worksheet in this...

I'm working at a office spaceplan. So i've got 2 different colums with the functions and roomnumber. I would like to get a fault or information message when...

Hi I have a worksheet for kids in class it is 10 columns and 20 rows. Is there a way to prevent the display of all the other rows quickly without selecting and...

Hallo I have a Master sheet with a few formulas and a few other sheet they are all the same as the master sheet. So what i need if i change a formula in...

I have 50 employes that can work on upto 5 different jobs in a day or just one . there hours and jobs are entered onto a excel chart so you can look at one...

Hi can anyone help me with my problem? Thanks in advance! I had receive a compile data from one of my vendors and there is one adjustment i need to make in...

Hello, I posted a question yesterday, but i cannot find my question- or any answer, today. So here we go again- I have created a breakdown table for my...

Hi, I have a little matrix 5R x 6C. All cells within the matrix have data validation in them to restrict the input to "1" or "0". It is OK to have mutiple...

Hi, Typically when I use VBA I tend to put a button on a sheet. I do this to control the macro execution. Most of the macros I'm writing will take information...

Is there a way to change a spreadsheet so that the columns become rows and the rows become columns... Other than retyping the whole...