Is there a property for the Range object that does the opposite of
ShrinkToFit? I mean, something like CellExpandsToFit, i.e. the cell size /
row width / column width is adjusted automatically so that the whole text in
it will be visible.

Hi experts,
I have two workbooks. "All_data.xls" have 11 columns (A:K) where on column
B, I have names and on column H dates. This workbook keeps growing as we add
up new occasions.

I want to show the contents i the active cell in another cell, fo
example cell A1.
Also when i change active cell.
dalla

I am a newbie viz Excel but was sent "50 small XLS" files from a
multi-level spreadsheet.
Is there a feature within Excel that will allow me to JOIN those '50'
together.  I want to then move the XLS to a DBF format.

Does anyone know if it is possible to type "MA-00-25-987" in cell A
and let excel automaticall generate a hyperlink to "C:/m
documents/MA-00-25-987.pdf"
I thought it might be possible using a macro or something, but i'm no

Here is what I am attempting to do:
If I have a column of numbers (rows 1 through 50)
rows 3,7,12 are colored yellow.
I want to add up the numbers in only columns 3, 7, and 12 (the cells that

I've just started using Excel 2003 after a long, happy use of 97.
Whenever I insert a row into a sheet, I get a little paintbrush Icon
which apparently will format the row according to the format of the row
above or below it.

I figure there's a direct way of doing a table look up in Excel, seeing Excel is
based upon tables.
But I am not finding it.
I have a table with ranges for each column and each row.   Here's part of it:

This likely is a very basic question, however....
I can organize this within one sheet, or by multiple sheets
workbooks, whatever, but all attemps at 3-d categorical consolidation
joining, or relating have failed.  Any recommendation on best solutio

can someone give me the logic for a macro to automatically run when a
workbook is open.  I just want the workbook to do a calculation every
second.

I have created a small vba based program for excel, I would like to als
be able to distribute it but I would like to limit the use of it via a
expiry date or a authorisation code, can anyone help me?
thanks

How do you create a formula or count information in a range of cells an
exclude any repeat information? For example, I have vulnerabilitie
listed in Column A and IP addresses listed in Column B. I want to b
able to count how many machines are in the spreadsheet or how man

I have a column with number and string. if it is number, i need to do
something, while string, i need to do other.
is it possible to check the data type of one cell??
million thanks

Is there a way to make a cell or a range unselectable
while keeping it visible in the worksheet. Thanks for
your help.

Hello all! :-)
I'm trying to make a very simple inventory system so that i can track
stationary as it is delivered, then distributed to the various departments at
my company. Exciting huh?