Functions

how to undo scrolling tied to a single cell
when I click on any cell in my spreadsheet I pick up all the surronding cells no matter where I am on the spreadsheet. For example, if the "frozen' cell is G6 and I click on D4 the spreadsheet shows D4-D6, E4-E6, F4-F6 and G4-G6. I don't know how this occurred or how to make it go away. Any suggestions? ... 23 Feb 2010 10:11

How can I SUMIF between rows rather than columns?
I need to sum the values in one row, but only if the corresponding values in a second row fulfil a criteria. e.g. With a budget laid out with a column for each month in 2010: for each month sum "Cost A" if "Income type 1" > 0. Thanks! ... 23 Feb 2010 07:57

Capturing Real Time Data
Hi, RTD is placed into an Excel 2007 cell via an Add In. This data is updated at random times. I would like to capture this data every minute and place it in another cell in the same Worksheet. Thanks. ... 23 Feb 2010 23:52

How to run an event upon changing the value of a specific cell?
I want to run an event or a mcaro only when a certain cell is changed. i.e., if the cell A1 value is changed, then do such and such ... ... 23 Feb 2010 10:11

Get all sheets names in one sheet
1.I have 50 Sheets naming with employee names. Is there any option to get all Sheet names in one sheet. 2.And can i give link between them, means if i change the name in the sheet, can it be changed in the sheet name also. Kindly help me in this? ... 23 Feb 2010 09:03

FIX FOR =N/A errors from EOMONTH
I discovered that, after a lot of pain and frustration, a fix for a file corrupted by this error is to simply open it in Open Office calc, and save it down again. I lost three hours figuring this out, but saved about 20 by not having to redo all of the =n/a's. Hope this helps someone. Best, Drew ... 23 Feb 2010 00:17

My Excel operates as if Ctrl is always depressed. Help!
Somehow I pressed and held the Ctrl key down too long (I guess) and now Excel operates as if I am always holding it down. PgUp & PgDn take me to the next worksheet, arrows take me to the next cell with a number in it etc. How can I get it back to normal? Thanks ... 23 Feb 2010 01:23

Countif Limitations
Hi, I have a problem with Countif, and that is it seems to only work where the criteria is 255 characters or less. I have concatenated about 30 columns of data into the next available column and wanted to use that column as the range and each cell within the range as the criteria. Some of the concatenated ... 23 Feb 2010 04:40

replace a single character WITH FORMAT in a cell
if i have a cell as "I am a boy" and I would like to replace all the a's in this cell with red a's How can i achieve that? it seems Excel will replace the whole cell content into red... ... 23 Feb 2010 22:45

Counting NON-Blank fields
I have two columns of data that I export from MS-Access into Excel and then paste into another excel spreadsheet. Column A is my description; Columns B and C are my values. Both Column B and Column C have 50 rows. (This number varies) Column B has some blank rows. Column C has data in all rows (always). I... 22 Feb 2010 22:04