I need to put a list of names in a cell.  It is cumbersome to use spaces to
get to the next line.  Is there a way that I can hit enter(or some other
function)  to move to a next line within the same cell.
Thanks

Dear Sir,
I have tested the MS Excel 2007 (Beta2) on color sorting today.
I find that this function is partially successful. It is unable to group the
items of the same color on top or at the bottom witthout an error row above

Using a formula, I replicate the appropriate name of one of the many
excel reference areas I have created.  I would now like to use the name
I've generated in a VLOOKUP formula.  However, the formatting is off
and I don't know how to fix it.  The VLOOKUP formula does not like the

I'm trying to create a macro that automatically saves a file with a file
name taken from a cell - ie: Order number 12345
I'm sure it should be possible but I do I do it ?
Sorry if that's really basic but I'd appreciate any advice.

I am trying to use the RATE Function to calculate the Annual Percentage Rate
for the following Loan:
Loan Amount £300
Payments £15 a week

I would like to get the sum of 7 cells which restarts when a cell containes a
zero.
I want to have a result in an ajoining cell of the sum to a maximum of 7
cells in the ajoining column

Hi everyone.  Simple question...how would I correct my formula such that if
the date in C8 is a certain date (regardless of the year!), then...    The
formula I tried is:  =IF(C8=AND(MONTH(10),DAY(26)),"text")        where
C8=TODAY().  When I click on the AND in the wizard it ...

Thanks Bob P for this.
Is it possible to modify this so that it also turns the formula to value if
the cell is not equal to 0 or the formula returns an error like
#NT/FND,#NUM!, #N/A etc.

I am trying to create a Employee time sheet & I need to figure out the
overtime and break it down. Ex:when I add
A1+A2+A3+A4 = 43 (12+12+12+7): however. out of the 7 i only need 4 to
complete the fourty the rest is over time, so in the cell I need to show the

I have a column of names and a corrosponding column containing their contact
numbers. I want to enter a paet of that name and i want to have all the names
containing that part. but i cant find how to do this. please help.
thanks in advance.

I'm trying to remove duplicate rows from an excel worksheet, but Advanced
Filtering is grayed out and not available. Is there a setting I need to
change to make this command available

I'm working on a randomization procedure and I was wondering if I could link
a check box to 3 different cells.  See, right now I'm filling out the code
value for each of the 3 cells.  My counter works so that it compares the
values of the three cells to the values of three other ...

I have data that looks like this:
       A              B
1 Account       Notes
 ---------       ------

Is it possible in Excel to select an item within a page-by in a pivot
table and have a subsequent pivot table with the same drop-down pull
the data for that selected item?  For example, let's say I select CA
in a pivot table and the data come up.  And I also have another pivot

Morning!  I have a pivot table and I need to create another report from this
pivot table that only shows the sub totals and totals .  How do I do this?  
thanks