Excell Yacheykalarni o'zgartilishidan himoyalash - Защитите клетки от изменений-Lock Cells in Excell
Yacheykalarni uzgartilishidan ximoyalash.
Muxim yacheykalarni, masalan formulalar kiritilgan yacheykalarni ximoyalash uchun "Listni ximoyalash" komandasidan foydalanishingiz mumkin.
Lekin, bunda barcha yacheykalar ximoyalanib qoladi va siz xech qaysi yacheykani o'zgartira olmaysiz. Shuning uchun:
1️⃣ Listni ximoyalashdan oldin, o'zgartiriligan yacheykalar ximoyasini "ochib" qo'yish kerak.
2️⃣ "Рецензирование" vkladkasidan "Защитить лист" komandasini bosing.
3️⃣ Ximoyani bekor kilish uchun "Снять защиту" komandasini bosing.
Listni parol yoki parolsiz ximoyalash mumkin.
--⏱️Timestamps⏱️--
0:00 How to Lock Cells in Excel
1:24 How to Select Editable Cells in Locked Spreadsheet
2:50 How to Unlock Cells in Excel
In this short video tutorial, I’ll show you how to lock cells in an Excel spreadsheet to protect them from overwriting. What we want to do here is leave the cells containing sales data unlocked for editing, so that people could write their own values in these cells, but, at the same time, lock the cells with formulas, months and names to make them read-only (or non-editable). Watch this excel video tutorial to learn how to do it.
#excel #dastur #word #microsoft #microsoftword #dars #2010 #kompyuterorganish #msexcel #msaccess #kompyutersirlari #kompyutersavodxonligi #kompyuter #videodars #makroslar #berilganlarbazasi #shaxsiykompyuter #kompyuterdarsi #sozlamalar #menyu #kompyutersaboqlari #windows7 #farkhod #lotin #virtual #worddaishlash #worddasturidaishlash #virtualdars #turfa #nomer #betqoyish #nomerqoyish #raqamqoyish #sahifaganomerqoyish #krildanlotingaalmashtirish #tilnialmashtirish #jadvallarbilanishlash #lotinkril #lotindankirilgaalmashtirish #kinolar #kompyuterurganish #kirillotin #xarxil #kurslar #2013 #2016 #nimaqilishkerak #2019 #nimaqilsamboladi #tekshirish #bajarish #2003 #2007 #2020 #learnmicrosoftwordfromscratch #organish #изучитеmicrosoftwordснуля #uzbekistan #bahromovislombek #wordnima #toshkent #videokurslar #pdfniwordgaaylantirish #word2010 #microsoftword2016 #msword2016 #watermark #word2013 #word2016 #office #worddasturidaishlashniorganish #officetab #translit #kolonkalar #albomkorinishi #jadvallar #sorovlar #hisobotlar #modullar #asosiytushuncha #malumotlarbazasi #lineyka #stillar #otkazishlotindakirilchagakonvertorengosonusuli #videodarslik #wordniorganish #pdf #kompyuterorganamiz #msworddasturikurslariuzbektilida #компьютер #kompyuterxaqida