LinkBack URL
About LinkBacks
I want to lock a portion of the attached (A1:H20 on both sheets) so that users can only input to the yellow and orange cells, with no ability for any scrolling (like the screen is really "frozen" in place). Isn't this possible?
I want to lock a portion of the attached (A1:H20 on both sheets) so that users can only input to the yellow and orange cells, with no ability for any scrolling (like the screen is really "frozen" in place). Isn't this possible?
1. Select column Header I
hold down SHIFT + CTRL then Arrow key to the right ( This will select column I to XFD )
hide the column using right click then "Hide Option"
2. Row Header 21
hold down SHIFT + CTRL then Arrow key to the down ( This will select row 21 up to 1048576 )
hide the column using right click then "Hide Option"
3. Go to VIEW menu untick the "Gridlines" option
Then Protect the Sheet - Select only "Unlocked cells"
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks