-- Mrs J

So frustrating, I'm hoping someone can help me, because I know Excel can do anything. This is a bit complex, so I'll try to explain it the best I can: I need...

Hello: I have an xls that has the following columns: Territory ID Modality Quarter Amount I need to create a formula that would give me a sum for the amount...

How do I create more than 1 hyperlink in a single cell?

Is there a way to clear all the comments in a file? Excel 2003 had the Command: Edit, Clear, Comments. This command does not seem to be in 2007? Is there...

I would like to take a large spreadsheet and add 0.01 to each cell in it without that being visable to others when I distribute the spreadsheet to...

You know how in Excel 2003 when you selected multiple cells or rows it would highlight or shade the selcetions so you could see what you have selected? Does...

Having an issue, with a top 20 pivot. May be a simple answer, but I cannot figure it out. I have a data table of "support tickets", for 6 months (about 20K)...

i have three tabs (x2, invoices and adjustments). on each tab is a list of invoice numbers as well as an amount for payments applied to each invoice. i...

Standard color palette too dull. Use 6 or 7 normal colors but Excel doesn't remember which colors I used previously. How to I change the standard color...

I have created a sales sheet template in excel 2003 and would like it to generate a unique number every time it is opened. the file would then be saved as a...

Excel 2007 In column A I have part numbers. It consists of letters, numbers, and spaces. Is there a way to get a count of characters used for each cell...

How do I locate merged cells in my Excel worksheet? I am receiving an error messages when I try to sort the worksheet which tells me to either unmerge all...

I would like to create a 3-axis chart using Excel 2007, with each axis displaying categorical information. Although I am fairly familiar with the chart...

How can I adjust the height of the row headings (Column A, B, C). The letters of the columns across the top of the spreadsheet are cutting off at the top...

I have a large wkbk. There are tons of formulas. I have them hidden. I want to be able to clear only the cells that are data entry. I want to be able...

I built a spreadsheet to calculate an output variable based on about a dozen different input variables. I want to make an array that shows values for that...

How can I sort two columns of part numbers so that they align?

Hi everyone, Is there anything / glitch that prevent the user from making data validation as List in Excel? I'm trying to make a form template that will...

Trying to copy formula to adjacent cells (down) and they do not increment . The cell numbers stay the same but the row numbers do not reflect the new row. It...