I have one column of text and I want to convert it from
mixed to UPPER Case.  I thought I was following the
instructions (in help) correctly, but it keeps saying that
I have circular reference for the formula where text

Hello, i have a question on conditional formatting.
I am using Excel 2003.
if i try to use a condition that references another worksheet, it gives an
error.

Another person was accessing this file and when they closed it (I don't know
what procedures they used), it had (Group) after the name.  Now a number of
commands are grayed including the protect worksheet command and various
others like sort and filter.

Suddenly, the arrows (either up, down, right or left)
won't move from the cell that's highlighted to another
cell .  Now they move the entire worksheet.  How can I
reset the arrows to move to adjacent cells?  Any help

Relative Excel newbie here :)
I have an Excel file with three worksheets in it.  Right now, only the first
worksheet has data--the data is four columns of unsorted text (it's a list
of karaoke songs...the columns are labeled "Song Title", "Artist", "CD", and

I have a excel worksheet that i want to copy the data and the formula
to a new worksheet .The worksheet was linked not embeded so it won
work without the link.
When i try to copy it i only get the data not the formulsa .

I know that if I want to set the row height to fit the
contents, I doubleclick on the line heading between that
row and the row below it.  My question:  sometimes this
works and sometimes it doesn't.  Does anyone else have

Is it just me, or has something changed with Excel 2003?
If I have a cell with wrap text, shouldn't the row size automatically
increase if the text exceeds the cell size?
For some reason, my text just gets squished.  I know I can go to

When I try to import an excel file into Outlook - I get the message to go
back into excel and name the ranges.  I understand highlighting the area -
going to insert/name/define/add/ok.  Here's where I'm having difficulty.  I
receive a contact file with names and phone numbers.  ...

i have one column of data i want to change the text into capital letters
without doing each item individually

trying to implement data validation where the number entered must be 1
greater than the maximum value in a dynamically defined range.
e.g. mylist is defined as =OFFSET(Sheet1!$A$1,0,0,Counta(Sheet1!$A:$A),1)
and i want to say that the value must be a whole number equal to

Is there a way to import into outlook from excell that wil
automatically send the email out. I know that i will have to put th
email address in a column in the excel spreadsheet
--

I am using Excel to run a query against a SQL database.
One of the colums that is being returned is a web site
address (e.g., http://www.mywebsite.com)
Is there any way to format the column so that the data

On one of my workbooks, for the past couple of weeks, I get a statement when
opening the file, telling me it's linked to another file and asking me
whether I want to update this workbook with changes made in the other
workbook.

How do you refer filename1 to a cell in the formula bar?
Example:
='\\Year 2004\September\[_filename1_.xls]sheet1'!$A$1
A    |     B