For e.g: a set of data:
UB        UC          
1          23
2          444

I have set Data Validation on a particular cell so that Jan, Feb, Mar etc
appear in a drop down list.
I need to be able to advise non mouse users how they can access this list.
I have tried "Shift" + "F10" then used the arrow keys to select, "Pick from

Hi guys,
Just womndering if there is a way to disable printing in an excel worksheet
or wook. I know you can in pdf but trying to do it in excel... any suggestion
would be appreciated...

I have spent a couple of hours reading through previous posts but cannot
seem to find quite what I am looking for.
I want to CF a range of cells in one column depending on there being any
text in the corresponding range of another column.

I am trying to change a cost price list into a retail price is there a
simple way to change every single price on a sheet without having to do each
one individually ?
Many thanks

Hi Experts:
Is there a way I can build a Macro to do the following:
This is all One Workbook
Worksheet 1:  The Columns are: Dept, Login,User Name, Location and Count of

I am trying to use the look-up feature to sort/find data withhin a
spreadsheet.  Here is what I am trying to do:
Cell A: Employee Number (all employee's)
Cell B: Hours worked

I am working in Excel worksheet that represents an invoice.
When the total price is calculated I need to translate the invoice sum into
a phrase.
Example:

I frequently need to create invoices in Excel using a template I downloaded
from Microsoft template library.  I would like to number these invoices
automatically.  I.E., the first invoice is numbered 08-001, the next 08-002,
etc.  The number is located in the same cell in each ...

Hi Experts:
This is my formula: =SUMPRODUCT(--('SP TCS REPORT'!H2:H10000="ACS-Prince
George"),--('SP TCS REPORT'!I2:I10000="Count of Observations">0))
The total of records should be 182 but this formula displays 179

There are given data
Under column A, there is a date.
Under column B, there is a score
Under column C, there is a date.

I am setting up a spreadsheet of investments.  The first column (A, row 1)
has Monday 01/21/2008, the next row (column A, row 2) is Tuesday 01/22/08 and
so forth through the end of the year (Wednesday 12/31/2008).  It takes a long
time to set all that up.  I'm now wondering if ...

I have to cut varied lengths of timber out of much longer lengths but I do
not want to end up with any more waste than is necessary. Is there an Excel
function whereby I could enter say twenty varied lengths and find the most
economic combinations to get out of several given ...

When I regress 86 pairs of lab duplicates, I get a better fit by hard-coding
0 intercept than letting XL calculate it. This seems wrong: the least squares
regression should be the best fit of the data. I compared LINEST and the
Regression tool in the Data Analysis Tool Pak and ...

Hi Experts:  I'm really lost on this one...This is what I want to do:
On Worksheet 1: I have 32 Locations that have a # of Observations...I want
to take all the lines of data  from Worksheet 1 for each separate location
that exceeds the # that is on Worksheet 3 in column H and ...