@cellmates_: #ExcelTutorial | Ever wondered how you can protect all the cells that contain formulas and leave everything else editable in an #excelworksheet This video is for YOU! #excel #exceltutorial #exceldemo #tutorial #learnexcel #microsoftexcel #excelbasic #excelforbeginners #excelintermediate #excelhacks #productivityhacks #microsoft #exceltraining #spreadsheets #analyzedata #analysedata #dataanalysis #dataanalyst #exceltips #exceltricks #excelbasicskills #excelbasics #excelpro #excelprotips #LearnOnTikTok #learnexcelontiktok #excelforwork #excelhacksforwork #excelforbusiness #excelforaccountants #excelforfinance #excelforstudents #exceltipsuk #howto #edutok #fyp #viral #exceltipsandtricks #exceltipsuk #excelefficiencyhacks #microsoft365 #betterspreadsheets #microsoftambassador

Deb Ashby | Cellmates
Deb Ashby | Cellmates
Open In TikTok:
Region: GB
Thursday 30 May 2024 20:57:02 GMT
32098
1242
49
186

Music

Download

Comments

felmispeedy4
felmispeedy4 :
Can we do that using index and match function ?
2024-07-11 13:43:01
0
livelyvictoriousdrum
Melissa :
I was just wondering about this! Thanks!
2024-05-30 21:10:43
6
abadformula
Kaz :
Is there a way to protect conditional formatting on cells but still allow users to add/edit values on the these cells?
2024-05-31 00:42:03
9
zoran.cloud
Zoran.Cloud :
Why not SELECT ALL / UNLOCK and then add the LOCK the cell you do not what to be chanced?
2024-07-13 06:57:14
0
viejoantonio78
ViejoAntonio :
Finally an explanation that makes sense
2024-07-14 16:27:41
1
gohar.iqbal16
gohar iqbal :
This was my biggest dream to see you. Finlly❤️❤️❤️. I follow all your videos on YouTube.
2024-07-06 09:14:20
1
angilizaj
Angiliza :
Yes please
2024-06-02 04:58:05
5
234mammasbh
234MammaSBH :
Definitely need tables protection. Just specific columns in a table.
2024-07-21 20:52:31
1
styla.artois
Styla Artois :
I do have a question too : how I can protect a sheet with tables, but can add or delete lines ?
2024-07-10 21:46:56
1
lokitex
MannyB4 :
Is there a way we can protect a cell from copy/paste information and only allow it to be typed information?
2024-05-31 12:15:27
4
martinwebber0
TheElectrician :
I was trying to work out if I could lock a cell, but still allow users to format the text still?
2024-06-02 05:49:32
1
kevinbolt95
Kevin Bolt :
I’d love to know the VBA to be able to use Tables with protection.
2024-05-31 07:25:17
2
chopin227
Jeremy :
I would absolutely appreciate a video on how to work with tables and locked cell. I build spreadsheet with tables and complex formulae all the time and my colleagues always break them lol
2024-05-30 23:57:31
3
rpwnzl
Rapunzel :
How can you miss the joke entering a wrong 2 char password 😂???
2024-05-31 04:41:34
0
bobhardwick
Bob Hardwick :
Thank you!
2024-06-01 03:58:12
1
mrslisaferguson
Lisa Ferguson :
Deb it’s stressing me that the xlookup cells arent centred but the data table is 😭
2024-05-30 21:07:38
2
sa.dell0
Sa dell :
welcome back loving your videos
2024-05-30 21:19:11
1
danni_man
danni_man :
No athletes from Ethiopia or Kenya in data for a marathon? lol😁
2024-06-17 08:45:52
1
nishandranaidoo
nishandranaidoo :
hi can we meet please I need face to face tutor
2024-06-01 19:36:30
1
pibax39814
pibax39814 :
how do I round the pennies down and deposit the difference into my bank account
2024-06-01 10:56:09
1
_shadoan
Shadoan :
Thanks!!🤩
2024-05-31 03:54:30
1
nanamusheen
Nana_B_Poofy🍁 :
Thanks! Unfortunately I work with tables :-( but it would be great to know how to protect specific columns where I have my formulas :-) thanks!
2024-05-30 21:47:34
1
boachie_adolf
Adolf :
👍👍👍
2024-05-30 21:31:09
1
joseantoniogarc55
Jose Antonio Garcia :
Totally awesome thank you 🙏🏻
2024-07-05 02:30:53
0
elitusell
EliTP :
Fun & learn, the best formula!! 🥰
2024-06-03 05:48:52
0
montebanat
MonteBanat :
I’m looking at you, Val. 😐😳 One of the first things I learned was how to protect cells, formatting, etc.
2024-06-02 08:03:25
0
dragonwynja73
Dragonwynja73 :
Can you hide cells from some people like choosing who will se a couple of cells or just one sheet ?
2024-05-31 22:18:32
0
empress_k123
empress_k123 :
love your voice. very calming
2024-05-31 14:01:50
0
yongha77
Lvie :
Not available in our Microsoft 365 😆
2024-05-31 13:56:19
0
raver000
dave :
nearly completed my basic in excel.is the next level intermediate?
2024-05-30 21:54:26
0
meggisuz
Meggi :
would definitely like to know! currently I make formulated cells a different color and tell people not to touch that color
2024-05-30 21:18:29
0
To see more videos from user @cellmates_, please go to the Tikwm homepage.

Other Videos

𝗦𝗞𝗜𝗡 𝗖𝗔𝗥𝗘 𝗚𝗢𝗔𝗟𝗦 🫧 Working your skin from the outside in, this treatment has been designed to deeply exfoliate dead skin cells and remove nonterminal hair, polish the skin, flush toxins, increase and stimulate our natural collagen and cell turnover. This method will heavily increase the absorption of any active ingredients by 80% as opposed to 8%, therefore we use our Million Dollar ampoules for maximum results. Our Million Dollar facial treatment is a 10 step unique protocol which includes dermaplaning, skin needling and lymphatic drainage massage. The Million Dollar facial like all our Million Dollar protocols is performed with our Million Dollar professional range of specifically designed clinically proven exclusive products. Targeting concerns like fine lines and wrinkles, pigmentation and acne scarring giving benefits of a brighter skin with a smoother more even complexion. Contact to book in for your ultimate Skin Care TLC 🫧 𝗕𝗼𝗼𝗸 𝗔 𝗖𝗼𝗻𝘀𝘂𝗹𝘁𝗮𝘁𝗶𝗼𝗻 𝗪𝗶𝘁𝗵 𝗨𝘀 𝗧𝗼𝗱𝗮𝘆 🤍 Ultimate Lip Transformations 🤍 Advanced Facials 🤍 Body Contouring Specialist 📍Aylesbury #Aylesburyaesthetics #beautyclinic #practitioners #Buckinghamshirebeautyclinic #Aylesburyyoga #Buckinghamshireyoga #Aylesburybusiness #Buckinghamshirebusiness #lipfillerAylesbury #lipfillerBuckinghamshire #aestheticsAylesbury #Aylesburyaesthetics #Buckinghamshirerestaurant #Aylesburyrestaurant #Buckinghamshireaesthetics #Buckinghamshiredermalfillers #Aylesburydermalfillers
𝗦𝗞𝗜𝗡 𝗖𝗔𝗥𝗘 𝗚𝗢𝗔𝗟𝗦 🫧 Working your skin from the outside in, this treatment has been designed to deeply exfoliate dead skin cells and remove nonterminal hair, polish the skin, flush toxins, increase and stimulate our natural collagen and cell turnover. This method will heavily increase the absorption of any active ingredients by 80% as opposed to 8%, therefore we use our Million Dollar ampoules for maximum results. Our Million Dollar facial treatment is a 10 step unique protocol which includes dermaplaning, skin needling and lymphatic drainage massage. The Million Dollar facial like all our Million Dollar protocols is performed with our Million Dollar professional range of specifically designed clinically proven exclusive products. Targeting concerns like fine lines and wrinkles, pigmentation and acne scarring giving benefits of a brighter skin with a smoother more even complexion. Contact to book in for your ultimate Skin Care TLC 🫧 𝗕𝗼𝗼𝗸 𝗔 𝗖𝗼𝗻𝘀𝘂𝗹𝘁𝗮𝘁𝗶𝗼𝗻 𝗪𝗶𝘁𝗵 𝗨𝘀 𝗧𝗼𝗱𝗮𝘆 🤍 Ultimate Lip Transformations 🤍 Advanced Facials 🤍 Body Contouring Specialist 📍Aylesbury #Aylesburyaesthetics #beautyclinic #practitioners #Buckinghamshirebeautyclinic #Aylesburyyoga #Buckinghamshireyoga #Aylesburybusiness #Buckinghamshirebusiness #lipfillerAylesbury #lipfillerBuckinghamshire #aestheticsAylesbury #Aylesburyaesthetics #Buckinghamshirerestaurant #Aylesburyrestaurant #Buckinghamshireaesthetics #Buckinghamshiredermalfillers #Aylesburydermalfillers

About