in [Excel]

Delete rows data moving When I delete a row in excel 2007 the data that is with with the rows below does not move with it. the actual text and color formatting will move, but the items drawn it such as text boxes and stars do not move with the row. Worked fine in 2003, but will not in 2007. Any suggestions? ... 1 Jun 2010 18:39
How do I align numbers in different cells when some are in bracke. I trying to show both positive and negative numbers in a lsit. The negative numbers are in brackets however this puts the numbers out of alignment with each other. Is there away to ensure the numbers are aligned and the closing bracket sitting outside the line of numbers. Thanks ... 17 May 2010 10:13
In Excel, when i key in 02352 and press enter, the zero goes off In Excel, when i key in any group of numbers with a zero preceding it, and then press enter, the zero disappears. How do i for instance key in 02352. with the zero still intact when i press enter. Please help! ... 17 May 2010 10:13
Calculate Holiday I need a forumula to autimatically caculate the actual date that employees are off for Christmas based on the year. If the holiday falls on a Saturday, then Friday is the day off. If on a Sunday, then Monday is the day off. For example, Chirstmas in 2010 falls on a Saturday. The foruma needs to return 12/24... 17 May 2010 11:19
Divide by 0 Help =(SUM(E98:F98)+D98/2)/(I98-G98) Any suggestions on how I can rewrite this to return 0 if I get a Dicide by 0 Error in any of the calculations. I am a bit of a novice. ... 17 May 2010 08:02
Three Variable Correlation Hi. I was wondering if it was possible to work out the correlation between three variables in excel, not just two. My data looks like this (this is just an example, with random values): A B C 15,283,741,924 22,891,175,671 182,489,383 12,450,453,827 ... 17 May 2010 08:02
Drop down boxes Hello i have a column of 'names' which i have used a dropdown list to produce i.e. date name(drop downlist) 01/01/2009 john i.e john dave etc in the list is there a way that if a change john to Jsmith that this will update all the rows that 'john' was chosen for! ... 17 May 2010 09:08
Ribbon The ribbon is a mess. I've tried to embrace the changes but they are just not an improvement. If I could customize the ribbon maybe it wouldn't be so bad. Also its huge and takes up too much space on the screen. I've been using excel since 95 and have always loved it, not so much anymore. ... 18 May 2010 13:41
Three Variable Correlation Hi. I was wondering if it was possible to work out the correlation between three sets of variables in excel, and not just two. The data looks like this (example values): 15,283,741,924 22,891,175,671 182,489,383 12,450,453,827 25,604,121,237 458,039,634 25,017,912,202 10,105,478,615 408,312,030 15,608,597... 17 May 2010 08:02
Div 0 help =(SUM(E98:F98)+D98/2)/(I98-G98) This formula gives me a Div 0 error. How can I re-write it so that it stores a value of 0 , if it encounters a Divide by 0 and executes the calculation if 0 Help appreciated Joe ... 17 May 2010 08:02 |