To protect a closed month in Google Sheets, select its rows or its tab, open Data > Protect sheets and ranges, and set the permission to show a warning or to restrict editing to you. In Excel, keep one sheet per month and use Review > Protect Sheet on each closed month. Protection stops accidents; it is not strong security.
How do I protect a closed month in Google Sheets?
- Select the rows that hold the month, for example by clicking row numbers 2 to 41, or go to the month's tab.
- Open Data > Protect sheets and ranges. A panel appears on the right.
- Press Add a sheet or range. Give it a description such as Nov 2026 closed.
- Check the range. If you chose a tab, switch to the Sheet option.
- Press Set permissions and pick one of two choices.
| Option | What happens when someone edits | Best for |
|---|---|---|
| Show a warning when editing this range | A warning appears, but the person can still go ahead | A sheet used by trusted family, where you want a nudge |
| Restrict who can edit this range | Only the people you list can edit; others cannot | A month that must not change, shared with several people |
A warning does not stop anyone; it makes them stop and think. If the sheet is only yours and your spouse's, that is often enough. If a CA or a relative also has edit access, restricting is safer.
How do I do the same in Excel?
Excel protects a whole sheet at a time, so the neatest way is one sheet per month. When the month is closed, go to that sheet and choose Review > Protect Sheet. A box asks what users may still do. Untick the editing choices, and add a password if you want one. Closed months are then read-only, while the current month stays open for typing.
- Right-click the sheet tab and Move or Copy to build next month's sheet from the current one.
- Name tabs by month and year, like Nov 2026, so the order is obvious.
- Keep totals for the year on a separate Summary tab that reads from each month.
What should I do when a closed month is wrong?
Do not unlock it quietly. Unprotect, fix the entry, then add a note in a Changes column or a comment with the date and the reason. Protect it again. A closed month that keeps changing is no longer closed. If the fix is small, many people prefer to book a correction in the current month with a note, so the old month's total is untouched.
A month-close checklist
- Match every account's closing balance to the statement for the month.
- Check for entries dated into the wrong month, especially those near the 1st and the last day.
- Confirm rows with no category are filled in.
- Look for duplicate entries, such as the same amount to the same merchant on consecutive days.
- Save a PDF or a dated copy of the month.
- Protect the rows or the tab.
- Tell anyone else who edits the file that the month is closed.
How do I handle the financial year end?
In India the year runs April to March. At the end of March, close the month as usual, then keep a copy of the whole file named for the year, for example FY 2026-27 closed. In Sheets, you can also name the version in version history so you can find it again. If a CA needs numbers for filing, ask them in what form they want the data and share only that.
Where do spreadsheets stop being enough?
A locked sheet is good for a record you will not touch. If you reconcile many transactions every month, a tool that holds each transaction against its account and keeps deleted items in a recycle bin for 30 days can save work. SpendixAI does this, with reports and CSV download for the months you want to keep outside the app.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

