How to Lock Cells in Excel

I suppose you want to lock certain cells instead of the whole sheets. To do that, choose the whole sheet, right click and then select "Format Cells", then "Protection", then uncheck the "Locked" option and click okay. Then select the cells you want to lock, right click and select "Format Cells", then Protection; this time, check the "Locked" option and click okay. Now go back to the main tab, select "Review", then click on "Protect Sheet", and do whatever you want to do with it. Now only the cells you "locked" are protected from editing instead of the whole sheet.

You cannot protract a single cell in Excel. You can, however, make it appear longer than the rest of the cells around it by "merging" two or more cells together. Highlight the cells you desire and right click. A menu will pop up allowing you to merge them.

Select the whole worksheet by clicking the Select All button. On the Home tab, in the Font group, click the Format Cell Font dialog box launcher. On the Protection tab, clear the Locked box and then click OK.