How to set the amount of values visible when open a combo box?
and
How to have a default value highlighted when opened as always the top
of the list is visible.

Readers,
Can OptionButtons be set to 0, using something like For each   -   Next  ??
Up till now I know no better way then
Me.OptionButton1 = 0

Here is what I am trying to do:
If the sum of 4 cells
E22 to E25
Equals D22

It's for a football pool and I told the guy I;d research and play around to
see if it's possible.
The spreadsheet looks like this:
NAME  16            15  

In Excel how can I keep row height when pasting?

I have 3 columns:  date    numbers  numbers
The date column has the format:
Thu Sep  1 17:00:00 2005
I tried selecting the column, format cells, category: date, and select

When I fill a rows or columns with color, the gridlines running through them
disappear.  Is there a way to make the fill "transparent" in order to see
the gridlines?  (I'm using Excel 2003).   Thanks

I have data in the excel sheet with .A column for OrderNo and B Column for
items
for that Order.
 A              B

my employer emailed me an expense report and i downloaded excel. i can't seem
to write on this document. is it because its a read only fiel? how do i
convert it to be able to edit and write in my expenxes? HELP!!!!!!

I have a list of a couple of thousand postcodes in a column in a
spreadsheet. Each postcode occupies its own cell. Examples of each postcode
might be AB10 or AB11 or AB12 etc. I want to cut and paste these postcodes
to another sheet, many codes to be pasted into single cells.

Is there a way to make an exact copy of a worksheet (which includes row
spacing/background colors, forumlas), and put them into another excel
file as a new worksheet.
ie.

File, Page set-up enables one to detail the columns that can be repeated as
row headings on subsequent pages.  If one is using a few columns that need to
be repeated but has notes further down the page that are to be printed on the
first page but not on following pages how is ...

Hello all..
I am currently using an invoice template in excel and inputting the info
directly onto the invoice in excel. How would one create a user interface
that would ask for the desired information and once completed would print the

Suppose I have a table which record the income for each people in each
area
area income
1      100

I have been asked to post a picture that is 72-96 dpi and no more than 6
inches on any one side.  I have no idea how to do this.