I have excel 2003 and am using it as a database for a WORD document as the
datasource. I have several fields in the excel database that are blank and
while I have show zeros turned off, they show up as a 0 in the merge field
in the word document.

I have a workbook with 11 password protected worksheets. The worksheets are
linked via various formulae so their names are extremely important for their
functions to work.
Can anyone tell me if it is possible to password protect the names of the

I have spreadsheet with several cells set to word wrap. However, after entering several lines of text, the cell stops expanding to display the entered text. I can manually increase the row height and it all displays. Is there any format I can set to automatically force the row ...

I have to import raw data from a text file that Excel cannot break into
columns, and the import is unsuccessful.  would VBA be a better choice,
having it specifically search for data?  there are 3 specific types of
files and all the files (of the same type) are formatted exactly the

Is it possible to freeze desired Rows and Columns at the same time? I've
tried it, but once either the Row or Column is freezed, the other cannot
be done as when right-clicked it shows unfreeze.

Does anyone know where the code of a worksheet function is?
I mean, for example, where in the file system is the file -and what is
its extension- that contains the definition of the SUM.IF() function?
Are worksheet function grouped in modules? Where are them? Can a user

I have a spreadsheet with several ComboBoxes on it.  Each combo box
links to the one lookup list, which contains text in the first column,
and a numeric in the second.  I've hidden the second column from view
within the combo.

I wonder how can I insert those neat little + and - signs that allows
users of the sheet to quickly hide and unhide set of rows/columns?
Would be nice feature to learn, but I don't even know what it is
called, so it makes it hard to search from help or google =)

The problem I am having is when I open the workbook in question a message
appears and states "The workbook you opened contains automatic links to
information in another workbook. Do you want to update this workbook with
changes made to the other workbook" Yes....... No. If I ...

Just wanted to know if it is possible to have a command (Hyperlink
etc.) return you back to the previous location (sheet)?  
Kind of like the Back button on Web Browsers that returns you back to
the Page you recently left...   Thanks In Adavance for any help here..

I am a newbie to excel/macro development.
I wanted to know how to get the alphabetical reference of a column based on
a cell. For example, the formula =Column(C2) gives me the value of 3. But i
need to get 'C' instead of 3. May I know how to go about getting 'C' using an

Hey folks...
I know this has had to have been done before.  Basically, I have an
original worksheet, and another worksheet that contains values that I
want to populate a column in the original worksheet with, based on a

Dear friends: I have two set of data only 1 & 0. and want to use countif
function
to choose those cells with only 1.
my data is here:

Can anyone advise if and how it is possible to sort more than 3 columns.
The Data-Sort menu option only allows you to sort by 3, but I need to
sort by 5 columns.
Any help greatly appreciated.