The problem isn't creating consecutive numbers above 100 in the Columns but in the default numbering to the left of Column A. What you suggest allows me to number consecutively within a column but not the default numbering that Excel creates for each row. There, the number of the row creates consecutive numbers up to 100 but then, some idiot programmer had decided to start over again at 1, meaning that row 101, row 201, etc. are listed as 1. Now if I go to the name box on the top left, the correct row number is indicated but the actual row number to the left of the columns is not and it defaults back to the number 1 after each 100 rows are numbered.
Now I am sure there is a simple way to solve this but I've tried everything. I've googled this but nothing comes up and I can't find anything on the ribbon that allows me to change the default numbering of rows.
Interestingly, Excel crashed and restarted. When it did, it had created numbered rows with the actual number of the row when the row number was higher than 100. You would think this would be the default but it's not. Secondly, when I had saved and closed Excel and restarted it later, the row numbers above 100 were gone again.
However, I had just discovered something I didn't see before that impacts upon this: when I reduce the size of the screen to half size, the numbers over 100 appear. It seems that for some reason my screen, (which is very large) doesn't show the first digit in the numbering queue in front of Column A. It appears that it is cut off by the screen so this is probably less to do with Excel than how Excel appears on my screen. This didn't happen, however, with the same screen with Excel 2007.
This, then, could be solved if I could move the left border of Column A a fraction to the right, yet as with other columns where this is easily done, I can't seem to move the left border of Column A to the right a fraction so that there is room to show the first digit in a 3-digit number.