I want to lock few cell in a shared workbook and want to expand the area of
lock cells on daily basis.

I want to find out trace dependents, how can I find out trace dependents on
other pages?

i have some files in excell (1 file=1 sheet)
every file have the same number of written rows and the same number of
written columns.
every row in each file (for example the row 3) have the same format of

Is it possible to get a Line Feed when I'm entering a long phrase in a cell,
so that it wraps where I want it to, even if I change the cell width?
Thanks Folks,
Rob Lepper.

I inserted a button on a spreadsheet, and had a hyperlink attached that
moved the cursor back to the first worksheet, cell A1> The button no longer
works for some reason (the mouse depresses it, but nothing happens), and I
can't delete it. When I right click, nothing happens - ...

I have 2 columns of numbers in a sheet called "Fill up Records". I wish
to copy the data in the 2nd to last cell before a blank in one column (
L) and the last number before a blank in the other column (C) and divide
the first by the second and put the answer on a different sheet ...

I'm using Office97.  This problem has not been an issue until recently.
In the past (unless I'm crazy), when I formatted a cell, perhaps in the
format  MM/DD/YY, the value was always displayed in that format even if
you entered new values in the format mm/d/yyyy, or any other ...

Hi I have just started a new business, and am quite new to computers. I.e.
spread sheets and data bases.
Every new customer gives me an order, and then I work out the prices. So I
need to store this information as I go along as it would take to long to

Is there a way to combine 3 workbooks into one?

Hi,  I'm working with multiple rows of data, probably around 3000 rows
and I have the word "total" in between the data in Column A in Excel. I
want to add three blank rows after the word Total. The word Total is
also in bold font, so I tried selecting it with ASAP utilities and add

How or what formula can I use to calculate an IF statement and then
multiply by a set dollar amount in multiples,
I am trying to calculate the amount of grout required for an area of
floor tile based on the number of square feet. Where one bage of grout

How/where do I change the name that appears when I insert a comment? Is it
the name of the person registered to Office?  If so, how do I change it? Can
I make it the name of the user that is logged on to the computer?  I found
my name in the Registry in two places but I didn't ...

Good day experts;
My OS is XP prof service pack 2. I am running Microsft office 2000 premium
on my computer backed with Microsoft office 2000 proofing tools .
In Excel I am trying to add the commands left-to-right and right-to-left to

I know this is an old topic and I have tried many things including Jim
Rech's code which everyone tells me should work, but for some reason
doesn't for me.
My cell range is A42:AA142.  In the following code from Jim, where do I

I want to create an excel document that has multiple sheets.
On one sheet will be a database of clients.
On another sheet will be an invoice.
When the user enters the name of the client on the invoice, Excel