Can I have the program automatically fill 10 columns of 10 rows with numbers
from 1 to 100?  I am using Excel 97 on an XP Home machine.  Thanks in
advance.

i want to create a column (A1) where i can choose from a list of clients
How do I create this list and keep it hidden?

I wish to format a column of numbers so that only the last four digits of
each number are there.  This is not stripping the leading zeros; it's
stripping whatever numbers are before the last four.  How do I do this?
Thanks

I am trying to copy a cell on Sheet 2 onto Sheet 1 and all I get is the
formula not the text.  Help please?

Can someone help me create a macro? I would like to create a macro that
will search Row 1 for "Duration" and once it finds out which column
it's in, I want it to select the whole column.
I want to use the macro to format the duration column and use the macro

We are doing a vlookup for a date cell in both workbook which is in column D
this is the formula
=VLOOKUP(B10,'C:\Documents and Settings\Administrator\My
Documents\[calling_.XLS]Customers'!$A$4:$I$58,4,FALSE)

I'm using an IF function to call some other cells, but I want to have
the various words color coded, eg ("Certified" is green, "Recertify" is
yellow, and "Not Certified" is red).  I have the IF function working
correctly, but when it "calls" the cell to have it display the

I forgot how to make something and hope somebody form here can help me.
For example I have 5000 rows of some random numbers in column A. In column B
I want to insert a formula (any formula). How can I "insert" that formula
for all 5000 rows with data at once. I know there is a ...

People, i need help with some spreadsheets regarding construction
industry supply of materials, verifications etc, if any one has a
spread sheet available, any help will be appreciated.
Thank you,

I've recently obtained Office 2003 for my work laptop, and to say the least
it is getting on my nerves! When I want to access Help, I want a nice little
index of terms that I can search against that is intuitive, user-friendly and
allows me to have a browse around the subject.

I am working with a database i set up in excel.
It has over 25,000 names, total size of file is 274mb.
If i transfer all my data from an excel database to access, will i
work faster.

Can someone help me out.  I'm trying to hide some rows and some of
these rows have buttons on the cells.
When I hide the rows that buttons just all bunch up and stay visible.
Is it possible to associate the button with a cell and hide the button

Columns A, J, K and L are visible.
Columns B to I are hidden.
When I select a few rows using the shift key, click "visible cells only,"
click copy icon and paste icon, I only got column A pasted.  I am surprised

Is there a way to find a set of values that exists in one range but not in
another?

I have 103 years of daily rainfall data. I need to know whic
probability distribution it follows. Is it possible to find th
distribution pattern followed by rainfall using MS excel
--