I have used large Excel workbooks with lots of internal links between cells.  
I have had to Paste Special into a new workbook when copying a sheet to avoid
creating a link between workbooks.  I have not  understood what caused this;
only how to avoid.

Hi, i need to be able to copy down a formula that changes the sheet number
but not the cell reference. How can I do this?
E.g.
=Sheet2!A2

for speeding up data entry I want to enter the figures without a decimal
point, and have excel make the last two digits decimals. e.g. key in 3925
which will desplay as 39.25. I've done this before but forget how! Its a
custom number format I think

I have spent a good 8 hours on this over the last week and CANNOT figure this
out.  I have exported all our contacts out of Outlook to excel and the
addresses and some other fields are being exported with the carriage return,
but you cannot see the symbol.  If I export to tab ...

I am using excel 2003.
I am trying to multiply 2 sets of data together for a project. However, I
need to find all the corresponding values of one set for a single given value
in another set.

In formatting cells, general automatically enters decimal places.  I want to
uncheck 'fixed decimal places' but cannot find that in Excel Options.  I am
using Excel 2007 and there is no Tools>Options>Edit.  How can I cancel 'fixed
decimal places in Excel 2007? I don't want to ...

I’m trying to compare a date off the Islamic calendar to see if that day it’s
greater then 15.
the cells in column "A" are the Julian/Gregorian date;
in "B" are the dates whit the format "[$-1060000]B2d;@" ,  to return only

When I copy info from a spreadsheet into another (blank) spreadsheet, why
doesn't it copy the same format as it was in the old spreadsheet? I do "paste
special" but it never comes out quite the same.
No doubt I'm doing something wrong :) I just don't know what it might be!!

I have the following formula:
=SUM(E45,H45,K45,N45,Q45,T45,W45,Z45,AC45,AF45)
I can't make it a Sum(E45:AF45) because other values are present.  
I've used something like Sum(if(isnumber(E45:H45),E45:H45)), but it doesn't

I have a file where I am using the Subtotals function and I would like to
bold just the totals line.  I do not want to make all the numbers bold, just
the totals line.
Can somebody help me with this?

Any one know how to convert data into range?
Like
A       18
B       25

I'm not sure if this is possible.  I've searched the books & online and can't
find my answer so here I am...
Here's the worksheet I have
Column A        Column B       Column C

I'm trying to create a formula for the following senario...
I have a table of people (by row) who are progressing through the first part
of some training (worksheet 1) and I have a second table (worksheet 2) with
further training for those people who pass the first part.

Okay.  I am creating hyperlinks to photographs in an excel spreadsheet.  What
I need to know is this:  How can I make it so that the integrity of the links
hold up even when the file is taken from my computer and used on a different
machine (ie: handheld).  I'm assuming that when ...

Hi, I am trying to count the number of 'YES' in a column and the number of
'No' in another column. I cannot work out the function to do this!  I would
like to add a function at the bottom of the page somewhere which will
automatically count as responses are entered - can anyone ...