I am copying data into a worksheet from another program.  Excel sees the
numbers as text and I get an error message.  
I would like to highlight the entire worksheet ( via clicking on the area
between the A and the 1 in the cell/row identifier upper left corner) and

I want to use a "IF" formula on one worksheet to look in column A1 and put
the result of column B1 as a result, if A1 = 1, then be able to copy this
formula across so it still looks to column A1 and puts in C1 if  A1=1. I can
do this by making A1 an abosolute reference but then ...

Hello
report comes from another system - which I import into excel 2002 -cells are
formatted as general     Here we go...               
row 1 has the headings , row 2 has the name of the employee.       

I know that if I place the following formula: =IF(A1="","",EDATE(A1,1)) in
cell B1 I will be able to obtain a date 1 month beyond the date I input in A1
(e.g. if A1= Sept 1, 2007, than the formula will result in the date Oct 1,
2008).

I have several columns that have totals. I created another area of the
spreadsheet where I wanted to use 2 of the totals from 2 columns.
I used the cells address (= I333) in D21 and (=J333) in E21. The showed the
totals as they should and if anything changes in the respective ...

Does anyone has any recommendations for a good program/spreadsheet that I can
use with Excel to balance my checkbook? .. I've searched the web but there
are lots & lots and I have no idea which way to go .. many thanks!

I want to creat a dropdown menu that will display in the cell on part of what
is shown on the dropdown menu.  For example, if the dropdown menu item is
"A101 - plan & prepare for", and want the cell to display "A101".  Is that
even possible?  If so, how?

How can I add numbers from separate worksheets and total them on another sheet?

I have set certain cells in a column to be certain colors. These cells have
not been conditionly formatted. Is there a way to sum the cells based upon
their color?

I have opened a worksheet with a pivot table in it.  When I try to change (by
clicking in the selection box) in the dropdown field to show only the
selections I want to see I cannot, the boxes are locked.  How do I enable the
ability to change these selections

I have worksheet that has around 250 rows with 6 columns.  I need to validate
that the data is the same for two rows at a time.  How can I highlight any
unique data?  
Example:  

When i am scrolling thru a spreadsheet with the down arrow key, I would like
to have each row highlighted as i scroll downward with the row the current
row being highlighted.
Is this possible

I have a spreadsheet with formulae referring to the next cell to the left,
for example B1=A1*2.  When I insert a column to the left of B, B becomes C.  
I want the formulae to continue to refer to the next cell at left, so that
B1=A1*2 and C1=B1*2. But when I insert this new ...

Good day,
I would like to set up a small VBA sub that will simply dynamically add a
sheet at the end or last position of the worsheet regardless of the no. of
worksheets in the workbook and independent of the worksheet names.

Good Morning All, XL2007
I have a basic Pivot Table summing vales across a row of months.
   A                    B                 C                D
Category            Month1        Month2       Month3