I have data at a specific row at the bottom of the worksheet that I want to
stay in that row. However, when I add new data above it to a blank row and
tab past the end of the last cell to bring me down to the next row, the row
I want fixed (totals) also moves down one row.

Would someone mind telling me how I keep that totals row (last row) fixed
and allow new data to be entered into blank rows above it, please? Thanks.

Just to clarify, I have columns A to I in use and no others past that to the
right. When I finish in column I for one row, I use the tab button and that
takes me down to Column A on the next row and that is what seems to be
pushing the totals row down one more row each time. It is important that I
keep the totals row at the bottom fixed.