Spreadsheets

Lock a closed month: protect past data in Sheets and Excel

Protect a closed month with an edit warning or restricted editors in Google Sheets, a protected sheet per month in Excel, and a month-close checklist.

Editorial illustration for Lock a closed month: protect past data in Sheets and Excel

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?

  1. Select the rows that hold the month, for example by clicking row numbers 2 to 41, or go to the month's tab.
  2. Open Data > Protect sheets and ranges. A panel appears on the right.
  3. Press Add a sheet or range. Give it a description such as Nov 2026 closed.
  4. Check the range. If you chose a tab, switch to the Sheet option.
  5. Press Set permissions and pick one of two choices.
OptionWhat happens when someone editsBest for
Show a warning when editing this rangeA warning appears, but the person can still go aheadA sheet used by trusted family, where you want a nudge
Restrict who can edit this rangeOnly the people you list can edit; others cannotA 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

  1. Match every account's closing balance to the statement for the month.
  2. Check for entries dated into the wrong month, especially those near the 1st and the last day.
  3. Confirm rows with no category are filled in.
  4. Look for duplicate entries, such as the same amount to the same merchant on consecutive days.
  5. Save a PDF or a dated copy of the month.
  6. Protect the rows or the tab.
  7. 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports