Great to see you in these short learning clips :) Keep it up.
@ehsanbb1983
9 ай бұрын
Thanks! Brief and useful
@mehdisaddedine2054
Жыл бұрын
Thank you Leila!
@donnabanks7656
Жыл бұрын
So smart and humble. Love it!!
@raitisuscins2944
Жыл бұрын
@leila create a short video about formulas hidden in cell! 🤩
@mohameddouzane1123
18 күн бұрын
thank you ! it works
@kaustubhkulkarni130
Жыл бұрын
Please make the video about How to hide formula without protecting sheet.
@internet_wanderer8316
Жыл бұрын
Madam is simply great 😊
@hudaabuel-hassan4708
5 ай бұрын
Thanks, That helped a lot! One more thing I noticed is that this works when the range to be locked is only at the beginning of my data set, like column A:A or A:B, if it is located somewhere in the middle of my data range, the lock did not work with me. For ref.: I used that in MS Excel 365 on the cloud.
@Buharialtinee
Жыл бұрын
Thanks for sharing
@Ismail-Yahya
Жыл бұрын
Thank you for this ❤
@MathewUgeo
Жыл бұрын
thanks fro sharing
@PradeepSingh-qb8bh
Жыл бұрын
I've noticed some features such as merge and center don't work after this. Including filters I guess
@JJ_TheGreat
Жыл бұрын
Lol, you shouldn't be using "Merge & Center" to begin with. Use "Center Across Selection" instead!
@FutureCommentary1
Жыл бұрын
You can select WHAT is allowed in a locked sheet under protect sheet you have option to allow filter.
@fawdfire
Жыл бұрын
Thank You!
@AL-vc9xc
Жыл бұрын
How to lock cells with if then statements. For example; if on a drop list, I select “No” in “O6,” I’d like the cell beside “P6” it to be locked. Is there a way to do that? What formula can be used in there? Any help is appreciated! :)
@kacysmith4060
3 ай бұрын
Clutch!!!
@vesaruusunen5685
Жыл бұрын
It would be better if you could lock cell so that drop down list (data validation) works, but you could not copy-paste something else over the cell and ruin data validation.
@skeelo69
Жыл бұрын
do validation first, then protect.
@geoffreyjones3832
Жыл бұрын
@Vesa Ruusunen Doesn't Data Validation using a list actually lock by precluding any attempt to enter non-listed data?
@geoffreyjones3832
Жыл бұрын
@@skeelo69 do you even have to protect anything?
@vesaruusunen5685
Жыл бұрын
@@geoffreyjones3832 It prevents attempt to enter (type and press enter) but you can paste non-valid data there.
@realvirtualdemand4222
Жыл бұрын
Glad I found you oh shorts
@josesebastienlouissaint1756
Ай бұрын
Hi Leila Is there a way to freeze a cell in formula when it is like this [@cell]?
@jesseperez1907
Жыл бұрын
How can I protect a table from cells being edited but able to add rows to a table or find and replace text to open cells?
@samudralagangarao7743
Жыл бұрын
thanks
@AkhileshSingh-w6n
8 ай бұрын
Thanks 🙏 😢😢😢 mam ❤
@ronniel.jacinto
Жыл бұрын
Is there a button in excel to resume protection sheet? :)
@itsagoodday2165
Ай бұрын
I am not able to highlight the rest of the columns after doing g this why?
@HistoryProphecy
Жыл бұрын
Please help me how to make a code to prevent my file to tranfer to another PC🙏
@SachinTawadeSachin_vst
Жыл бұрын
Can we use filter once sheet cell locked???
@FutureCommentary1
Жыл бұрын
Yes. Select what you want to do in a locked cell under the Protect Sheet.
@hanrealistic
Жыл бұрын
When I refresh my pivot tables, it is annoyingly resizes my column widths. I have read some solutions saying un check LOCK option from the format menu. So I did it. It is now most of the cells are showing errors, and when I refresh my Pivot table, it STILL changes the Column Widths.. How can I solve this?
@LeilaGharani
Жыл бұрын
Right-click on the PivotTable > PivotTable Options > Uncheck "Autofit column widths on update"
@abidejaz1090
Жыл бұрын
Awesome
@abc123abc97
Жыл бұрын
It didnt work . I couldnt lock what i typed only the blank cells are locked help
@kingwesleyXIV
11 ай бұрын
Never knew that
@tromzinck
Жыл бұрын
No "Protection" to see anywhere in the popup (free version)
@bahorvan7990
Жыл бұрын
And you can check what the password is with winrar and notepad :)
@kodjoedoh
Жыл бұрын
How may I lock the hole sheet with passwords?
@hansklein3649
Жыл бұрын
You can set a password either by going to the file tab or to the review tab and then protect sheet / workbook as shown here.
@kodjoedoh
Жыл бұрын
@@hansklein3649 thanks
@hansklein3649
Жыл бұрын
@@kodjoedoh Yumi 😀
@GScrubb181
Жыл бұрын
All to stop people who don't know what they're doing from messing with formulas. No matter how obvious you make it, someone will always go fiddling where they shouldn't. 🤪
@dylan4331
Жыл бұрын
Wow❤
@paramesswarr1691
Жыл бұрын
Grate
@mohanm7827
Күн бұрын
When u open the file in sheet it can able to edit😂😂😂😂
@akashwork-k4i
10 ай бұрын
just selcet col3 remove lock
@sefatjanlb4853
5 ай бұрын
❤❤❤❤❤❤
@sefatjanlb4853
5 ай бұрын
Thanks ❤❤❤
@Jocedu06
Жыл бұрын
Yea ok and how do you freeze panes lol
@geoffreyjones3832
Жыл бұрын
@Jocedu06 go to the View tab. There you will find Freeze Frames
@Jocedu06
Жыл бұрын
@@geoffreyjones3832 yea ok and how do you adjust page limits in print view ? (It was a joke obviously)
Пікірлер: 54