renumbering of rows

  • Thread starter Thread starter pboost1
  • Start date Start date
P

pboost1

Hello everybody. I have a spreadsheet where row 1 and row 2 I am using
for headers. I have frozen rows 1 and 2 so the header is always
visible when I enter data. I was wondering if there is a way to
renumber the rows so the headers does not contain the numbers 1 and 2.
Any help anybody can give would be greatly appreciated. Thanks.
 
While you can't change the numbering of the rows, you can get something that
will look almost the same:

1. Click on column A
2. Insert Column
3. Starting at cell A3 and moving on down, enter 1,2,3,4,...

The new column A will be numbered just as you desire.
 
You could hide the row numbers and use column A to show what you want, but I
wouldn't bother. It'll become a pain when you insert/delete rows and when
you're writing formulas.

Besides, isn't everyone used to seeing those row numbers in excel?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Column Renumbering Question 3
Auto re-numbering when a row is deleted 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
auto renumbering rows with blank spaces 5
Auto update row numbers after inserting new row 4
row re-numbering 1
Excel 2007 - freeze multiple panes? 2
numbering based on new values 1

Back
Top