Hi,

Let's suppose that the data are in columns A thru T, and that they start at
Row 2.
In cells U2 and V2 enter the following formulas.

=MIN(A2:T2)
=MAX(A2:T2)

Select both U2 and V2, move the cursor to the bottom-right corner of the
selected area, i.e., U2 and V2 (you will notice that the cursor changes into
a "+" shape), hold the left mouse-button, and drag down the rows
(alternatively, you can doble-click the left mouse-button when the cursor
changes into a 'plus' sign to achieve the autofill).

Regards,
B. R. Ramachandran


"bkj8890" wrote:

I have a worksheet where I pick about 20 colums that will give me my Min and
Max of that row. I then move down to another row and need the same thing just
in the row I pick. I copy and paste each time and then change the colum
nuber. Is there a way to change the colum nubers in a faster way. What I mean
is instead of deleteing the number then puting in the new number for every
colum, something like A2,b2,c2,d2,e2,= a4,b4,c4,d4,e4. a quick change of all
the numbers at once?

Thanks