When I'm trying to copy table titles across the top, it automatically keeps adding the next consecutive number after the title. For example, the title is...

I have a workbook that has links to other workbooks. I need to email it to someone who will not have access to the other workbooks, but I want her to see...

I am trying to make a label from an Excel file. The content for one of the cells to be printed is found in other cells on a different worksheet of the same...

Any help please...Trying to prevent my formula from changing in column D when adding in cells to bring amounts in column B down to match up to column A...

In this example: Value Criteria 1 a -2 a -3 b 4 b I want to sum the absolute values of criteria a and another sum of...

Hi all, I have a list of files that I'd like to mark the duplicates. I can't use just the file name because some files have the same name but aren't the same...

can a formula be made to do the following: if a line item has the same name in column C then add 1 to column B i.e. the count column is generated depending on...

here is my "formula" ='PSID Details'!C45 My question is how do I get it to where if I drag the formula down it will go like ='PSID Details'!D45 ='PSID...

When I try to an autosum in a cell, it doesnt show the calculation, it still shows the expression. Anyone know why?

Is there a way to make the drop-down list that appears for cell validation conditional on the value in another dropdown cell? Suppose one cell contains a...

Is there a way to make the drop-down list that appears for cell validation conditional on the value in another dropdown cell? Suppose one cell contains a...

I have a workbook that has links to other workbooks (office 2000). I know that in 2007 I can break those links so that just the actual values are in each...

Excel 2007 I have just installed my copy of Excel on my new computer. When I click on one of my files to open, Excel opens, (a shaded verson), but the file...

I have an Excel file called "ABC Ltd" that users update on a daily basis. Does anyone know know to auto create a backup at the end of a day? If today is...

I have some entries like: 10 Kg 15 Kilo 12 13.5 Kilogram How, to have all the text be removed from the same having the numericals remained presented as:

Is it possible, using a combo box from the Forms Control toolbox (not the ActiveX toolbox) to allow the user to either select from the drop-down list OR...

The problem I am having is that my rows seem to be shifting by what seems like a couple pixels each. This wouldn't be that big of a deal but after about 10...

Hello Dear Friend & Thank You in Advance for Any Relevant Solution My question is quite simple. How do you open a hyperlink in a new window? Thank you very...

I setup the following formula in conditional formatting to turn the cell yellow if the amount listed in cell B25 is not found in column T. I then also added...