I am sure that there is a way to press TAB and Excel will move to certain
grid references where I want it to, to get it to enter data in a worksheet.
How do I do this?

Hi, could anyone help me please?
I have set up some validation lists to do with training needs and in my
first list there are standard type of training required (ie Soft Skills,
Technical, On The Job, etc)

i want to know what is meant by reversed conditional formatting?

I maintain my school data in excel.  Column A is the ID nos of the students.  
Column M contians respective Fee amounts.  In columns y, z, aa, ab, ac We
maintian the sibling's IDs.   We calculate the total amount of all the
siblings to pay in a column.  The following is the ...

I am trying to use the "list unique" instructions given by xldynamic given in
the following link:
http://www.xldynamic.com/source/xld.xlFAQ0021.html
Its instructions are as follows:

I have loaded a text file with delimiters in excel.. It consists of three
columns.. i would like to copy only the third column until the last cell that
contains the data.. but my code is not working correctly.. it is selecting
the entire sheet which contains data.. i have used ...

Does any one know how to display (for the purposes of deleting) empty text
boxex on a spreadsheet???
Thanks

a1 has 10%
a2 has 30%
a3 has 10%
a4 has 20%

My department has just taken over responsibility for the creation of a
number of datasheets in several languages. These are all produced in Excel.
We draw our data from tab separate value text files. These contain lists of
specifications that shouldn’t vary from one file to ...

I'm raking my brains...I have a table where column A has job titles,
column B has the salary.  Column A has duplicate job titles, which is
OK, what I'm looking for is an average function that will give me the
average salary per job title.  I know I could do this via a pivot

I am having probems with combining both the right and the find function
command.
My formula is:  =TRIM(RIGHT(A1,FIND("-",A1,1)-1))
Say in cell A1 to A3 I have the following combination of names.

Is there an expression that will return the cell's outline level that can be
used for an array criteria, such as in =SUMIF() or =SUMPRODUCT() ?

When importing data into Excel 2007 (using Microsoft Query)  the table style
default is always "Table Style Medium 9".  How do I change that default for
all instances of an import?  I know that I can change it for each individual
instance by going to the "Table Tools - Design" ...

Is there any way that we can create a formula when , eg, A1 is certain
value (-), then the whole range A1: D1 is filled with yellow color ;
A1 is certain value (+), then the whole range A1:D1 is filled with
green color?

I have a worksheet where I'm trying to get the total sales in the south and
in the east.  My formula looks for the words "south" and "east" in column A
and totals from column D.  This is actually the example from microsoft help.  
All the formula returns is #value using the ...