Need formula to add specific #'s across the top

[kdogtrainer]

I want to be able number columns across the top of my excel sheet. EX.
(0, 0) (1, 0) (2, 0)
How do I get it to keep adding 1 number to the front # and keep the second #
as a zero?
When I do it down a column it works fine but when I try to do it across it
just keeps repeating itself so that I get:
(0, 0) (1, 0) (2, 0) (0, 0) (1, 0) (2, 0) instead of
(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
Any help would be greatly appreciated.

 

[Gord Dibben]

Enter in A1

="(" & COLUMN()-1 & ", 0)" returns (0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0) as
it is copied across row 1


Gord Dibben MS Excel MVP

 

[kdogtrainer]

Your formula did the trick for putting the numbers across the way I needed
them but now when I try to add down it no longer works the way it did. This
is the result I am trying to get on the whole spreadsheet

(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
(0, 1) (1, 1) (2, 1) (3, 1) (4, 1) (5, 1)
(0, 2) (1, 2) (2, 2) (3, 2) (4, 2) (5, 2)

Thank you very much for your help

 

[Gord Dibben]

="(" & COLUMN()-1 &", "& ROW()-1 & ")"


Gord

Your formula did the trick for putting the numbers across the way I needed
them but now when I try to add down it no longer works the way it did. This
is the result I am trying to get on the whole spreadsheet

(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
(0, 1) (1, 1) (2, 1) (3, 1) (4, 1) (5, 1)
(0, 2) (1, 2) (2, 2) (3, 2) (4, 2) (5, 2)

Thank you very much for your help

 

[Pete_UK]

You can amend Gord's formula like so:

="(" & COLUMN()-1 & ", " & ROW()-1 & ")"

Enter this in cell A1 and copy it across. Then highlight row 1 and
copy it down - you will get the layout you want.

Hope this helps.

Pete

 

[Pete_UK]

Sorry to have butted in, Gord - your post wasn't visible (in Google
Groups) when I posted mine.

Pete

 

[Gord Dibben]

No problem Pete

If one is good two must be better<g>

My Dad organized his life on that philosphy and only rarely got into trouble but
when he did.................hooboy!!


Gord