Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Sorry for my second Excel question in as many days! Almost there now though :)

I've created a template for an invoice for my mum... is there anyway I can sort of lock the file, and create sub invoices from it, hopefully achieving...

  1. Any changes made to the default/master invoice will reflect on all of the others
  2. Locking down the spreadsheet so she can only edit certain columns? :D

Any suggestions would be fantastic, thanks

share|improve this question

migrated from Aug 24 '09 at 7:16

This question came from our site for professional and enthusiast programmers.

Since Stack Overflow is a programming website, I'm afraid this question is off-topic. (But for the record, you can't do no. 1 and you can do no. 2 -- check Excel's help for more information). – Todd Owen Aug 23 '09 at 11:13
...though you can do no. 1 to some extent at least (again, please refer to the online help). – Todd Owen Aug 23 '09 at 11:16

You can "save as" template. When Mum double-clicks the doc, that will create a fresh unsaved doc. which is a copy of the template.
In xl, all cells are by default "locked", but you won't see it until you protect the sheet.
So, first, unprotect the input cells (that's in the Format, cells), then lock the sheet (that's in format, sheet).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.