I have a somewhat intersting problem that I'm having trouble solving.
Consider the following simplified spreadsheet:
          A           B
1         2

I have a macro that will save the workbook prior to deleting all specified
cells but I'm trying to make it save as file name of what ever the user
inputed into a specified cell or cells like the date that they input and
another cell that they inputfor like name of etc.....

Using the example from the http://tushar-mehta.com/... site, I have a mean
of 1.55 and a standard deviation of .6176.  Now when I plot the data as per
the example on the site, the y-axis starte at 0 whereas the chart extends
into negative terriroty making for a Bell Curve that ...

I have 3 Excel name/address worksheets, 2 being smaller subsets (calendar and
Xmas) of the first large worksheet called "cards".  Although Xmas and
calendar are included in card, I would like to import their origin back into
card by populating a new column which new column would ...

I need some help please...
If C2 = A:A than I want it to return the number that is in B:B next to the
match of C2
Quick report       Number of Line Items                Entry Number

Hi,
Could someone pls help me with this. I have "weeks" in my column labels.
Sum of 1-Jan-07    Sum of 8-Jan-07    Sum of 15-Jan-07    Sum of 22-Jan-07
As you can see, the lables come up as "sum 01-Jan07". How do I rename

In previous versions of Excel, when I did a format/cells/alignment and then
checked the "wrap text" box, the row height of the cell would change if that
was required to display all the text in the box.  This doesn't seem to work
for me in Excel 2007.  I click on a cell which has ...

I am looking for the formula to look up values/range in column A and provide
the correlating value in column B
ie
      A                        B

Using Office 2003 as well as Office 2007
Workbook is missing the restore down/up/and close buttons to enable changing
the size of the screen.  It does not have the resizer in the bottom right.
Double clicking in top bar does not work.  

Rather than creating a bunch of new fields, is it possible to conditional
format a field that has a formula in it? I've attached what I have below for
cell D5. We want anything 3 or greater to have the whole cell green and
anything below 3 to be red.

When selecting text to columns, fixed width, Excel inserts far too many
column breaks since several of the columns are long strings of text with
spaces between the words. Is there any way to remove all column breaks at one
time so that I can then reset the few that are needed?

Is there a shortcut for this other than using the mouse to click the
plus/minus sign or the numbers in the top left of the screen?
Also, is there a shortcut for renaming a worksheet instead of double
clicking or right clicking on it? Similar to F2 for renaming a file name.

I currently have data in various rows highlighted.  For some rows, columns
A-M are highlihgted by row in a specific color.  Columns N - R have data but
are not highlighted.  
I am protecting the sheet so that only columns  O and P are editable.  When

I was given a spreadsheet with a numeric column that should have been
formatted as text.  The column should be a 3 character ID.  The ID's
that happen to have all numeric characters are formatted wrong.  For
example "030" shows up as 30.  I know that I can format the cell to

Excel XP & Win XP
I am using the Substitute function in conjunction with the Indirect function
in a Data Validation formula.  My question is about the Substitute function.
Is there a way to substitute nothing for more than one thing in a single