Is there a way to prevent the R1C1 reference policy from being used in excel by using a group policy? If not, how can I prevent it from being the default...

Is there a way to protect a sheet, and its formulas, but only for a few cells - for the 2003 version? for example: protected - f3 to f6, f8 ...

Our system reports unfortunately have negative signs in back of numbers instead of in front. When we export them to Excel, the negative numbers seem to be...

Hi all Would appreciate some assistance on what appears to be a simple request but may need a combination of expressions to fulfill (hopefully not!). I...

I would like to embed a table generated in excel into a MS word.doc. have tried screen capture methods but the bmp image is still not of adequate quality.

I would like to disable users from having the ability to change the data source or connection in Excel 2007. Is there a setting somewhere that would 'dim'...

Hello Does anyone know how to turn off "Totals" in Excel 2003. I can't find it and it's driving me crazy!! many thanks -- James.

Hi There Is it possible to automatically name a file based on two cell entries when saving. E.G A1 B1 20090623 ...

I know this is probably a very basic question but hope someone can help. In reference to copying formula... Lets say, for example that I have a number in C1...

How do I increase the size of the checkmark in a form box without increasing the size of the box?

Have several worksheets with just two or three rows of data. Would like to print all worksheets on one page.

I'm using lots of arrows in an Excel spreadsheet, so I'm copying and pasting the same arrow over and over. Every time I paste the object, it appears in...

Let's say I have one column with data like this: C012 But all I want to do is return all cells in that column that start with "C" (there are many cells that...

I am trying to devise a spreadsheet so that i can track pupil progress from year to year. I know their age and their assessed reading age and want to track...

I am using Excel 2003 SP3. I can only work with the Pivot Table or Pivot Chart, not with the actual source data (it is a "view," something I'm not really...

I opened up my workbook this morning, and a security warning for my macro showed up. now, my macros - the code i inserted into the sheet - is not working. ...

i have some code on the bottom of one of my sheets, something like this: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("B3"))...

TRY: Code: -------------------- =INDEX($C$1:$C$5,MATCH(MAX(IF($B$1:$B$5=$D$1,$A$1:$A$5)),$A$1:$A$5,0)) -------------------- Confirmed with...

Does anyone know how many built-in functions Excel 2007 has? Thanks.