How does one go about disabling that wonderful feature of Windows help re -
sizing the Excel window so that you end up with a half - half (slightly
overlapping) view of the help window and the Excel window ?
Win XP SP2, Excel 2000

I know in windows applications, ctrl-C will copy and ctrl-V will
paste. Are there any key strokes in Excel for "paste special" rather
than right clicking?
Thanks,

Is there a way to add items to the list?

I am splitting a bunch of data into two cells using the
split into columns tool.  The data is structure:
xxx, yyy
I use the comma as the deliminator but all my yyy data

I'm having an issue with not having all the cells that I select having the
cell protection turned on/off when I select the option.
That is....
I will select all the cell in a worksheet and then lock all the cells.

Excel 2000.
When the user saves a spreadsheet that is stored on a network share the
original file is deleted and replaced by an 8 digit random filename.
I know that Excel saves to a temp file first and then renames it, so it

I am using automation (from vb6 project) to open an excel template
(test.xlt).  I want to modify some cell values and then resave the template.
I keep encountering a File Readonly error.  Could someone post some sample
code that would allow me to programmatically modify an excel ...

There is a schema of my excel sheet
1 |   A   |   B   |   C   |   D   |   E   |   F   |   G   |   H   |
-------------------------------------------------------------------
2 |  27   |   70  |   591 |See eq1|  14   |See eq2|See eq3|See eq4|  

I have a spreadsheet with approximately 1500 rows. In cell A1 is an entry,
cells A2 through A6 are blank, there is an entry in A7, cells A8 through A11
are blank and so on. The number of blank cells between entries varies. Is
there a function, or can I create a macro to fill the ...

delete 7 out of 12 pages

I don't know what a property is or how to use it, but I suspect it
might give me the answer to a problem.
What my workbook is used for is the user pastes data on the sheet in
the workbook.  With some macros, a copy of the workbook is made and

The '-' on my external numeric keypad does not register in Excel when it is
the first character typed.  The key works in other programs.  Is there a
setting that I need to change?

How do I do this...
RecLen1 = 5
RecLen2 = 10
RecLen3 = 8

Can someone help me with the following issue?
What I am trying to do is add an amount of hours to a specific date, for example:
Cell A1: 15/03/2005 22:00 (dd/mm/yyyy hh:mm)
Cell A2: 5 (hours)

I have a list of items, say in Column A, with many
duplicates. In cell B1 I want to put validation with a
dropdown list to display the items of column A without
duplicates. Can I do that? I am using Excel 2000. Thanks