in Excel 2003 I protected the formatting a various cells, which should
contain text data only, by selecting the text-format (Via Format -> Cells and
select the text option under the Number tab), deselect the Lock option and
then protect the sheet (only allowing users to select ...

I have a big excel file(300m). When I analyse the data on the sheet, say, for
example, give cell D2 the value of C2, then insert a formula =D2+1 for D3,
then dragging the D column for the same formula. But the strange thing is
that the cells that I thave dragged have the same ...

The boss wants me to create a sign in sheet that has the Day of the Week and
the date at the top.  I do not want to manually do this for a whole year.  
She seems to think I have free time.  Can I get excel to do this for me?  I
am not familiar with macros but willing to learn.

I have created some drop-down lists using Data / Validation / Allow Lists
The lists work fine BUT the viewing size of data in the list is tweeny weeny
and some people in the office will have trouble reading what's in the list!
How can I:

I would like to have aternating rows differnet colours.
eg.
customer no
123 red

I have the following formula in cell E2
=SUMPRODUCT(($B$395:$B$2043=1)*($G$395:$G$2043>0))
I have the same formula (almost) in cells E2 through U2
I want to drag this formula across those 17 cells but I need to change

I teach at a university.  We have the enterprise edition of Office
2007 installed in each of our labs.  Each computer has Office
installed on its own hard disk.  It isn't housed on a separate
server.  The system is set up so that each student logs on the the

I am working in Excel 2007 and have many pie charts.  I have 2 issues
I would like help on.
1.  I want the values of the data to display on the pie chart but this
puts 0 for all the 0 values in the data.  This might be fixed if I can

I have created macro in Excel that will essentially open a new workbook, and
copy certain cells off of certain pages to the new workbook.  At the end, it
gives the user a chance to save it.
The problem is that as it references the different workbooks (the new one

I have a lot of vlookup formulas that looks like this one:
Cell E21=VLOOKUP($A$3,Marks!$F$14:$DG$65,30,FALSE)
Cell E22=VLOOKUP($A$3,Marks!$F$14:$DG$65,36,FALSE)
The difference of 6 is for the next formula.

We have a spreadsheet called "Customer Acknowledgement Ticket" that we email
to technicians in the field and in turn they fill in job information.  The
sheet has nine columns of various widths.  The widths of each column is
carefully sized to fit needed information and remain ...

Office 03 / XP Pro / HP LaserJet 4100
I have a workbook that contains upto 100 rows of data. From a second
workbook, I loop through each row of the first workbook, and if it's not
filtered, take the value of each cell and print out a customer invoice.

when i try and select a single cell on a worksheet by clicking on that cell,
excell highlights four cells at one time and i can't figure out how to get
rid of this. HELP!!!

I am printing to a .xps file. However, each file I save from .xls, prompts
for a file name with the .xps set as the default.
Does anyone know how to set the current workbook name of a .xls file as the
default name for the .xps file?

I want to keep track of how much gas I'm using per gallon in my truck.