Guest: Your 2007 Excel now has galleries instead of drop downs and when I want to insert 10 rows or columns, I go to "INSERT" and there is no place there to...

I recently upgraded to excel 2007. I use the drawing tools to embed diagrams in spread sheets. I do not seem to be able to add carriage returns to text...

I have a rather straight forward workbook with a single worksheet. It has several columns of data which do some simple math.... I now have to distribute the...

I have a worksheet containing the dates of public holidays in two countries as a 3-column array: A=country, B=holiday name, C=date. The dates are the primary...

Dear friends I want to write a macro which search in 3 column and match searching criteria A B C 1 Pravin Kumar ...

I use 4 place numbers in my investment calulations but the last number to be multiplyed by the the number of shares is a 2 place decimal but the calculation...

I am trying to create a few columns in a pre-existing Excel 2007 spreadsheet that deal with dates. What I am hoping to do is have a first contact date that...

I would like to total numbers on every 4th column starting from Column A to Column DD. Column A B C D E F G H I J K L M N...

I want to set a variable in a Workbook open event and then refer to it in another module. I tried to set a Public variable in the Workbook code but then...

I am trying to colour a cell if it is not equal to the cell above. I have tried cell value is, not equal to, =t6. But this just copies down as an absolute...

The performance of Excel is fine when opening the document and after it is open until a Print Preview is performed. After that everything operates very...

Need help with which function to use. Col A is labeled addresses in cell A1. Col B is labeled Team 1 in cell B1 Col C is labeled Team 2 in cell C1 Team 3 in...

I would like to delete duplicate rows but to keep one row

Hello I get a daily report from an outside vendor which I copy and paste into my report. On columns AH and AI, I have added formulas to determine if the...

Hello, I created a chart based on, among other things, data in 2 columns. The chart data is pulled from a table of cells in which I've entered SUMPRODUCT...

I have two columns and need to count if column A =1 and Column B =0

I am doing a database in which I need to filter a certain word in Column E OR Column F OR column G. It's a DB for a large number of music auditions in which...

Is there a way to make page items in a pivot table dependent? For instance, with page items of State and City, is there a way to limit City based on State...

I know it's possible for cells to automatically fill in typing that is identical to cells in the same column, but I can't seem to get it to work. I've tried...