When in Excel 97 and trying to print using the print icon, it doesn'
print. I the click on file and print and there isn't a printer in th
box. I click on the down arrow and the printer is there. I click on i
and it prints. I have only 1 printer installed and it is the defaul

fI'm a new user. I posted my question about Excel 2003 & went ofline. I loged
in again but can't find  a reply.

Dear Excel 2003 Users,
I created a fairly nice pivot table that feeds a chart showing the
amount of hours for all of the different clients that a person has
worked on.  Management liked it but asked a question that left me

I'm trying to link two worksheets using the vlookup function, but I'
receiving several #value errors.  I've tested the link and vlooku
function using other identical worksheets, and everything is OK
--

How do you populate column headings in a listbox?

I am trying to find a way to write and if/then statement. I have a
column(A) with gas stations (MoBil, Citgo, Etc) next to it I have a
column (B) of gas MPG. I want to average each type of gas. So I was
thinking of adding a column (C) for each type of gas. If A#=C(header),

I have a listbox that I want to select the last row in the box and
scroll to that row.
Can I do this?
I used this statement

I have a range that is all colored yellow.  For some reason, one of the
cells changes to white when the user enters a number in it.  Anyone
know why and how to prevent?
Thanks.

Office 2000 - Excel on a XP machine.
The program runs fine but I have no menu bar.
Tool bar exists.
Someone must have change something but

hey can you guys help me with something on excel?  
I have 1 column of data that says doctor or custodian.  Then I have a
2nd column that says male (value=1) or female (value=2).  How do I find
out how many male doctorss there are?  Which function do I use?  

I need to create a pivot table which shows employee names in col A, wit
category headings in row 1. Then I need for the table to show eac
category's data, by employee (i.e. 1 row / employee), instead of eac
category's data being grouped by employee (i.e. xx rows / employee). I

I need to learn advanced Excel modeling skills using the Excel analysis tool
pack.  Can anyone recommend a fast, low-cost way to do this?  My interest is
in applied business statistics and reporting, visualization and analysis.  
Thanks.

I'm building a Pivot Table and for the life of me can't figure out how to
put items in the Data Area in a columnar fashion rather than stacked rows.
I've done it before but can not recreate it. In fact, I have an older Pivot
Table setup in this fashion but can duplicate how I did ...

Dear all Helper,
I have a excel file of about 20,000 records.
I have another worksheet for vlookup to this excel file.
But find that it exists in both worksheet but it prompt #N/A.

Folks,
I'm an Excel beginner. Can you help?
I am simply trying to copy and paste data from one worksheet to anothe
but receive the following error message: