In Excel 2oo7, is there a makro that uncheck all check boxes in a worksheet? (empty them?) -- Felix

In Cell N4 I need to average: D4 G4 J4 M4 They may or may not cotain N/A If they ALL contain N/A I need it to return and N/A I will have more...

Where (or what replaced) the pivot table toolbar? All the online help tells me is to click on the "Design" tab, but where do I find that? I am trying to...

Where can I find an honest mortgage refinance comparison spreadsheet preferably one that will graph the cost/benefits over time for more than one alternative...

Hi, I would like to change the spreadsheet name to say whatever I type in cell A1. Please advise thanks TJ

Hi all, My wife did write her homework and by mistake saved it as addin (xlam file). Now , we need to recover the original file as worksheet. How can I do...

Is it possible to use EOMONTH as a test criteria in a sumproduct array? I have the EOMONTH set up as column headers on my worksheet to show a 7 month window...

Is there a way to do a formula that returns a count of days remaining in a month (or specified date range) that doesn't include Sundays? Ex. Today's Date:...

I have the following table that I need to lookup a value. I am trying to use the =MATCH(G1,LLTable,0) formula to lookup the G1 date 04/03/2009 in the LLtable...

We have Excel 2003 SP3 on Windows XP SP2. Recently on one device, when we select some cells and right click, we don't see the typical menu (copy, cut,...

I keep getting the following message when I try to close a file "Cannot find 'C:\Program Files\Microsoft...

I have created a workbook with a number of worksheets, each of which has a number of locked cells and for which protection is enabled to prevent users from...

I Have a Macro which contains some Costing Related Report... Now i got a problem with the macro that for the next month that the data may vary and the Macro...

If you want to do any or all of the following. Visit http://www.excelitems.com and Download Open XL. 1. Run Charts Slideshow 2. Calculate Business Working...

I have two Excel files containing several sheets each. How do I move a sheet from one file (workbook) to another? I tried the move or copy function in the...

I have a data set in pivot table which has 12 months and each month has two items Capital & Operating spend. I want to get percent % of total for each item...

i want to enter all my store recipts from all diffrent places into one spread sheet so ican make a total of my spendings can someone please help me

Hi, I am using EXCEL 2003. I have a simple formula in col b... =(a1).. which I dragged down to produce =(A2) etc. If I insert a row anywhere in the range, it...

I have a table as shown in the example below. Can you help me with a formula that pulls out the the project code with maximum hours? this table is from a...