ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   rows (https://www.excelbanter.com/new-users-excel/132920-rows.html)

teddkilroy

rows
 
I have a banner that takes up the first two roles and was wondering if there
was any way to re-number row 3 to the last row. I would like row 3 to be
renamed 1 and so on.

Max

rows
 
You can't re-number the row headers if that's what you mean to do. Just use
say, col A to number your rows as desired. Eg enter in A3: 1, in A4: 2. Then
select A3:A4, copy down as far as required.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"teddkilroy" wrote:
I have a banner that takes up the first two roles and was wondering if there
was any way to re-number row 3 to the last row. I would like row 3 to be
renamed 1 and so on.


teddkilroy

rows
 
ok thanks

"Max" wrote:

You can't re-number the row headers if that's what you mean to do. Just use
say, col A to number your rows as desired. Eg enter in A3: 1, in A4: 2. Then
select A3:A4, copy down as far as required.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"teddkilroy" wrote:
I have a banner that takes up the first two roles and was wondering if there
was any way to re-number row 3 to the last row. I would like row 3 to be
renamed 1 and so on.


Max

rows
 
welcome ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"teddkilroy" wrote in message
...
ok thanks





All times are GMT +1. The time now is 01:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com