I am a trying to learn excel and cannot get how to do this.
I am working on a real estate sheet
On sheet Home summary I am to calculate the number of houses in the
NESector from the Home Data Sheet using the RANGE names.

If you will refer to my screenshot, I'd like to make the graph appea
more dramatic. The y values on the left go from 0-30,000. Is ther
anyway to make the y values skip a few thousand and scaling it so i
looks more dramatic

what i need to do is auto fill a column with the numbers 1-506.

I am using this function successfully
=IF(NOT(ISERROR(FIND(" FLR",AC11))),FIND("
FLR",AC11),IF(NOT(ISERROR(FIND("FLOOR",AC11))),FIND("FLOOR",AC11),
IF(NOT(ISERROR(FIND(" RM ",AC11))),FIND(" RM ",AC11),

Bonsoir tout le monde.
Pour des besoins de maintenance d'une petite appli qui tourne sous Excel
j'aimerais pouvoir par code supprimer un module et le remplacer par un
autre.

Some rows in my spreadsheet are colored.  When I try to print it, the color
is hiding the gridlines.  I want the gridlines to show.

One of our vehicles did a speed trial.  Time was taken about every .03
seconds, and is in Col A.  Col B has the speed for that time.  I want to
find how long it took the vehicle to reach certain speeds.  I'm thinking a
formula down Col C that says "IF this is the first instance ...

This is probably a simple question for most of you, but I have an exce
file that contains approx. 400 sheets, with a summary sheet.  How do
copy a simple formula to read Cell B1, but the next sheet needs to rea
Cell B2 and so on.  Example:  Sheet #1 is the summary, then sheets 2-40

My workbook has links to other shared workbooks in the network.  Whenever
the file is opened, the user gets the message "This workbook contains links
to other data sources".
Is there a way to skip this prompt?

I have a spreadsheet with names, addresses and email addresses.
I have copied the email addresses from word into excel.  However I am
unable to edit the email address hyperlink for some reason.
Also if I try and enter the email address directly into a cell, it

Forum,
Is there a quick way to remove duplicate entries in my document? I am
cutting and pasting dates into excel, and I have 859 entries so far.
The problem is that many of them are identical. Is there a way to have

Hi. What exactly is the point of the custom views dialog box (found under
view menu). When I access it, there is nothing listed under 'view'. Is this
supposed to be a list  of all the worksheets?

I have to make a format for a purchase order which can be used fo
several divisions of a company
At the top I would like the user to be able to select the logo an
address header from their appropriate division.

What the formula for subtracting multiple columns?
Ex. Hours Work - Lunch - SickTime - Vacation = Total
        9                  1          3              0            Total

Occasionally, when I open an existing file in Excel, it will be "read-only".  
I have never "asked" Excel to do this.  I looked on the online help about
going into Windows Explorer to remove it.  I have never set it up to do this,
it just seems to happen randomly.  What am I doing ...