Share via

Right side margin numbers

Anonymous
2011-09-12T17:28:32+00:00

I am using a 2003 excel program spreadsheet   on the left hand side there are numbers starting at the top and numbering consecutively each row.   I want the numbers to start on the 3rd row,  so the first two rows are not numbered.   and I want the numbers to be inside the margin of the first column   How do I do this

kmfg

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2011-09-12T17:43:48+00:00

So that we are on the same page... The columns at the top are labeled A, B, C, ... and the rows are labeled 1, 2, 3 ...

That is how XL works and you can not change it. If you changed it then formulas would not be able to reference the cells effectively. What you can do is to add numbers into column A. In A3 add the number 1. In A4 add the number 2. Highlight both of those cells and by grabbing the bottom right corner of the selected cells and dragging it down you can create the numbering that you want.

Was this answer helpful?

0 comments No comments

0 additional answers

Sort by: Most helpful