How 2 sort an autosum total list after adding items 2 autosum item Am using detail dollar amount list to insert new transactions in the middle of a the detail list, and they in turn get included in the 'autosum' total calc which is located in another item total summary list in the same workbook. If we try to sort the autosum total summary list, the autosum totals seem to loos... 30 May 2010 19:47
Sort problem I have the months of the year in one column. I need Excel to sort the months, but according to calendar. I need January, February, March and so on. But if I choose to order them in ascending order, it shows: April, February, March... How do I solve this problem? Thanks in advance. Regards, Emece.- ... 30 May 2010 18:42
Hard to select first worksheet tab I have this problem too and it is so annoying. It is staring to bug me big time. Anybode heard of a fix? -- holtons ------------------------------------------------------------------------ holtons's Profile: http://www.thecodecage.com/forumz/member.php?u=1914 View this thread: http://www.thecodecage.com/for... 30 May 2010 16:31
Find and Replace error Hi. I have a worksheet where I want to show only some of the formulas used in it. That is why, instead of using the option "Show formulas" from the formulas Tab, I insert a ' before the = in the cells I want to see the formula. But when I want to show results once again, in order no to look for each formu... 30 May 2010 16:31
Excel 2007 - Copy Picture Resolution When I select cells to copy as a picture in Excel 2007, the resolution is terrible. Text and objects with shadow's are very blotchy when pasting the picture. How do you change the resolution of a 'Copy Picture'? ... 31 May 2010 15:18
HELP needed to remove 2nd spreadsheet within a workbook I have a large workbook containing 10 worksheets. It's quite large. Somehow - and I don't know how, I created a copy of my workbook that open behind (next to) my original workbook. I can see the copy by dragging a white colume that appears on the right of my worksbook pages. If I highlight a cell or row in the ... 30 May 2010 12:11
Pivot table magic i want to see NA in all cells where data is empty in pivot table. Is possible without vba? thanks in advance -- bill_ball ... 30 May 2010 12:11
how to find duplicate entry in one sheet and in workbook how to find duplicate entry in one sheet and in workbook ... 30 May 2010 15:26
Can't open an excel file (have 2007, Vista) without saving fir TinyTall, I have been through this forum looking for the magic answer. Tried them all, but noticed you reference to the "%1" in the perform action. The %1 was in the perform action but without the quotes("%1"). Adding the quotes to the existing %1 in the perform action and not adding anything to the DE Applica... 30 May 2010 04:42
excel formula help earlier i worked with array formula very well. now i forgot and couldnot recall the method to edit the formula. anybody help is highly appreciated. -- bill_ball ... 29 May 2010 23:23 |