I am wondering if it possible to have a drop down list that allows more than
one selection.
Thanks for any help.

I have a worksheet were I need to color a row based on two criteria -
(1) if the value in cell E6 is "No" and cell C6 is blank, I would like
to color the entire row green.  I need to do this for an entire
worksheet and I would like to do this in VB.  Is this possible?

I was just wondering whether or not you can change the size of the
columns part way down the page without changing the ones at the top?
Do you have any ideas?
Also,  I am hoping to be able to validate the numbers that can be

I am trying towrite a short bit of code to filter using what a user put in
cell.
ie user puts "01" in cell A3
then the data below is filtered to show only results matching 01.

I am new to excel and to multiply three colums together then add them
together for a final answer in a box

Wonder if anyone can answer this for me as it's driving me crazy!
I have a spreadsheet I've inherited.  The dates appear in cells as Nov 11,
Dec 05, Apr 08 etc.  Each date is left aligned as if text.  The apostrophe
doesn't appear before them when you click in the cell (i.e. not ...

I'm working on a huge excel spreadsheet that has numbers in columns that must
be added.   However, because this spreadsheet is constantly sorted by various
variables, I'm unable to use the Sum() function to add these - and thus have
resorted to looking at the taskbar to find the ...

I have an xls file with worksheet made up of 3 columns of data.  I save
it in Excel 2003 as csv file.  When I open the csv file, the columns
are lumped into one column.
When I do the same thing in Excel 2000, 3 column appear and this is the

I have some dates in a column like
1/01/2006
10/01/2006
I want just the month and year to be there but I cant just format the cell

I receive monthly sales reports in Excel 2002, SP3.
Column A lists customers, B is City, C is State, and so on, thru Column J.
Each transaction is reported in a separate row,so in a given report, the
same customer may have several rows, often identical ones (if they purchase

How can we tranfer data from IBM iSeries in MS-Excel 2003 with SP2? But I am
having option of transfering data from iSeries in MS-Excel 2003 with SP1 in
Menu (Data). Could anyone guide me.......
Best Regards,

Hi NG members,
I've dredged up some old work and I can't remember where and how a
given cell is used in my spreadsheet formulas.  Is there a way to find
all instances where say cell F32 is part of a formula in another cell?

I have programmed a valuation model in an Excel Worksheet with VBA. A
full calculation round takes about six minutes.
I am quite sure it can be cut down by 4 minutes at least by more
efficient programming, but I wonder whether it is possible to get a

I have a SS that I'd like to have the first x rows (in my case 3) printed on
each page. Not a Page Header (as I already have one).
I've already got the Print Area Set, Orientation etc.
How would I do this?

How do I convert numbers to absolute value?
Thanks