How can I protect a worksheet so that any user can do anything desired, except change the formatting. Using Excel 2002. Thanks for any suggestions Paul

I am very new to Excel and having to learn everything from a blank slate. My friend gave me the following formula to calculate days of stay and it works well...

can anyone tell me pls if it is possible to sort my worksheets alphabetically? I have about 30 or so which I would like to sort after renaming them.

The A-Z, Z-A buttons are a very useful feature, that I use to sort columns within blocks of data without having to go through the data sort menu. I have a...

the box a2 contains the formula =a1-32. how can i get rid of -32 that is shown in all the boxes the formula applies to a2 down to k2 thanx

Is there anyway to convert a file with columns back to comma delimited? --- Message posted from http://www.ExcelForum.com/

Perhaps you might want to check out Debra's nice coverage on the subject at...

I would like to teach excel by example ? would you pls let me find best examples in excel for newuser and expert best

When i run importing data from external source i still got the message that maximum rows 65536 excided? is there some parameter to set?

That will work for now. Thanks alot! -- Flintstone ------------------------------------------------------------------------ Flintstone's Profile:...

Is there a place where I can find a list of all Excel's functions and what they do. Besides the, ISERT FUNCTION, HELP...

Hello: Is there some important differences in the Visual Basic of Excel 2003 and Excel 2007? If I practice VBA in Excel 2003, could I have problems to do the...

Hi .. All.. i am a S/W Test Engineer. Actually I have a new job on macros(my boss gave me). I don't know all the functions of macros. I just know that these...

It is important to me to get all about macros for Excel. I want to look up some reliable PDF reference or another type de file or link to learn from the...

I have a problem in the spreadsheet with few many data with conditional formats.Each cell has different conditional format.When a cell is copied from one to...

I would like now more about senario in excel, best

I'm having trouble with this function =IF(ABS(G30-F30)=0.2,"PASS","FAIL") If the numbers in G30 and F30 are bigger than 31 it returs false when equal to...

I have a workbook that is set up that when I enter a specific value ex:e18 in one cell it will give me the coresponding number ie:800-252-6030 in a different...

I guess I don't understand absolute and relative cell references. I have a cell containing the following formula: =AVERAGE(C$13:C23) From what I read about...

I have calculated salary for one employee using =$A$2* 45 %. Now I want to drag this for all employees, but Fill Handle does not work Please help me