A workbook has a large number of worksheets asking identical questions but
for different products.  I use the "comments" funtion to give guidance to the
users.  If I need to change a "comment" I would like it to automatically
change on all the worksheets.  The text of the ...

Can I set the print instructions in an excel file to have the printer 3 hole
punch the job?

I'm trying to print a spreadsheet thats two pages wide by 20 long.  I'm
trying to get it so that I can bind the pages in a note book so that when my
nearly blind boss opens it up he can read it from left to right.  I need to
make the thing print page one of the spreadsheet on the ...

I was screwing around at work today and stumbled upon an interesting
way to manipulate v/hlookup-returned values.
For example, an average of two columns - array entered:
{=AVERAGE(VLOOKUP($A12,'[xxx file.xls]Sheet1'!$B$4:$F$10,{4,5},FALSE))}

Using    =COUNTIF(Sheet1!$E$6:$E$119,A25) in B25 on sheet2 When I copy down
to B35 and if any cells in A25 to A35 is blank it gives a result of 98, When
it  should be blank.Sheet1 E6:E119 is text and A25:A35 on Sheet2 is also text.
Please correct my formula for me.

I want to put a border around a column, but each time I do I get
borders round each individual cell.  I can do this on a fresh
spreadsheet, but the spreadsheet I am working on has data that has been
imported from a database - it's nearly driving me mad!!

I have 2 lists that need to be compared.  They have the same info, but
slightly different.  For instance, one of them has "Mr. Bob Smith" in one
cell.  The other list just has "Bob Smith". I need to compare the 2 columns
and delete or mark the duplicates.  So basically I need to ...

I need to validate an entry to ensure that it is a whole number which falls
within a certain series but with some entries excluded.  For example, it must
be a whole number which falls between 1000 and 1099, but where 1050 is
excluded.  

hi community
can community please assist me on how to display back my worksheet menubar.  
It was working fine before but now when I opened up Excel, the Menubar
disappeared......what is happening to my Excel ?

Hello ,I am trying tomake a inventory sheet.Col "A"is my starting total ,Col
"B" is my receiving total, Col "C" is my shipped total and "D "is my Total.
A     B     C     D
5     5     5      5

Sorry, about this, but my head is sore from pounding on the desk....
Have a handful of check marks that I put on via the Forms Check Box and
want to have a sub that will check/uncheck all of them. However, i
can't even get the basics on this. What am i missing? I keep getting

I have a form where I'd like users to enter their latitude and longitude in
the form: +/-DDMMSS (I'm trying to be user friendly).  I also need to
validate that they have entered the data in the correct format (i..e, where
for longitude degrees can vary from +180 to -180, but that ...

On the formula how do have it calculate based on 365 days ??

Hi - any help appreciated.
I've got a column with the font formatted as arial narrow size 9.  
If I place an email address in this column, the font changes to Arial once I
hit return.

Ho un'elenco dal quale vorrei selezionare tutte assieme le celle contenenti
il carattere  rosso; ho a disposizione excel 2003