First  |  Prev |  Next  |  Last
Pages: 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158
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 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
First  |  Prev |  Next  |  Last
Pages: 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158