#excel How to lock and unlock cells in Excel #shorts

1. Unlock all cells on the sheet
By default, the Locked option is enabled for all cells on the sheet. That is why, in order to lock certain cells in Excel, you need to unlock all cells first.

Press Ctrl + A or click the Select All button The Select All button in an Excel sheet to select the entire sheet.
Press Ctrl + 1 to open the Format Cells dialog (or right-click any of the selected cells and choose Format Cells from the context menu).
In the Format Cells dialog, switch to the Protection tab, uncheck the Locked option, and click OK.

How to lock cells in Excel
Locking all cells on an Excel sheet is easy – you just need to protect the sheet. Because the Locked attributed is selected for all cells by default, protecting the sheet automatically locks cells.

If you don’t want to lock all cells on the sheet, but rather want to protect certain cells from overwriting, deleting or editing, you will need to unlock all cells first, then lock those specific cells, and then protect the sheet.

The detailed steps to lock cells in Excel 365 – 2010 follow below.

#CARajatAgrawal
#excel
#advancedexcel
#advancedexcelforauditors
#ca articleship
#excel 2007
#office 365
#power apps
#excel for CA
#auditor
#ca
#cs
#cwa
#accountant
#management
#microsoft
#formula
#shortcuts
#exceltricks
#learn excel in hindi
#learn excel advanced level
#microsoft excel full course
#microsoft excel basics
#excel shorts
#serial number
#automate
#auto update
#Offset function
#offset
#last value in a column
#last value in a column with the offset function in exce

Please take the opportunity to connect and share this video with your friends and family if you find it useful.