Hello how do i create a drop down list in a cell?
I can create a list but cant figure out how to create a drop down list

Does anyone know how can we filter data within a pivot table? or sort
the data from ascending to decending order withing a pivot table???
Can we do that?
It doesnt seems to work?!

I've developed a program using Microsoft Excel 2003 with Visual Basic
Editor.
How can I save the program as .exe file so that a user doesn't have to
open Microsoft Excel and VBE to execute the program?

I wish to make the Check Box larger in my cell (not the text, the actual
box). The default size seems too small. I've tried editing properties with
no success. Is it actually possible to do this?
Thanks.

I keep a few global variables in a sheet called "admin" and give cells name
like:
pct_fee, gross_price etc.
How can I read named ranges smarter than this through VBA:

Hello, I am trying to create a column staring with the present month in A12,
going back 12 months to A1. I always want the present month to be in A12 and
then have the previous months going back to A1. I can use MONTH(TODAY()) to
get the month number and use a lookup for the ...

I created a form in Word, cut and pasted it into Excel on three different
spreadsheets.  How can I format the worksheet to copy the text over to the
other two worksheets
without having to enter text three different times?  Sort of like writing on

I have entered dates in a single column for each row.  When I entered the
first date in "A1",
how can I get the rest of the date series to update in a progression
automatically?

I have a spreadsheet with about 450 different Web Queries in it which
have been created with a VBA Macro. Does anyone know how to remove all
the Web Queries in one hit once the Macro has stopped running?
I have tried CTRL-A and then right clicking to remove the Web Query but

If the number in B1 is greater than the number in A1 and the word to appear
is INVERTED then =IF(B1>A1,"INVERT","NORMAL") works in C1. How can I format
cell C1 so that it is red for INVERT.

I have a long column with various text in the cells.
Both capital letters, and lower case.  Some cells have both.
Would like to make everything CAPS in all the cells, hopefully in one shot.
How can I do this, please ?

I'm trying to understand why this occurs. I have read info regarding
serial dates, how excel stores dates etc but can't find an answer to
this. It has cropped up while using criteria in advanced filters - I
would have expected to be able to filter on =date. I can get round it

I am trying to put together a simple chart. An "investor" invests in a
building project with multiple payments during construction. If the investor
puts a total of $100,000 into a project that takes one year to omplete and
receives $10,000 in return on investment his actual APR ...

I need to be able to work with Excel from my home computer .  I will mostly
be doing scheduling, changing spreadsheets that are emailed to me, and
probably no more.  Which download should I get?  Where do I get it and how
much will/should it cost?

There is a certain company that I won't mention out of politeness that
stores data files with an xls extension but the files are actually text
files.  I have to work with hundreds of these files and right now I must
manually convert them from text format to xls format.  I would ...