I recently got a new PC with Windows XP. My old PC had Excel 2000, and now I can open a file that I saved to disk on the new PC. Do I have to save my old PC...

Hi: A very complicated solution, but you only have to enter the formula once and then copy it. This assumes that the sheets are numbered Sheet1, Sheet2,...

How can I format (color/font) the worksheet tabs so that I can quickly pick out the one worksheet of a group that I am looking for? I have searched every area...

I was wondering if anyone knew how to keep track of elapsed time in excel VBA while the macro is working

In all prior versions of Excel, pressing F2 had the same impact as double clicking on a cell when direct editing was enabled, i.e. restores the cursor at the...

If you want to delete everything right of the first dot, and all cells have at least one dot. =LEFT(A1,FIND(".",A1)-1) If text is in cell A1 -----Original...

I have a work sheet that looks something this Col A Col B 1 10 1 20 2 5 4 1 4 ...

Howdy, I need your help please. I some how in my wisdom created a problem and I do not know how it was created or how I can fix it. I now open excell and all...

Iam using office 95 for my work and have just bought a new computer with windows xp. I have loaded my office 95 with no problem but it will not open my excell...

How can I reduce a list of numbers with several repetitions to a list only showing 1 instance of each number. ie 3,5,7,3,4,8,4,3,6,5 to...

How do I make my excel sheet indicate the actual start and finish dates of a working week when the week number is inserted,( It would also be nice to do the...

I have been able to use formulas for mortgage payments and amortization. But I can't find one that will incorporate an early payoff on a loan. And I don't know...

I'm back ... working on a mailing list database. Column A is first owner firstname, Column B is second owner firstname, Column C is last name. I'm using some...

I need to know if it is possible to write a formula that will convert a number (186) into writen format (Onehundredeightysix). If anyone can help me with this...

G'day, I am wanting to add error bars to a graph. I looked up help and it said to select the data series, go to the format menu and click data series. but when...

I just started using MS Query to import data to an Excel spreadsheet from MS Access. I now want to be able to just return row counts for a given query, rather...

MY OBJECTIVE IS TO CONVERT A REAL NUMBER (EG 71.30000) REPRESENTING DEGREES, MINUTES AND SECONDS (DD.MMSSS) TO DECIMAL DEGREES (DD.DDDDD) TO EXTRACT THE...

Hi there, Is there any way to have a variable reference in Lookup? I have a datasheet that may change over time (every couple of months) but I don't want to...

Hi This has to do with carry over of time on a payroll sheet. Time may go in on a wednesday but, overtime continues to add up thru saturday. a b c d e f g...

Selecting "justify" for a cell's vertical alignment automatically increases the row height (when "Wrap" is also selected) as more or less text is added or...