Table of Contents • • • • • • • • How to lock certain cells in Excel • At First, we will need to select the cells we want to lock. • After selecting the cells press on the right click button of the mouse. • Press on the Format cells option. • After the Format cells window open, press on the Protection option and click on the Locked option. • After clicking on the Review option on top, click on the Protect Sheet option. • A Protect Sheet window will come up. Tick on Select locked Cells and Select unlocked cells.

Select the password on Password to unprotect sheet. Another dialogue box of Confirm Password will come up. Reenter the password. Here the password we select was 1234. • After this whenever you want to edit the desired cells of the excel you will see a warning box indicating that you can not edit the cells as it is protected. • For locking rows and columns just move the mouse courser to the row heading or column heading.

For columns a downward arrow and for the row, a rightward arrow will come up. By clicking them on we can select the entire row or column. The rest procedure is same as before.

Music Kodi can play all your music including AAC, MP3, FLAC, OGG, WAV and WMA formats. It allows users to play and view most videos, music, podcasts, and other digital media files from local and network storage media and the internet. Download kodi 16.1 for mac download. It has cue sheet, tagging support, MusicBrainz integration, and smart playlists for ultimate control of your music collection.

I have to unlock a specific range (D6:BC116) in a excel sheet. It should be able for other people editing this specific area. So it should be unlocked for them. At first I manually protect the whole sheet without any code.

How to unlock cells in excel Unlocking the cells in excel is much easier. Just click on the Review option on top, click on the Unprotect Sheet. Enter the password that you gave while protecting the cells. Unlocking the rows and columns of excel follows the same rule. Photoshop elements 2019 for mac. Note that Password protects your sheet effectively. If you don’t want to give any password while protecting a sheet it`s completely your choice.

Locking cells with Excel VBA There is another way of protecting cells, rows, and columns of excel using the VBA code. It`s a long process but it`s easy. The procedure is given below. • Select all the cells in excel. • On the Home tab under the Cells, section click on the Format option and then select format cells • A dialogue box of Format Cells will come up. On the Protection, option unselect the Locked • Down below the excel file where the name of your file is written, click on the right button of your mouse and select the View Code.

• A new dialogue box of Microsoft Visual Basic for Applications will come up. In the white sheet associated with the dialogue box, write down the below code. Click to view full image • In the code, we select the range of data from C7 to E11 and set the password 1234. • After this, Under the Debug option, you will find a Run Sub/UserForm (F5). • Your Excel worksheet will come up along with a password window. Enter the password you wrote on the VBA code.

• After this whenever you want to edit the desired cells of the excel you will see a warning box indicating that you cannot edit the cells as it is protected. Note: Unlocking the cells after applying the VBA code follows the same unlocking method explained earlier. How to freeze rows and columns in excel Freezing is not a lock option but when there is a big data that you are analyzing and you want to work in a specific location of your excel file freezing the data is an effective way of doing that. The procedure is given below. • Let’s say you want to freeze your data so that it will show only the columns heading. • Just click any cells in row 4 as your headings are in row 3. • We select A4 The freezing will happen in the upper and lower side of the A4 cell.

• On the View option at the top click on the Freeze Spans. • Different options will come up. You will select the Freeze Spans only.

• After scrolling the excel sheet you will see only the headings of your columns will remain in the same position. • If you want to unfreeze it just go to the view option again and under the Freeze Spans click on the Unfreeze Spans. • If you want to freeze the first column only, click on the Freeze Spans under the View option in the top. • It will freeze the top first column.