By Klaudia Weissmuller at May 02 2019 23:57:49
Nothing can be more frustrating when you're working on your monthly budget than to run out of budget categories as you're grinding through numbers. Trying to decide where to put an expense can be very frustrating. When choosing your budgeting worksheets, look for some major main categories of expenses with the flexibility to add more detailed line items underneath. For example, major budgeting categories include: • Charities / Tithing • Savings • Housing • Utilities • Food • Transportation • Clothing • Medical / Health • Personal • Recreation • Debts
Identical worksheets are needed prior to using the Consolidation feature, creating a sum across worksheets or using the Paste Special Math features to create summary worksheets. By grouping the worksheets first and then adding rows or columns, changing headings and other formatting operations, you ensure that the spreadsheets remain uniform. Be careful when using groups because if you forget that your spreadsheets are grouped and then proceed to add or change figures on a worksheet, all of the worksheets in the group will have the same figures. To remove a group, simply click on a sheet that is not in a group. If all of the worksheets are grouped, right_click on any tab and choose Ungroup Sheets. Keep an eye on the title bar prior to making changes and Excel will tell you if the sheets are grouped.