How do I merge multiple cells into one cell. I had addresses that I needed to split the house number up from the street address, so I used "Text to columns"...

In Excel under File Properties Statistics it includes the name of the last person who saved a workbook. I want to include in the footer. How do I do that?

I'd like to create a macro that fills a formula down to the final row that has any data. -- Just filling to adjacent cells (e.g. double-clicking on the...

I typed up some History notes and saved it. I wanted to use the same format from those History notes for some new History notes and I saved over on my old...

With Excel 2003 I am encountering the following: If I open an existing workbook directly by clicking on the file and make changes to that workbook, the program...

I am having the following problem with VLOOKUP: I have a cell linked to a combo box that chooses from 23 values, 21 of which are numerical, and 2 which are...

I have data that is in the format of 3 columns wide by about 3000 rows. I want to rearrange each row to become a single column. Eg. Cells A1,B1,C1,A2,B2,C2 to...

Some keys on my keyboard is locked in Exel. How do I unlock it?

Hi, Why isn't there an icon for pasting formulae only, there is for values and formats? I've written a macro to do it but this is not ideal because you need...

I am fairly new to Excel, but I need the formula to calculate hours worked, to include 30-60 min off for lunch. Formula must include hours and minutes worked.

If you... ....want a loan! ....want a credit card! ....want to invest money! ....want to shop for Christmas! ....want to buy a car! ....want to buy a...

I need a macro that help me to transfer name and address information from an specific table in excel to a template in words on specific areas and then print...

I have a list of names from A1 to A10, and letters from B1 to B10. These letters switch rows at random, but within my above range. I need a formula that I...

Hi there, Is it possible to format cell for to make one character empty space between each character. for example: if I write in to any cell H5F2 then must...

Hi All, Can any one help. Am having a bit of trouble with my VLOOKUP code for some reason it is returning a value for were there should not be one. The...

Is there any way to force comments to appear where I want them to appear instead of where Excel thinks they should appear. I want them displayed only when the...

I have a worksheet like this: / A / B / C / / 1 / water per day / cumulative water / beginning water / 2 / 21 / 71 / 50 / I want a running sum in column B. In...

I have a master spreadsheet with contains employee detail by department. How can I filter this list by department and place a list for each department in a...

I need to format the number cell so that it will still show the numbers after the decimal, but not show the decimal point at all. It must also display leading...