Trouble Using Excel Templates

%3CLINGO-SUB%20id%3D%22lingo-sub-2830382%22%20slang%3D%22en-US%22%3ETrouble%20Using%20Excel%20Templates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2830382%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%20I%20have%20been%20trying%20to%20use%20the%20check%20register%20templates%20on%20Excel.%20It%20works%20great%20until%20I%20get%20to%20the%20last%20line%20of%20what%20they%20have%20premade.%20I%20have%20tried%20to%20insert%20rows%20(didn't%20work%20with%20the%20formulas)%2C%20changing%20the%20formulas%20and%20filling%20down%20after%20adding%20rows(Didn't%20work).%20I%20have%20tried%20to%20input%20formulas%20with%20just%20the%20cell%20numbers%20and%20that%20hasn't%20worked%20it%20keeps%20auto%20inputting%20stuff%20into%20the%20formula%20that%20I%20don't%20need.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advice%20at%20how%20to%20use%20these%20templates%20for%20more%20than%20the%2010%20rows%20they%20have%20set%20up%3F%20I%20would%20love%20to%20use%20it.%20At%20this%20point%20I%20am%20about%20to%20just%20make%20my%20own%20spreadsheet%20like%20I%20have%20done%20for%20my%20bills%20and%20other%20things.%20I%20really%20like%20the%20template%20they%20have%2C%20but%20I%20have%20come%20to%20the%20end%20of%20my%20ability%20to%20figure%20it%20out%20on%20my%20own.%20Any%20advice%20you%20can%20give%20me%20would%20be%20great!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2830382%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2830725%22%20slang%3D%22en-US%22%3ERe%3A%20Trouble%20Using%20Excel%20Templates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2830725%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1180869%22%20target%3D%22_blank%22%3E%40lpntee082130%3C%2FA%3E%26nbsp%3BExactly%20which%20template(s)%3F%20A%20simple%20search%20gave%20me%20two%2C%20but%20neither%20of%20these%20are%20very%20complicated.%20Both%20use%20structured%20tables%2C%20which%20expand%20automatically%20when%20you%20type%20a%20new%20entry%20directly%20below%20the%20last%20row.%20Formulae%20will%20automatically%20be%20copied%20down%20to%20the%20new%20row%20as%20well.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20last%20row%2Fcolumn%20in%20a%20structured%20table%20is%20recognised%20by%20the%20marker%20in%20the%20bottom%20right-hand%20corner.%20See%20picture.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-10-10%20at%2007.10.06.png%22%20style%3D%22width%3A%20110px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F316370i645C56F5E2AE4106%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-10-10%20at%2007.10.06.png%22%20alt%3D%22Screenshot%202021-10-10%20at%2007.10.06.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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), changing the formulas and filling down after adding rows(Didn't work). I have tried to input formulas with just the cell numbers and that hasn't worked it keeps auto inputting stuff into the formula that I don't need.

 

Any advice at how to use these templates for more than the 10 rows they have set up? I would love to use it. At this point I am about to just make my own spreadsheet like I have done for my bills and other things. I really like the template they have, but I have come to the end of my ability to figure it out on my own. Any advice you can give me would be great!

1 Reply

@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.

Screenshot 2021-10-10 at 07.10.06.png