need the formula to obtain the value of Sheet : Sheet1    Cell: A23, the
value is being used to create an end total in `sheet2`
how do I input so that this value is reflected as myNum
is it

There is an option under File, Open called preview.  Yet I can not view any
excel files.  It always shows "Preview not available"  Is there a setting
that I need to change to be able to do this?

Today I am learning F9.  From Help:-  
"F9 followed by ENTER (or followed by CTRL+SHIFT+ENTER for array formulas) calculates the selected portion of a formula and replaces the selected portion with the calculated value."
This is great.  If formula auditing fails me, I can use F9.  ...

I would like to insert clip art into a into  cells that is already the size I
want them to be.  How can I get it to fit? I am having to manually resize
every time.

How can I insert clip art in a column withou having to resize it each time.  
I have clip art in my clip art organizer.  (I think that's what it's called.)

Hi everybody , maybe somebody can help me
I need compare two collumn in excel  / numbers /
f.e:
A                  B

Bob,
Welcome to my new thread.
Bob's formula for the last work day of the current month (brought over from another thread WEEKDAY is
this:-

Loading Data into Multiple sheets in 1 book
Hi All
I have 2 questions
1.    I am trying to automatically create a workbook with a number of

Regarding WEEKDAY(), I read that problems can occur if dates are entered as text.
Based on this, it is understandable that =WEEKDAY(2/14/2008) returns a wrong result (7).  This is because general format is same as text.
If I enter =WEEKDAY(DATE(2008,2,14)), I get the correct result ...

I have created a daily report to track revenue and marketing
information.  This report includes columns titlted
Today        Month to Date        Year to Date
Is there a formula that will automatically add the "Today" column to

Hi :)
If I change the colour of one of, say, the bars in a chart, by double
clicking on it, the colour of the legend doesn't change. But if I change
the legend colour, the chart does.

I have created a excel sheet which has data in columns, which are column D
called Products and column F called Quantity. this data is made up from a
list using VLOOKUP for bothe columns.
each cell in column D (Products) from d5 to d39 has the following data

I have my spreadsheet set up to move one cell to the right when I hit
'Enter'. What I would like to do is as follows: On entering column F,
I want the cursor to move to column A of the next row. Thanks. :)

I've asked this question 3 times now in the past year and every time I get a
response from an "expert" who gives me a canned answer without really reading
my question.  Here goes again.
I have Office 2000.  I use Outlook not Outlook Express.  I have the default

I'm trying to restrict the entry of data into cells based on values in a
list.
What I need is similar to Data Validation but I want Excel to complete
the entry after the user has entered just the first character.