MS Excel 2003
Is it possible to protect a worksheet to accomplish the following;
Protect Column A so users can not edit
Protect Columns B:D so users can enter data but not change the format

Is there a way to save and close a spreadsheet when there has been no
activity for a particular amount of time? We have a problem with several
users needing access to the same workbook.
Thanks

I have a group of spread sheets that I use as templates.  They are saved
under different file names in the same folder.  This group of files is then
used on subsequent job orders.  I would like to re name the files to the
individual job order numbers so they are more descriptive. ...

Dear Sir,
I understand that there is a format convertion update that enanle Excel 2002
to open Excel 2007 XML file format.
If open an Excel 2007 worksheet that has  250,000 rows and 75 columns more

I have read many posts on how to Count cells with fill color and how
to sum based on fill color but how do you do an average?  Here is the
code I have now.
Function AVGColor(rColor As Range, Range As Range)

I still need an answer to Average cells that have the same fill
color.  But only use the cells that have numbers in them.  Some may
contain words.  They are mostly blank.  Here is my code so far.
Thanks,

how do I show negative numbers in parenthesis in Excel?

Hi all,
I am using excel to calculate numbers with percentage increases. I am using
simple calculation formulas that reads the number on the 1st box and then
based on the % that I want to increase the number, gives me the increased

I have one huge text file which I need to convert to excel. I know about the
"Text to column" in excel but ti not giving me right output. Can you please
advise is there any VB script or macro that you can prepare.
Appreciate your kind assistance.

I've been trying to set up conditional formatting on an excel spreadsheet we
use as a date tracker.  Basically there are target dates and actual dates in
this chart and I would like the actual dates we enter to change colour if
they are out of the acceptable window from the ...

Dear Sir,
If I have a workbook that is link to 5 other files in the same folder by
formulas.  
May I know if it is possibble for me to open the other related files

哪個版本的excel,其設定格式化條件數目可以不限3個

I can't figure out how to duplicate a worksheet minus the data (so I can
insert new data using all the same formulas).  In other words, I want to copy
the formulas, formatting, column&row titles, but NOT the data.

G44                     I44                  J44               K44      
                  L44
Revenue Total    Revenue Quota       At Risk $       % of Quota          
Commissions

I need to import txt and cvs files and then be able to use them as numbers in
a data base and spreadsheet formula.  Can you tell me how to do this?  Thanks