ExcelBanter - Microsoft Excel 2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Microsoft Excel 2003 (https://www.excelbanter.com/excel-worksheet-functions/189510-microsoft-excel-2003-a.html)

Clark

Microsoft Excel 2003

How do I change the row reference numbers on the left of the worksheet so
that the first row #1 is blank and then the row numbers start on row 2 but
with #1?

Max

Microsoft Excel 2003

"clark" wrote:
How do I change the row reference numbers on the left of the worksheet so
that the first row #1 is blank and then the row numbers start on row 2 but
with #1?

You can't. Just use col A for your row numbering, to taste.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Gord Dibben

Microsoft Excel 2003

ToolsOptionsView.

Uncheck row and column headers. In A2 enter this formula.

=ROW()-1

Copy down as far as you wish.

This is for appearance only.

Row 1 is still row 1

Gord Dibben MS Excel MVP

On Fri, 30 May 2008 16:27:00 -0700, clark
wrote:

How do I change the row reference numbers on the left of the worksheet so
that the first row #1 is blank and then the row numbers start on row 2 but
with #1?

All times are GMT +1. The time now is 03:54 AM.