what shortcut do i use to go to the last row with data?
On Windows, ctrl+End will jump to bottom row and rightmost column in use in your spreadsheet.
“In use” in this context means “data entered” or “cell formatting applied”, so if you already formatted a range for data input, the shortcut will skip to the end of that range. If you apply formatting to entire columns/rows (selected by clicking the row/column “coordinate headers”), it does not affect the “cells in use” and ctrl+end will work as desired.