T tonyalt3 Dec 27, 2007 #1 I only want users to be able to enter data in a few cells of a worksheet, how do I go about doing this?
I only want users to be able to enter data in a few cells of a worksheet, how do I go about doing this?
N Noob Jedi Dec 27, 2007 #2 I only want users to be able to enter data in a few cells of a worksheet, how do I go about doing this? Click to expand... Tools, Protection, Allow Users To Edit Ranges... Should be self explanatory from there. When you protect the sheet, it'll lock down all cells not included in your selected ranges.
I only want users to be able to enter data in a few cells of a worksheet, how do I go about doing this? Click to expand... Tools, Protection, Allow Users To Edit Ranges... Should be self explanatory from there. When you protect the sheet, it'll lock down all cells not included in your selected ranges.
