T
Tracey
How do you protect individual cells in multiple worksheets
(Excel) at once. I have mastered the art of doing one page
at a time, but so far I am unable to select all the sheets
and make the changes to all of them in one go, although
the sheets are identical in format. I have one document
labelled January to December (12 worksheets in all). I
want to protect the same cells for all sheets so a
selected group of individuals can gain access for editing.
The problem is once I have saved the document with the
individual sheet isolated for changes to cells excel won't
allow me to make the same changes on the other 11
worksheets - why?
Help.
(Excel) at once. I have mastered the art of doing one page
at a time, but so far I am unable to select all the sheets
and make the changes to all of them in one go, although
the sheets are identical in format. I have one document
labelled January to December (12 worksheets in all). I
want to protect the same cells for all sheets so a
selected group of individuals can gain access for editing.
The problem is once I have saved the document with the
individual sheet isolated for changes to cells excel won't
allow me to make the same changes on the other 11
worksheets - why?
Help.