Is there a way to have excel generate a list of file names in a
specified folder?  I have around 300 files in a folder and I would like
a list in excel but I don't want to type out every file name.  They're
power point presentaions if that makes a difference.  Thanks for any

is there an easy way to find keyboard shortcuts for excel on mac, like
copy, move etc

I have a spreadsheet that I need to apply conditional formatting on in
which  I have four values: Over 85
Refused
Surgery

A friend of mine is trying to do a sort, but is getting the message that it
can't sort merged cells.
He's not aware of any merged cells.  Is there an easy way to detect a merged
cell?

Hi;
Is there a AutoWordSelect on the drop down list that was created fro
Data -> validation?
Thanks,

I want to select some rows from two different worksheet pages and have them
print out on the same piece of paper ( I get one row printed out per sheet of
paper right now?) I want all selected rows to print out on the same piece of
paper. Thanks

I am trying to set up a spreadsheet to calculate tips for wait staff. There
is no cash involved and all tips are paid through the server's paycheck.I
would like the spreadsheet to contain all the names of the staff and be able
to designate which ones worked that particular shift ...

When I open a particular spreadsheet, it asks me to update the links (which
there are some), and whether I do or not, the spreadsheet won't display.
Excel is open, but does not show a spreadsheet.  I do not see it listed in
the Window menu item to select it, in the list of open ...

how do i get the xml option in the data dropdown of excel 2003

i'm trying to export my records from excel to a csv file format, but i
need to have all text fields to be surrounded by "" marks like the
following format:
MY PRODUCT NAME

How can I switch data between cells, rows or columns in one step? Fo
instance, if I want to switch the contents of cells A1 and B1, how do
do that without having to retype everyting, and without having to use
third column (that's what I do now: first I copy B1 to C1, then A1 t

I would like to average the values in column B that lie between 2 value
in column A. What I have so far is =average(if($A3:$A100, ...value i
column A is less than 46 and greater than 34..., "" ""). I have bee
unable to express the second term with the correct syntax. I assume

Does anyone know of a simple way to search text strings from right to left
instead of left to right? I can buy software for this but thought there
should be a non-cost option somewhere out there.
I am using Microsoft Office Excel 2003 (2)

Hi experts;
I m using excel 2002.
Is it possible to give date vaildety to a excel file after that date
when anybody open that file excel would give Msg like " can not open

This works through "ActiveCell.Offset(0, -8).Activate" but then doesn't.
Any help appreciated.
Sub SortforMember()
   Worksheets("Sheet1").Activate