Forum Discussion
Trouble Using Excel Templates
Hi. I have been trying to use the check register templates on Excel. It works great until I get to the last line of what they have premade. I have tried to insert rows (didn't work with the formulas)...
lpntee082130 Exactly which template(s)? A simple search gave me two, but neither of these are very complicated. Both use structured tables, which expand automatically when you type a new entry directly below the last row. Formulae will automatically be copied down to the new row as well.
The last row/column in a structured table is recognised by the marker in the bottom right-hand corner. See picture.