Is there anyone here who knows whether the interpolation function in the
chart options in Excel 2003 was omitted in Excel 2007, or was moved to
somewhere hard to find? If moved, where to?
Thanks.

I would like my chart to show rows where "COLUMN C" = "TEAM1".  Then I
can change "TEAM1" to "TEAM2" and only chart rows where "COLUMN C" =
"TEAM2".
Does anyone know how to do this?

I am responding and reposting, in case someone thinks the issue is resolved
because there was a response.  I hope that's OK, I was just desperate for a
solution.  Reading should begin from the bottom, I don't know how to make my
newsreader not "top post.":

E                            F
1    Do you own a guitar       validation cell (yes/no)
2       If yes is it a Gibson
3       Is it a 5 string

When I export data to excel it doesnt recognise the numbers as numbers.  Even
when I format the row to numbers it doesn't recognise them.  I have to retype
then in order for me to do calculations.  Any help greatly appreciated.

Hi. I've pasted data into my worksheet that leaves every other row empty. I
need to delete the empty rows but sorting messes up the order,
GoTo/Special/Blank won't work and neither will several DeleteEmptyRow macros
I've tried.

I'm a total newby with trying to use Excel (or any spreadsheet for that
matter) and I need a simpy rounding process but can only find things for
rounding to 15 minute intervals or else always rounding up or down.  Is
there a formula to simply round :02 down to :00 and :03 up to  ...

I am having difficulty finding information on the Excel 2007 encryption
setting.
Issue#1:  When I am saving a file in the legacy .xls format, where do I find
the advanced option that lets me choose the encryption type?  I always want

I don't work in Excel much, but I was always under the assumption that
AutoComplete only worked if there were no gaps in the data in a given
column.  However, I had a user come to me today and prove me wrong.  :-)
After some testing, here's what we discovered.

I want an InputBox and MsgBox to display several lines on text and want to be
able to hit carriage-return so that the text reads like a paragraph.
I have the following :-
Title = "Please Enter Password to LOCK ALL the sheets"

Strange problem here.
Double clicking on an excel file from a cold start takes a very long
time to open and be ready for working in excel 2007.
A work around I have found is to open the application first, then

I have the Analysis toolpak loaded, but still the function =convert()
remains in lowercase and gives #value. I checked the number with ISNUMBER()
and indeed i got a numerical value. ATP is loaded otherwise it would not
have recognised the function as such. What could be wrong?

I can't get the tab scrolling or worksheet buttons to appear on my view when
using excel 2007.  Help?

Please bear with me. This is probably a painfully fundamental question.
I need to specify a range of 48 cells in a sum formula. For example,
=SUM(A10:A57). Is there another way to achieve the same results by
subtraction? Something like, =SUM(The cell I want to end with - the ...

Could someone help me with the following:
I have a range of dates which I want to convert from mm/dd/yyyy into
dd/mm/yyyy, my formula
(=MID(T1474,LEN(T1474)-6,2)&"/"&LEFT(T1474,2)&"/"&RIGHT(T1474,4))