Join Dennis Taylor for an in-depth discussion in this video Controlling worksheet security by allowing selected users to edit specific cell ranges, part of Excel Tips Weekly.
- Excel has a number of different security features…that allow you to control what's going into a worksheet…or what's being changed in a worksheet.…If you go to the review tab, you'll see protect sheet…and the description says prevent unwanted changes…from others by limiting their ability to edit.…There's also a feature here called…allow users to edit ranges.…We can setup password protection on certain ranges.…In other words, in a worksheet like this, for example,…we could allow some users…to make changes to column J but not others,…and other users to make changes…to column K but not column J.…
This all begins with the idea that we might want to…protect the sheet.…We could certainly use this feature by itself…and achieve a lot.…When you protect a sheet, in effect you're saying,…changes can only be made in certain cells.…Anybody who can open this file-…because when we protect a sheet…we usually provide a password-…anybody who can open this file…can make changes to certain cells.…If you click on any cell in an Excel workbook,…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.