I did that and it puts a 1 in box A1. Then I drag it to J10 to highlight the
whole area,
right click and select Paste and I get a message

Data on the Clipboard is not the same size and shape as the selected area.
If I click OK I only have a 1 in A1.

CB
--
C and A Bredt
"Kassie" wrote in message
...
What Luke M is telling you, is to insert the given formula in the top
leftmost cell of your 10 x 10 area, and then to copy it across and down.

Say you insert the formula in cell A1. Now move your mouse cursor to the
right lower corner of A1, so that the cursor changes shape to a small plus
sign. Click, hold the button down, and drag across to Col J1, and then
down
to J10.

--
HTH

Kassie

Replace xxx with hotmail


"C and A Bredt" wrote:

I can't figure out what both of you mean.
I type what you said into the Function box?

Maybe I'm not experienced enough with Excel to do it.

I'm using Office 2007.

--
C and A Bredt
"Sean Timmons" wrote in message
...
Highlight the cells, format Cells Alignment and make it 90 degrees.

"Luke M" wrote:

Top left corner of chart:
=ROW(A1)+10*(COLUMN(A1)-1)
Copy to a 10x10 area.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"C and A Bredt" wrote:

I need a 10x10 chart of numbers 1-100 with the numbers vertical.
I'm sure there is a quickie way to do it.
thanks, CB
--
C and A Bredt