looking for Numbers help

[Gravydog316]

can anyone help me use Numbers?
(or do you know an online site)

I just want to add numbers to every cell.

i want to make a bunch of numbered grids like this:

but i want to move the number to the bottom (or top) of the cell, so i have a little room to write,
& i need different numbers to stop at.

in Excel it's easy.

 

[HobeSoundDarryl]

Since it's easy for you in Excel, do it in Excel and then open the final result in Numbers.

 

[Gravydog316]

Since it's easy for you in Excel, do it in Excel and then open the final result in Numbers.

i don't have excel. that's at work on a PC (& i'm on holidays right now)

 

[HobeSoundDarryl]

I interpreted your post to mean that you did have Excel and was offering a quick way to capitalize on "it's easy" in case- perhaps- you didn't know you could do it in Excel and then import it into Numbers.

To make grids like the picture, you can create it in Numbers from scratch. You punch 1 into the upper left cell and then use a formula in the cell to the right of it to add 1. Copy that formula over to the 25th column for 25 numbers. Here's a few entries that shows one of them for entering the formula...

in row 2, first cell (below the 1), you modify that same formula to add from the far right cell in the prior row. So that would be 25 + 1 to get 26 to show. Then just copy down the formulas for all of the cells above that except for the "hard entered" 1 to fill in 27-50.

Now you copy that whole row (26-50) formula and paste into row 3 to fill in all of the numbers. You can repeat this all the way down to that bottom row to 1000.

Formatting the numbers to appear high, low, left or right is done in the format tool to the right of the table...

However, to set it up so you can show numbers and then other information you type in above the numbers, you may want to do that in 2 rows (one for the numbers, and the other for the information you want to put above the numbers)

To make that look like a single cell, you might use cell formatting to redo the grid lines to encompass 2 cells instead of each cell...

​

Here for example, I've entered blank rows between my numbers for content I can type in above the numbers (in it's own Numbers cell)...

​

You can see the row is blank above 49-50 and 52. But at 51, I centered 51 with the text centering tool in Format and then used the Format, Cell tool to delete the standard line above 51 and put a single box around both cells. This results in giving me the number 51 with a space above it in which I've typed Something. You could do the same for the whole grid.

To stop at different numbers, just duplicate your initial creation to 1000 and delete the cells at whatever number is the target end (of count). For example, if you want to stop at 500 in another grid, just don't have the rows below 500 (delete the formulas in the cells). To stop in the middle of a row, delete the rows below the target row and then delete the formulas in the cells to right of the stop number in the target row.

 

[Gravydog316]

I interpreted your post to mean that you did have Excel and was offering a quick way to capitalize on "it's easy" in case- perhaps- you didn't know you could do it in Excel and then import it into Numbers.

To make grids like the picture, you can create it in Numbers from scratch. You punch 1 into the upper left cell and then use a formula in the cell to the right of it to add 1. Copy that formula over to the 25th column for 25 numbers. Here's a few entries that shows one of them for entering the formula...

View attachment 2229105​

in row 2, first cell (below the 1), you modify that same formula to add from the far right cell in the prior row. So that would be 25 + 1 to get 26 to show. Then just copy down the formulas for all of the cells above that except for the "hard entered" 1 to fill in 27-50.

Now you copy that whole row (26-50) formula and paste into row 3 to fill in all of the numbers. You can repeat this all the way down to that bottom row to 1000.

Formatting the numbers to appear high, low, left or right is done in the format tool to the right of the table...

View attachment 2229106​

However, to set it up so you can show numbers and then other information you type in above the numbers, you may want to do that in 2 rows (one for the numbers, and the other for the information you want to put above the numbers)

To make that look like a single cell, you might use cell formatting to redo the grid lines to encompass 2 cells instead of each cell...

View attachment 2229108
​

Here for example, I've entered blank rows between my numbers for content I can type in above the numbers (in it's own Numbers cell)...

View attachment 2229109

​

You can see the row is blank above 49-50 and 52. But at 51, I centered 51 with the text centering tool in Format and then used the Format, Cell tool to delete the standard line above 51 and put a single box around both cells. This results in giving me the number 51 with a space above it in which I've typed Something. You could do the same for the whole grid.

To stop at different numbers, just duplicate your initial creation to 1000 and delete the cells at whatever number is the target end (of count). For example, if you want to stop at 500 in another grid, just don't have the rows below 500 (delete the formulas in the cells). To stop in the middle of a row, delete the rows below the target row and then delete the formulas in the cells to right of the stop number in the target row.

How's that for 'helpless, non-answers'?

ok, i tried that & all it did was put a '1' in every cell. hold on

 

[Gravydog316]

nope get the error "This formula can’t reference its own cell, or depend on another formula that references this cell."

like, i can drag & create sequential numbers, but only in 1 row,
i can't drag down like in Excel

 

[Gravydog316]

ok, i tried that & all it did was put a '1' in every cell. hold on

yeah this just gives me a "1" in every cell?

 

[TheDailyApple]

Here’s how I would do it. (Is this very different than excel?)

 

[Gravydog316]

View attachment 2229118

Here’s how I would do it. (Is this very different than excel?)

yeah i am using the Numbers app, & doing this but it is not working

 

[Gravydog316]

i put in +1 & i get a "1" in cell 2, when it should be a '2' ...?

 

[HobeSoundDarryl]

A1 + 1 to get 2 in B1
B1 + 1 to get 3 in C1
And so on. Over at Y1…
W1 + 1 to get 25 in Y1

Back at A2
Y1 + 1 to get 26 in A2
A2 + 1 to get 27 in B2
B2 + 1 to get 28 in C2
And so on.

When you have 50 in Y2, you can copy all of row 2 down to row 3 and that whole row will fill in properly. Same with row 4, 5, 6 and so on.

 

[gregmac19]

You don't need to use any formulas to incrementally autofill in Numbers. Please see this: https://support.apple.com/guide/numbers/autofill-cells-tan0e1129cf6/mac

 

[Gravydog316]

You don't need to use any formulas to incrementally autofill in Numbers. Please see this: https://support.apple.com/guide/numbers/autofill-cells-tan0e1129cf6/mac

yes, but i can only drag across a row, not rows & columns together. i can in Excel.

 

[HobeSoundDarryl]

The formula way is the way to do all you want. Once it duplicates your 1 to 1000 grid, you can go back in and insert blank rows between each row to create spaces above numbers in which you can type whatever you want. Or you can just make it with blank rows between rows of numbers as you go.

To make it look good, follow the info in post #5 in terms of formatting cells (to draw boxes around 2 cells- one for your typing and the other for the number- and deleting the line above the number and below your input if you want it to look like one somewhat square cell).

If what you want to type in above the numbers is more important than the numbers and/or you want to end up with printable grids, you could do all this in Pages using Word-like tables too. Pages tables use the same basic formulas used in Numbers. The steps and formatting would be quite similar in Pages but Pages can be better/easier at designing "pretty" prints/PDFs... especially if you put Pages in Page Layout mode.

 

[Unregistered 4U]

Learned a thing in this thread.
I could do it by creating 25 columns
Put 1 in the first 2 in the second, select both then auto fill out to the right for 25.
Put 26 and 27 in the second row, select both then auto fill out to the right for 50.
Then, select the first two rows and auto fill down to however far you need to go.

No formulas required. Takes a few extra steps, but you get there.

 

[Slartibart]

which version of Numbers? macOS?

 

[Slartibart]

I interpreted your post to mean that you did have Excel and was offering a quick way to capitalize on "it's easy" in case- perhaps- you didn't know you could do it in Excel and then import it into Numbers.

To make grids like the picture, you can create it in Numbers from scratch. You punch 1 into the upper left cell and then use a formula in the cell to the right of it to add 1. Copy that formula over to the 25th column for 25 numbers. Here's a few entries that shows one of them for entering the formula...

View attachment 2229105​

in row 2, first cell (below the 1), you modify that same formula to add from the far right cell in the prior row. So that would be 25 + 1 to get 26 to show. Then just copy down the formulas for all of the cells above that except for the "hard entered" 1 to fill in 27-50.

Now you copy that whole row (26-50) formula and paste into row 3 to fill in all of the numbers. You can repeat this all the way down to that bottom row to 1000.

Formatting the numbers to appear high, low, left or right is done in the format tool to the right of the table...

View attachment 2229106​

However, to set it up so you can show numbers and then other information you type in above the numbers, you may want to do that in 2 rows (one for the numbers, and the other for the information you want to put above the numbers)

To make that look like a single cell, you might use cell formatting to redo the grid lines to encompass 2 cells instead of each cell...

View attachment 2229108
​

Here for example, I've entered blank rows between my numbers for content I can type in above the numbers (in it's own Numbers cell)...

View attachment 2229109

​

You can see the row is blank above 49-50 and 52. But at 51, I centered 51 with the text centering tool in Format and then used the Format, Cell tool to delete the standard line above 51 and put a single box around both cells. This results in giving me the number 51 with a space above it in which I've typed Something. You could do the same for the whole grid.

To stop at different numbers, just duplicate your initial creation to 1000 and delete the cells at whatever number is the target end (of count). For example, if you want to stop at 500 in another grid, just don't have the rows below 500 (delete the formulas in the cells). To stop in the middle of a row, delete the rows below the target row and then delete the formulas in the cells to right of the stop number in the target row.

what an excellent guide. 👍👏👏👏

 

[NoBoMac]

One thing I noticed with Numbers, and not sure if it's a setting thing (I'm a LibreOffice user), my first calculated cell (B2) was automatically putting in an absolute reference to A2, so yeah, will get 1s across the board in first row when filling across. But that is fixable: make relative.

Can also put into A3 a COUNTA formula to calculate the next number. Makes the grid a little more dynamic in that if want more columns, drag/fill right, then modify A3 to reflect new width (or make the range value to be wider than anticipated), then drag/fill down.

(Corrected image/formula)