I've a user working on a set of Excel spreadsheets. She's using Excel 97.
When she opens one of these spreadsheets and goes to Page Setup - Margins,
the dimensions that are being displayed appear to be in Centimeters. If the
same file is opened on another computer with Excel 97, the ...

Previously posted in microsoft.public.excel.worksheetfunctions but I
didn't get any response, so I'm trying another group in case I posted
to the wrong one.  On the other hand, if I've not been clear then
please ask for clarification as I'm very keen to find the answer to

I have a sheet (sheet1)containing 20 columns and 1000 rows.
The data sheet1 is used for different reporting purpose. for different
reporting I have to hide and unhide some columns & rows and have
to change the Heading of report. Is it somehow possible to customized

I'd like to be able to get data from a number of spreadsheets that are all
copies of a master but have different data in the same cell locations.  ie
Cell a1 in all spreadsheets have different data, altho the spreadsheets are
all formatted and laid out the same.

Is it possible to sort the sheets tabs according to
their names.??
Thanx...
Syed

I use a spread sheet to do work schedual
12 work sheet 1 for each month
columes are total days for the whole month( i use 4 extra columes between
weeks for extra info.)

We have a file that has bounced around over multiple years, under multiple
versions of Excel, that contains links to various Source Files.  Whenever
the file is opened, it asks if we would like to update the information in
the linked documents.  Click NO makes the file usable, so ...

I am new here and have a problem hope I can get help in here!
I have two worksheet "W1" and "W2"
In W1 worksheet, it has a column "emp_pin" which is unique. This value is
used in the

Can I ask a stupid question?
How do you freeze both the Horizontal and Vertical Panes in the sam
worksheet?
Cheers

In an Excel spreadsheet involving many iterations, I'm trying to get rid of
circular formulas. It would be useful if I could write a formula this way:
as long as the result of the formula is not a number, the cell should keep
being a formula, but once the result of the formula is a ...

I have a table that will be 52 rows down, each row representing a week.  I
am tracking 3 sets of data on a weekly basis.  One of the three columns is
the projected budget so it is complete through 52 weeks.  Each week I enter
in the weekly sales and units.  I graph these three ...

How can I track swim event times - mm:ss.ms format?  I need to go two digits
deep in the MS format.   This is to be used to track swimmer's times and
chart progress.
Thank you all for your time and help.

I know this must be somewhere but I can't find it.
I have the following formula:
="M.J.F.("&DOLLAR(Variables!C26,2) &") x "&Variables!C8
Which is all ok, but I need the last variable to be a percent so the cell

I could really use some help here.  I need to delete data without deleting
formulas.  I don't want to have to do it on a cell by cell basis.  I would
like to be able to select the entire sheet and then click a button like
"clear contents" but leave all formulas and formats.

we are importing a pivot table from column c & d How an we configure colun c minus column d