General

data - validation - list question
excel 2003 I have several cells that I have some custom data validation configured I also want to have a in-cell drop down list for these cells Can some please tell me how I can do this I go to the data - validation and select list but it seems to take away the custom data valadation I have ... 28 May 2010 10:27

A single Page print for key items
I have a 2900 line spreadsheet from top to bottom with information about rooms and organized by it's room number: example: col a: b : c : d: 101: Main Lobby: Lobby is 590 Sq ft 102: Janitors Closet: 15 sq ft 103: Elevator room: 15 sq ft 103: Elevatior room 2: 24 sq ft I want to be able to have one source... 28 May 2010 11:34

Combine 2 worksheet change events
I have a worksheet that I want to place 2 worksheet change events on. i know that I cannot do this and that I have to combine them into one. I just cannot get my head around how I do that. Is there an idiots guide anywhere (idiot being the operative term here ;-) firstly I have this to make text in certain cells up... 28 May 2010 09:20

Argument description
What does =+SUMIF($G10:$G31,"Yes",I10:I31) mean? -- steve ... 28 May 2010 14:53

I need to unprotect sheet so I cn sve it but need a password?
I was working on my scouts accounts file which previously I have no problems with then on completion of some addittions I asked it to be saved.BUT it kept saying sheet is protected and I cannot alter it. This is hppening a lot recently and as far as I am aware I have not asked for protection on any of my worksh... 28 May 2010 10:27

INDIRECT
I would be grateful for any halp with this. I am trying to reference a cell in a different workbook using the INDIRECT function but I am returning #REF. This is the formula I am using : ='S:\Regular Procedural Reports - Test Folder AM\Credit Database 2010 version\[indirect(+M16).xls]rPortfolioAnalysis'!$S$66 ... 28 May 2010 08:15

Three variable correlation
Hi. I was wondering if it was possible to work out the correlation between three variables in excel, not just two. My data looks like this (this is just an example, with random values): A B C 15,283,741,924 22,891,175,671 182,489,383 12,450,453,827 ... 29 May 2010 21:12

Backup Excel file
I want to take backup of a file every time. I am using - save as - tools - general option - always create back up. The backup file is in the same location but I want to put it in a different folder. What should I do, kindly suggest. Thanks ... 28 May 2010 08:15

Make iteration default for a specific file
Hi! I have an excel file that needs iteration. However, it appears the setting saved with the file is sort of global: If it is opened with a fresh instance of Excel, the Iteration flag is set on; but if it is opened through an already running instance of Excel with the Iteration flag off as default, the iterati... 28 May 2010 08:15

Cond. Formatting, Mod(Row) and cell conditions
Is there any way to use the mod row function to shade alternative rows, based on whether cells have any value in them. I want to select a big range (eg A:G) and only shade alternative rows (A:G) once data is place in cells. the mod row function shades regardless if there is data in or not. ... 28 May 2010 06:05