I am trying to share a work book but the feature is grayed out, not sure why - pls explain

Hi! I have a worksheet containing many formulas. This worksheet is locked without any password. Is there a way to see if somebody unlocked the worksheet to...

I need to write a formual for the following: IF J1=R and L1= 3221 OR 3223 then N1 should be FALSE J1 could be either R or C and L1 could be any numer of...

Howdee all. I received some help from T. Valko back in January on a complicated worksheet function. It's been working really great, and today I found that I...

I need to calculate how many seconds are between two times, e.g. 8:08 AM start time and 8:44 AM stop time so I can use the result in a formula. The start and...

How can I create a macro or conditional formula to remove columns containing all zeros

help needed please........ I am not a formula expert so bear with me please. I know filtering is available but I am trying to save effort as data goes into a...

If we select either few worksheets or all worksheet by holding 'shift' key, can these all worksheet be protected/unprotected simultaneously using either same...

I just got a new Dell with Office 2007. Computer is a Vostro 430 with 4GB of RAM and a 2.8GHz processor. Cut, copy and paste operate extremely slow in...

Hi, Which Excel functions are case sensitive and which are not? Can anyone shed some light or point to some resource that explains the case sensitivity of...

Thanks in advance I have a row that that is sometimes blank or contains a number followed by a space and two letters eg. In cell A1 I have the value 456 CR...

Hi, Ctrl+ ; inserts current date and Ctrl+Shift+; inserts current ti me Ctrl+Shift+; inserts the current time with the date serial as 0 and not the current...

Is it possible to convert, say 1234 to one thousand two hundred and thirty four Thanks

I'm trying to use excell to calculate the present value of a security that will pay $5000.00 in 20 years at 7% interest. PV=FVn/(1+I)N

Before printing, I need to remove zero entries from two columns, but they are often different rows. Normal auto filter will not work, it hide positive...

How do I delete a space at the end of an amount or text?

Before I got Office 2007 I was able to lock a spreadsheet using a word combined with numbers, i.e., locksheet123. Now I can't lock it using that formula I...

Hi, (looks like my previous posting was lost . . . . ?) thanks to the help from this forum (Roger G. !), ==for using the same graph, for various...

I have a long list in columns A to I. In some cases, all the items in adjacent rows are identical, and I need to be able to find these as quickly as...

I have followed all the steps in creating a drop down list in Excel 2007: Created Named list on seperate sheet goto the sheet that the drop down will be on...