I'm trying to perform a sum on a few rows, but when I add a new row I have
to update the range in the sum to have the new row included. Is there a way
to have the range update to include the new row(s)?
Hope that makes sense lol.

I have a list of numbers in A1:A20 that has a STDEV of 27.6. I need a
formula that I can copy down that will tell me how many STDEV's above
and below each number is. Thanks in advance PJ.
13

Why is the formatting of email addresses in Excel so problematic?  When I
enter an email address into a cell it automatically creates a hyperlink.  I
don't want it to do that, I just want it to be text.  Furthermore, when it
creates the email address as a hyperlink, it also ...

Can anyone tell me how to eliminate the extra cells that display on an EXCEL
Worksheet?  I got one back that now displays 66000 rows.   This makes it hard
to navigate.    

As you see below I am trying to fill cells with "CSR1, CSR2..... How do I
right that without caling each cell?
   Sheets("Team List").Select
   Range("B2:B16").ClearContents

This is my first post and probably will be my most confusing lol,
I am creating a excel document for a college graphic arts class.
Bascially I would be entering alot of projects with due dates for everyone
of them and I would call this sheet "inner class"

Is there a way to set up an auto-tab? Once I enter a certain number of digits
in a cell (say 8), I want the cursor to tab to the next cell on its own. Just
like when you fill in your telephone number on-line and the cursor jumps to
the next box after you've entered a 3-digit area ...

=SUMPRODUCT(('YTD PROD HRS'!$F$5:$F$65536=$C$46,$C$45)*('YTD PROD
HRS'!$C$5:$C$65536='PHASE HRS MONTHLY'!B48)*('YTD PROD
HRS'!$B$5:$B$65536>='PHASE HRS MONTHLY'!$A$2)*('YTD PROD
HRS'!$B$5:$B$65536<='PHASE HRS MONTHLY'!$A$3)*'YTD PROD HRS'!$D$5:$D$65536)

I feel like this may be a really dumb question but here goes. I've been
using Excel for several months now to creat various spreadsheets. In order to
avoid formula errors or to end up with 0's on all the unused lines I have
been using If formulas for example:

The scroll lock in status bar shows "on" without a tick in the checkbox.
The only way I can overcome it is to turn the computer off, then start again.
Any suggestions ?

I want to display the name of the presently selected scenario in a cell on my
worksheet.  Is there a worksheet function that will do this?

Ok. I would think this simple but can't figure it out..
If value cell 'A1" = True
then paset contents of cell from different sheet in same workbook.
=IF(J10,'4. Environment IP Addresses'!B6," ")

Looking to sum up several workbooks into one master consolidated book.  
Want to have the list of names of files to sum up taken from a range,
like:
Col A    Col B

I need a pop up box with large fonts then the msgbox is using.  Is there a
way that I can change that FONTs size and color?  if not were do I go to find
some way to have a "customer" msgbox.
Thanx,

I am trying to get the FONTs in a msgbox larger and a different color.  Is
that possible? If not how do I construct a custom msgbox that will pop up
when the workbook is opened?
Thanx,