Hi and thanks for reading.
Currently using excel 07 (came with pc)
I have created a database of my music cds in excel
like this in each over 5 columns etc

Would like the enter key to go down one line & home. Is there something I am
missing in options. T"IA

I have a spreadsheet where I have over 35K part numbers in the first
column and revision dates of those parts in the second column.  The
part numbers in the first column will appear multiple times, based on
the number of revisions that were made against it.  I've converted the

I was working on a computer that was running Excel 97 on WinXP. When I
clicked Tools, Options, an error message appeared saying Excel had to close.
That continued to happen every time I tried to access Options. I've the same
computer before with no problems in Excel. What could ...

I have a drop down list in a cell containing 25 names from a range list.  Is
there a way to make the cell autocomplete once a name begins being typed in
the cell?
Regards,

Where does Excel (2003) get the default value for the Company field
under File > Properties > Summary Tab from?  Is it defined somewhere
in the registry?
I need to change it as my company's name has changed.

abqhusker wrote:

using excell, auto sum has dissapeared off tool bar how to get it back any
help grateful

Message: I am experiencing a consistent, recreatable problem with Excel Pivot
Table.  
I believe it is a definite bug, but find no mention of it in Microsoft
Knowledgebase.  

I need a formula to return the column name of the second occurence of
the heading "Q3 2007T".
Thanks

Is it possible to have a cell that's accumulative...in other words, if I
have a cell that has a value of 4 and I want to add 2 to it by typing in the
"2"  and have it now have a value of 6?  I'm trying to avoid having a list
that adds and then link the total cell.  I've never ...

I have a spreadsheet that I need to be to email, but Symantec's anti-virus
software won't let it go through.
I looked in the VB Editor and there was a module but it didn't have any
code, just a header and footer so I deleted it, but it still wont go...

Is there a function or VB script that could help with calculations
based on the items in
a Validation LOV? I'm looking for something similar to the "switch()"
and "case()" functionality found in C that will work in Excel 2003. In

Is it possible to control the VB "calculate" for a single cell?
I have read and used methods for workbooks and the application but I am not
sure if this can be done to control the calculation of a single cell.
If anybody knows, please let me know,

Hi. Whenever Excel 2003 is opened, it shows a task pane on the right
hand of the screen. Is there any method to disable it so that it does
not open each time Excel is opened?