i have the first name in the cell of an e-mail list and i need to add the
(@etc.com) can someone tell me how to do this
mfm             i need it to look like      mfm@etc.com
please help

I have a worksheet on which i have developed several macros that are
associated with their own button. I am trying to develop a
menu within the worksheet to place the buttons. Like a pop up menu, so that
where ever I am in worksheet I can access buttons.

Changed from Excel 2003 to Excel 2007.  Excel 2007 custom lists will only let
me enter about 18 entries.  I have several longer lists than that.  Is there
a way I can make it accept more than 18?  I tried to import my lists from the
previous version but the newer version cuts it ...

Instead of tying in 3*10^3 for 3000. whats the shortcut to do this with
regards to the scientific calculator where you have the 'E' button right
beside the Ans button. That 'E' button represents x10^*, where * is any
integer.

could anyone tell me how to work this graph out on excel 2007? thanks in
advance

I'm having trouble scrolling through the cells using the arrows.  When I was
typing in a cell I used to be able to press one of the arrow keys and it
would automatically go to the next cell.  Now when I press the arrow key is
sticks the next cell in as part of a formula.  I'm not ...

I would like to find all instances of a specific word in a column of approx.
1200 rows and copy them in either another row/sheet.
I tried the autofilter but it didn't seem to work.
Any suggestions?

Is there a way I can sort data and ignore the first word if it starts with
"The"?  Basically, I have an inventory list that has a lot of book titles
that have "The" as the first word and I'd like skip the and sort by the
second word.

I'm trying to copy a worksheet i created as a template as a new
worksheet in another workbook without having my formulas change in the
process.
I have tried all the pasting options and all the formulas get change

I see that I can instert form control/option button, but what I need is to
have a list of questions that can each be answered Yes/No
Question Yes  No
Question Yes  No

I want to find a quick way to hide various rows in a spreadsheet that contain
zero values.  i.e. below example i want to hide the whole row 'oranges'
sales
apples        100

Simplified scenario:
I have column A and column B with multiple rows of variable data in the
column A cells (i.e. account numbers).  I want to return a value to the cell
in column B pulled from a single SQL Server table which depends upon the

I'm using Excel 2007 and I'd like to change the default color Excel 2007 uses
to highlight the selected cells in a worksheet. When selecting a range (ex.
A1:D10). The selected range takes on a light transparent blue. Very hard to
see when working in selected range.

The built-in rules for conditional formatting (greater than value, less
than value, etc) work on the cell for which the CF is applied WITHOUT
having to specify the cell.
The examples for advanced rules using a formula require the formulas to

I have a protected spreadsheet but can still get in to edit the Macros
used. How do I stop this?
Cheers
Brian