If somebody knew, please let me know, is it possible to su
automaticaly numbers from different sheets in an workbook? For exampl
if you have 30 sheets and want to sum the numbers which are i
square(i'm not sure for this word) wtih address H31 but in differen

-Whenever I try to sort data in the format shown Wkdy, Month Day, Year
it reverts to some alphabetical crap by the leftmost item.  I hav
2000+ items I have randomly placed in this column and I just need th
thing sorted or a format that will make it work.  This shouldn't b

I've accidentally put Excel (Office 2003, w/latest updates) into a
sticky selection mode on this one spreadsheet file and I can't turn it
off.  I apparently hit a key combo (I think with a mouse click) and now
when I open this file and single click on any cell, that cell is

Sorry for making a new post, but it seems that the original has moved down
the page due to the date and wouldn't be as visible to new contributors.
Much more new information here.
Was using the Haversine formula to find the distance between two sets of

Hi, I am using Excel 97 and every now and then when I copy a worksheet in
the same workbook to reuse as a new worksheet base, I get an error message:
"A formula or sheet you want to copy or move contains the name 'pat', which
already exists on the destination worksheet.  Do you want ...

 I would like to find a formula in excel that will countdown years, months,
days, hours, minutes and seconds from one point in time to another. Datedif
works for years, months and days, but I can't find a function that
calculates hours, minutes and seconds.  Does such a thing ...

i have a small document that i need to print on an envelope front how will i
do this

I set up a column with 527 rows as a date formatting but the formattin
doesn't work until I click in the actual cell, then click in th
formula bar up top and then hit the checkmark to the left of it.  The
the formatting works, but I don't want to have to do that with ever

Waar kan ik de nederlandstalige nieuwsgroep vinden van excel ?
Where can i find the newgroup for excel in dutch ?

How to make Excel 2003, not IE 6, open Excel files from a web?

I need some help on comma separated text files, changing them and
saving them.
I have got two text files.
The first file "ES_EF_AIG_20141440_105708_d.txt" has employee payment

I want to click on a date in a cell which will bring up a list of name or
items
registered in list.

I have rows of data and coluims and would like to copy from 1 format to
another on a diffrent sheet via a formula to minimise the amount of copying
and pasting  i'am doing . Is this possible?
Current format is Worksheets that are by day of week and within each day of

i have two tables with one column in common. is there a way that i can
join them?
regards,
janm

I am trying to round up a number to what I recall from school days to be
"correct to the nearest half".  In other words, if the cell value is between
3.01 and 3.49 I want to round it to 3.5.  If the cell value is 3.5 to 3.99 I
want it rounded to 4.0