If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Numbers Chart
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 |
#2
|
|||
|
|||
Numbers Chart
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 |
#3
|
|||
|
|||
Numbers Chart
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 |
#4
|
|||
|
|||
Numbers Chart
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 |
#5
|
|||
|
|||
Numbers Chart
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 |
#6
|
|||
|
|||
Numbers Chart
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 |
#7
|
|||
|
|||
Numbers Chart
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. -- Rick (MVP - Excel) "C and A Bredt" wrote in message ... 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 |
#8
|
|||
|
|||
Numbers Chart
Perfect!! Thanks to all. CB
-- C and A Bredt "Rick Rothstein" wrote in message ... 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. -- Rick (MVP - Excel) "C and A Bredt" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|