General

Printing spreadsheet and diagram
I'm having problems getting my tables and diagram printet on one single page I' have a workshett with both tables and diagram wich I have usually printet out on one single sheet of paper (A4-size). I did this by selecting "fit to 1 page wide and 1 page high" in the print setup menu. This was in the Excel 2003-... 20 Apr 2010 04:09

How to calcuate 6 variable's contribution towards a fixed sum???
I have a number of stats on hand. In column A is the results of column B, C, D, E, F, G. (Note* column B, C, D, E, F, G values are sometime +'ve sometimes -'ve) Is there a function that can tell me the relations between value A vs B, A vs C, A vs D... etc) Your help can save my job~ Thanks ... 20 Apr 2010 05:11

find a name
I have created a list of people.how do I find a name in a database I created? ... 20 Apr 2010 04:09

Paste to size
hi, i require a specified picture size say 3" by 3" for many pictures. How can i get the size without resizing them manually after i copy the picture from another source. Thanks! ... 20 Apr 2010 08:16

how to Sum last 10 values of a dynamic column excluding zero
hi, i have this formula =SUM(OFFSET(P2,MATCH(1E+30,P:P)-1,0,-10,1)) which sums the last ten values in column P, i was hoping someone could amend it slightly for me. As column P is dependent on other entries the entire column has 0 in it which makes this formula ineffective, i can't put an IF formula into column... 20 Apr 2010 01:03

Windows 7 moving desktop icons
Yes, my Windows 7 64-bit desktop behaves just like you said. All articles I can find in Google say to uncheck "Auto Arrange", but that's not the solution. It's not checked, yet each time the file is updated, it moves to the upper-left spot like other new desktop icons do. Why can't Microsoft fix this? It didn't... 20 Apr 2010 01:03

Excel wrapped rows, want automatically leave some space bottom of
In Excel I have rows with wrapped text in some of the columns. I would like to improve the look by adding a small amount of space at the base of each row. As the rows are different heights due to the wrapping, stretching afterwards doesn't do it. What I need is something like the spacing after in the paragra... 20 Apr 2010 02:05

hiding zero for a sum
i'll try to explain best i can.... i have 3 colums, first and second are put in and the third is the difference between them. then on the bottom, i have the averages. i know how to do the subtraction, but for the other rows below keep showing "0" even though and the averages are now correct. how can i keep th... 20 Apr 2010 10:20

calculation help
I will try to explain this I want to have a running total for C D F and G and use the numbers in A as a filter so if I filter the numbers = 33369 I want the totals of C D F G in other cells on the sheet (ie L6,M6,N6,O6) The data in A C D F G is entered maually In the data below I want to calculate the col... 20 Apr 2010 12:24

Excel password mechanism failure
I have a 2 PC Home/Biz network. The older PC runs Win XP and the new PC runs Win 7. I have a password protected Excel 2007 document on both systems. (I copied the file from the XP system to the WIN 7 system in January when I installed the WIN 7 system.) I open the file 3-4 times a month on the WIN 7 system. Tod... 19 Apr 2010 20:54