Numbers Chart

[C and A Bredt]

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

 

[Luke M]

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

 

[Sean Timmons]

Highlight the cells, format > Cells > Alignment and make it 90 degrees.

 

[C and A Bredt]

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.

 

[Kassie]

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]

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

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

 

[Rick Rothstein]

That is *not* what Kassie explained you should do. Let's try again. Put this
formula in A1...

=ROW(A1)+10*(COLUMN(A1)-1)

Re-select A1 if the selection has moved away from that cell. Now move the
cursor over the small, black square in the lower right corner of the cell,
click drag it across to Column J. Now cells A1 to J1 will be selected. In
the lower right corner of that selection is the small black square. Click
drag it down to Row 10. If you followed those steps, you should now have a
10x10 square of numbers that run from 1 to 100 with the numbers increasing
vertically.

 

[C and A Bredt]

Perfect!! Thanks to all. CB
--
C and A Bredt

That is *not* what Kassie explained you should do. Let's try again. Put
this formula in A1...

=ROW(A1)+10*(COLUMN(A1)-1)

Re-select A1 if the selection has moved away from that cell. Now move the
cursor over the small, black square in the lower right corner of the cell,
click drag it across to Column J. Now cells A1 to J1 will be selected. In
the lower right corner of that selection is the small black square. Click
drag it down to Row 10. If you followed those steps, you should now have a
10x10 square of numbers that run from 1 to 100 with the numbers increasing
vertically.