General

Banded rows all scattered after conditional formatting
I recently did a project that used a table style with banded rows, but when I did a conditional formatting some rows were banded and then some were not. I was just wondering why is this and how I can correct it? ... 23 Mar 2010 10:09

How to sort multiple sheets (which have same format) at one time?
I have a workbook with multiple sheets which have the same format. I need to sort all in the same manner. How can this be done. I noticed that the sort function is not available when selecting/grouping multiple sheets. ... 23 Mar 2010 16:00

filtering rows across several columns
Hi, I assume A, B & C are column headings and not the actual columns A,B & C. Put this in a helper column and drag down =COUNTIF(C2:E2,3)>0 It will return TRUE if there is a 3 in any of the columns. Filter for TRUE on this column -- Mike When competing hypotheses are otherwise equal, adopt the hypot... 23 Mar 2010 10:09

Count decimals
Hi, This works: =LEN(A1)-FIND(".";A1) "מיכאל (מיקי) אבידן" kirjoitti: One way will be: =LEN(A1)-FIND(".",A1) Micky "backmara" wrote: How to count decimals in excel cell? 1.235 --> 3 ... 23 Mar 2010 09:00

Read only prompt?
How do I make my workbook read only to another user whilst I am making changes. Why is the other user not getting a read only prompt, they are also making changes causing save problems. I have not ticked the allow changes by more than one user box in the tools menu. ... 23 Mar 2010 13:40

How To Calculate the Number of Fridays between two dates.
Can any body tell me how to calculate the number of Fridays between two dates ( say 1 Jan 10 to 15 June 10)? Is there is a way to do this in excel ? Thanks in advance.. Best Regards, ... 24 Mar 2010 00:02

how do you calculate mortgage interest in 2007 Excel ?
... 23 Mar 2010 12:30

Formula to count no. of months between 2 dates
What is the formula to display the number of months between 2 dates? Thanks, Melissa ... 23 Mar 2010 05:39

Cells showing #####
Is there a way to have excel let me know if any cells are displaying the ##### symbol. I have double clicked on the columns to auto adjust the width but there are still some cells that will show the ####. My real reason for this is I don't want a 10+ page table to print and some cells print ##### as the value... 23 Mar 2010 09:00

Paste Disabled- how to enable it?
Dear all, I am using MS excel 2007. After opening an excel file, my excel can't "paste" or paste special when i right click the mouse. Both function are disable. I have tried all excel option and stil can't sovled the problem. Please give me some helps... Thank you!!! ... 23 Mar 2010 09:00