I opened an Excel file but it won't show up in Excel. When I exit Excel it asks if i want to save changes to the file, but it still hasn't shown up as...

I am using the formula MROUND to get a time hh:mm:ss to the nearest 30seconds. Cell T2 shows 00:11:24 and U2 shows 30. I have fomated cell T2 and the cell I...

I have a Defined Name of "VendorList: =OFFSET(Inventory!$KB$2,0,0,SUMPRODUCT(--(Inventory!$KB$2:$KB$200"")),1) I want this to be a dynamic range and to go...

I need to cite the words that are in cells in Excel 2003. Is it possible to set up a footnote system in excel?

How do I get the Open Folders and File box to show details all the time, or as default. I went to computer and click on a file that was showing thumbnails...

Hi I am having one excel file with Comment pictures, now i want to take those pictures out and past some other location how can i do this Rohan

Is there a way to sort locked cells in a protected worksheet so that a user can sort cells but cannot input data in certain cells?

Hello My Excel file has thousends of records and columns let's say from A to Z. In column Z there is one of numbers: 0 or 1 or 2 or 3. The problem is how to...

Hi, i need to search the content of C10 in range A1:L1, and to display next cell content. Ex: A1 B1 C1 D1 E1 F1 G1 H1 1 222 2 333 3 444...

Dear All, Good day !!!!!!!!! I have a Column data with following values. 0.5" 0.75" 1" 1.5" 2" 3"

I am trying to install H&S but keep getting an error message stating that excel can not be found & to find the location. Please help!

Hello again, I have this so good macro that function very quick. My problem is that I like the results to be hidden to avoid unnoticeable changes. When I...

a & a 24/03/09 a & a 24-26/09/09 a & a 3/06/09 a & a I have a column of the above similar text. I would like help to write formula to show text without the...

How can I enter text to cells that already have data in them without replacing the entire cell?

Jacob Thanks again for the help, I am fairly new at the formula bit. I have another woork sheet with the same issue, it is an amount divided by the number of...

I was entering Data into Excel & skipped a whole line of info. How do I go back & enter in that row of Data?

More specifically, I want to enter a dollar amount and in another cell have it write out the amount (like on a check). Cell a1 - $10.24 Cell a2 - Ten...

I need a formula in sheet 2 that counts if column C sheet 1 = S, and column S sheet 1 can equal either N* or U*and column A sheet 1 does not equal CBH, APH,...

I cannot open MS Office 2007 Enterprise Excel files by double clicking on them in Windows Explorer. Excel opens, but not the file. There is no error message....