#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default row re-numbering

In Excel 2007, is there a way to renumber my row headings (i.e. I want row 2
to be named row 1). This is because on row 1, i have my column headings
typed into this row.

Or If I can't do that, can I make my row numbers stay constant so no-one can
change them?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default row re-numbering

Presumable, you are referring to the true row numbers to the left of the
spreadsheet. These cannot be changed (Unless someone has a crazy macro out
there), so you won't have to worry about another user changing them.

If you mean you've placed row numbers in column A, just start them at row 2...

"bonszer" wrote:

In Excel 2007, is there a way to renumber my row headings (i.e. I want row 2
to be named row 1). This is because on row 1, i have my column headings
typed into this row.

Or If I can't do that, can I make my row numbers stay constant so no-one can
change them?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Row Numbering ironman Excel Discussion (Misc queries) 8 September 21st 07 01:36 AM
PO with sequential numbering with start / end numbering [email protected] Excel Discussion (Misc queries) 1 April 24th 07 03:38 PM
Numbering John Excel Discussion (Misc queries) 4 January 19th 07 10:52 PM
Re numbering the row. Javster095 Excel Discussion (Misc queries) 2 January 8th 06 01:46 AM
Numbering add in Paul Excel Discussion (Misc queries) 2 March 23rd 05 02:46 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"