Is there a property that can be set to tell Excel to open a specific sheet.  I am looking for an
Excel property that would be used to open a sheet without the use of a macro.  I believe I saw one
discussed here, but can't remember what is is?/
Thanks,

How can I view files I created in Works for Windows 95 in Excel 2003?
I remember that I found an add on for Excel XP but don't remember where I
found it. <g>
Thanks in advance. BoB.

I do excel sheet for gallery with listing of artwork and
prices. Is there a way to pull off the data for title,
artist, medium, and price to create cards to print out
for posting on wall by the paintings? I have MS Office

I am trying to filter a list from 1 column to another minus the blanks. Is
there an easy way of doing this?
Thanks in advance

I'm trying to concatenate two columns with a function, with the results
in a third column.  I'm entering everything correctly, but I'm not
getting an answer...instead I'm getting the phrase
"=CONCATENATE(G13,H13)" in the cell, which is the equation I'm using in

how do I build and maintain a drop down.
I have information on 1sheet and need a drop down on
another sheet to show that information and my employees to
easily be able to pick things off from that list to finish

I have a case where a single cell has a bunch of text in it.  Some of the
text is in red.  Some is in blue.  When, I select and copy portions of text
from the cell and paste into the middle of another cell, I lose the color
and other text formatting.

I keep getting an error and recovery option, when I try to open a specific
workbook. When I recover it, most has been lost?
Is there a problem with 2003 working with 2002?  The worksheets have formula
and links - all in the same workbook.

I'm not sure how to ask the appropriate question to solve my problem.
One of my employees enter catalog numbers and quantities in an Excel
work sheet. It's a very big list and we needed the format to be one each
of the catalog number per line. What this person did was count the

Need your help, If I'm entering data in several columns, let say from a to
f, what I want is, when I hit enter on column 'F' I want to go back
automatically to cell 'A'
Thanks

I have imported price lists (via OmniPage)into Excel. We
would like to add a set dollar amount (our profit) to
each of the cells. (ie. Add $500 to each cell). Can we do
this globally?

I have a formula that gives me the number of weeks in a period.  How ca
I get the fractions of a week to round up instead of down.  
For example, if the formula returns 15.1 weeks, I want the value to b
16 weeks

I have a dropdown list (in cell D12) that displays either "Dollars"
"Pounds", "Euros". In cell A5, I need the cell to display eithe
"D","P" or "E" deping on what the user picks from the dropdown list.
Apparently my formula:

I have a list of names in excel with including names and both names an
surnames in some columns,
can you help me to extract only surnames into the different cell?
A1=Adams

what if there is more than one dot
such as
a.j.michael
a.john