General

Autofill
I'm having a problem with autofill. I can drag and drop but when I want to see the options, before I can mouse over to the options box, the box vanishes as soon I've moved off the initial cell that was copied. I'm not fast enough to get to the options, so it would be good if someone could tell me how to keep th... 5 May 2010 08:14

Splitting cells
in cell A1 i have the numbers 123456789. i want cell B1 to have numbers 1234567 and cell C1 to have just 89. what is the formula? i have tried text to columns ... 5 May 2010 09:20

Validation list in data entry form
Hi I have a data validation list which I use in the spreadsheet for the user to select from the drop down. I would like the user to be able to user a data entry form instead of adding to the master sheet. Is there any way I can create a form for this that will use the validation list drop down. When I trie... 5 May 2010 14:55

Macro match function problem
Hi all, I have a problem to create a match function macro with the following senario, whereby the lookup_array is currently at col D1 to D4, and the lookup_value will be A1. The problem is my lookup_array number will change to (D1 to D9) or (D1 to D15) or any row at row D based on new data inserted.. How to ... 7 May 2010 13:24

Copy and paste to the last Row of columb A
Good morning, pls help me, A B 9800 =A1*2 9800 9800 9800 9800 I want copy formula B1 and Paste B2 to ....., stop a t the last row of A. Thanks ... 5 May 2010 21:37

want questions on EXCEL-2007
Hello Everyone, I want some questions on EXCEL-2007 for checking competency level of the user. Please help. -- Ananta Gupta ... 5 May 2010 03:53

how do I convert pace per mile to total time in minutes in excel?
i have pace per mile in minutes and total distance. I want to calculate total minutes. What are the formulas I use? I'm currently showing pace per mile as "10:00" or 10 min per mile. ... 5 May 2010 10:26

sort 2 columns alphbetic and make dictionary
I'm Mahmoud from Egypt and recently joined to ur group I have a problem with excel file , and need help from u or anyone can help to solve the problem I have a dictionary excel file contains 2 columns in about 40 pages now I need to sort all the data alphbetic the problem is I can sort only one column an... 5 May 2010 09:20

Formula Help
I have a spreadsheet with two tabs. The first tab(A) is manually linked to the information on tab (B). Tab (B) is subtotaled and whenever I change the subtotal it causes an error message on Tab A. I want to create a formula that whenever I make a change to tab (B) tab (A) automatically updates without me havi... 4 May 2010 23:32

Recognizing an Unstable Result
In Column "B" I have a list of results. Some of them have the result of "#VALUE!". I would like these cells to be represented in Column "C" with the result of "0". What IF statement correctly tests for cells which have "#VALUE!" in them? -- Ken ... 5 May 2010 09:20