Automatically Adding Rows

When you say "on the top of my check register worksheet", do you mean that you want to insert 100 rows at a particular location, ie row 2 or row 3? Please clarify?

In the Name Box (left of the formula bar and just above the row number column) enter $1:100 and hit enter. Right click on a ROW number on the left and choose INSERT. 100 rows will be inserted. (from row 1 to row 100.)

If you want to start at a different row other than 1, change the 1 to the starting row and add the starting row -1 to the 100 so if you start in row 3 the entry would be $3:102

You can record a macro to do this and

I can't replicate your problem. Can you post a copy of your workbook? The E3:100 reference won't work. If you are going to use E3 it would have to be E3:E100 which would select the column E from row 3 to 100.

3:100 selects all the columns from row 3 to 100. In my original $3:100 the $ is not necessary 3:100 will do exactly the same.