I need to renumber column A in an excel workbook that has 127,000 rows right
now the numbering starts at 10, but I need it to start at 1, I know about
dragging the numbers to renumber it, but it takes a very long time to
renumber 127,000 rows, is there a simple way.

If it makes a difference I am on a Mac.




Looking for diet advice?
http://www.w8lossreviews.com

It should be fairly easy for you to select all of the used cells in column A,
and this solution is based on that.

Pick any empty cell and enter a 9 in it. Use Edit -- Copy to put it onto
the clipboard.
Select all used cells in column A that you want to renumber.
Choose Edit -- Paste Special and choose the "Subtract" option.
All values will be reduced by 9.

Might want to try it on a copy of the workbook or worksheet first to make
sure you get the process right.


"Yookaroo" wrote:

I need to renumber column A in an excel workbook that has 127,000 rows right
now the numbering starts at 10, but I need it to start at 1, I know about
dragging the numbers to renumber it, but it takes a very long time to
renumber 127,000 rows, is there a simple way.

If it makes a difference I am on a Mac.




Looking for diet advice?
http://www.w8lossreviews.com

Enter 1 in A1 and 2 in A2

In name box type A1:A127000 and ENTER

EditFillSeriesLinear and OK


Gord Dibben MS Excel MVP

On Tue, 16 Jun 2009 13:27:01 -0700, Yookaroo
wrote:

I need to renumber column A in an excel workbook that has 127,000 rows right
now the numbering starts at 10, but I need it to start at 1, I know about
dragging the numbers to renumber it, but it takes a very long time to
renumber 127,000 rows, is there a simple way.

If it makes a difference I am on a Mac.




Looking for diet advice?
http://www.w8lossreviews.com

Thank you that worked perfectly saved me a lot of time.

"Gord Dibben" wrote:

Enter 1 in A1 and 2 in A2

In name box type A1:A127000 and ENTER

EditFillSeriesLinear and OK


Gord Dibben MS Excel MVP

On Tue, 16 Jun 2009 13:27:01 -0700, Yookaroo
wrote:

I need to renumber column A in an excel workbook that has 127,000 rows right
now the numbering starts at 10, but I need it to start at 1, I know about
dragging the numbers to renumber it, but it takes a very long time to
renumber 127,000 rows, is there a simple way.

If it makes a difference I am on a Mac.




Looking for diet advice?
http://www.w8lossreviews.com

Thanks for the feedback.

I also liked the other reply you got from JLatham


Gord Dibben MS Excel MVP

On Tue, 16 Jun 2009 14:34:02 -0700, Yookaroo
wrote:

Thank you that worked perfectly saved me a lot of time.

"Gord Dibben" wrote:

Enter 1 in A1 and 2 in A2

In name box type A1:A127000 and ENTER

EditFillSeriesLinear and OK


Gord Dibben MS Excel MVP

On Tue, 16 Jun 2009 13:27:01 -0700, Yookaroo
wrote:

I need to renumber column A in an excel workbook that has 127,000 rows right
now the numbering starts at 10, but I need it to start at 1, I know about
dragging the numbers to renumber it, but it takes a very long time to
renumber 127,000 rows, is there a simple way.

If it makes a difference I am on a Mac.




Looking for diet advice?
http://www.w8lossreviews.com

Enter 1 in A1 , enter 2 in A2.
Select A1:A2 and double click the selection handle (right-bottom of the
selection rectangle)

If this post helps click Yes
---------------
Jacob Skaria


"Yookaroo" wrote:

I need to renumber column A in an excel workbook that has 127,000 rows right
now the numbering starts at 10, but I need it to start at 1, I know about
dragging the numbers to renumber it, but it takes a very long time to
renumber 127,000 rows, is there a simple way.

If it makes a difference I am on a Mac.




Looking for diet advice?
http://www.w8lossreviews.com