@cellmates_: #ExcelTutorial | Apply Automatic Formatting to #Excel data! In this video, we’ll learn how to use #conditionalformatting to automatically apply borders when new data is added. #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 19 September 2024 20:44:58 GMT
38934
1356
58
173

Music

Download

Comments

emilymeyrickxxx
emilym :
Hey, wondering if you can help. I work with excel a lot (hate it because I can’t use it 😂) I insert children’s dates of birth and then have to work out which school year they are in. So…
2024-09-21 21:32:42
0
weeklybin
weeklybin :
Great tip but doesn’t that take longer than making it a table with style?
2024-09-20 05:59:17
1
cruise_with_suz
Suz :
I would just format my data into a table and tab which adds rows with all the formatting. Then I have the advantage of using slicers
2024-12-11 00:02:06
0
xerepoly
xerepo :
Ok: the grid thing I didn’t know. All the time wasted changing the background color. Also, how many weeks of scrolling I have wasted by not knowing the back to top keeping the selection shortcut. Thank you.
2024-09-19 21:00:21
8
amandaross539
amandaross539 :
Love your content! Thank you for sharing this tip for us those of us who dislike tables!
2024-09-21 18:10:18
1
yongha77
Lvie :
Salamat 🥰
2024-09-20 00:47:38
1
dkbkaps
DKBkaps :
Nice tip .. thank you ❤️🔥💯
2024-09-20 03:27:46
1
pilgrim_03
MK :
Awesome !
2024-10-17 07:55:34
1
sakai_welpik
Welpik :
control backspace 🔥🔥 that's a great tip
2024-09-26 15:06:33
1
im_00o
🩵1stCitizenOf🇳🇬🇳🇬 :
thank you
2024-09-19 21:29:43
1
shanmu550
shanmugam opm :
thanks for this 🙏
2024-10-12 21:20:41
1
selina24.7
⭐Selina⭐️ 🇬🇧 🏴󠁧󠁢󠁥󠁮󠁧󠁿 :
THANK YOU!! knew there was a way to do this but for the life of me i couldn't remember. Thank you for all your amazing nugget bite info posts!! 1000% helps loads 🥰
2024-09-19 23:33:54
1
pmajestic
pmajestic8 :
Brilliant as ever
2024-09-19 21:48:57
1
xerepoly
xerepo :
Also a question: On the row 1 you have that nice accent on 1A and then title. I like that style. My question: is that just an aesthetic choice or is there a functional reason too? Thanks for all the education
2024-09-19 21:02:28
0
mrskatyk
MrsKatyK :
🥰🥰🥰
2025-01-23 16:48:34
1
kuroinosuke123
KuroInosuke123 :
🥰
2025-05-22 11:35:53
0
sanjeevb157
Sanjeev Kumar :
It’s really amazing and useful tricks I will now apply in my bank reports!!! Thank you very much!!! Can you please tell me how to use the filter function in excel!!!
2024-09-22 15:15:06
1
add.ne.be
AN_B :
that is cool, thanks.
2024-09-20 14:45:16
2
dannydiaz02
Danny Diaz :
Awesomeness! 😎💯✌️
2024-09-28 01:00:16
1
ea_blair4
EA_Blair :
Cntrl + Backspace ! Oh the time I have wasted... Could you do a video on navigation shortcuts?
2024-09-25 11:05:40
1
cast555555
cast555555 :
😳😳😳😳😳
2024-09-21 01:03:31
1
thedarknightrises1
TheDarKnightRises :
My crush 🥰
2024-09-20 08:09:49
1
rianvisser0
Fish :
LOVE
2024-09-19 21:00:59
1
firesidefluff
firesidefluff :
Very cool tip!
2024-09-19 20:56:11
1
andrewlinus8
andrewlinus8 :
😁
2025-04-25 05:48:38
0
iaingoulden
IDG :
What if the data is copied from another source using copy > paste special >values? Does the conditional format still apply itself?
2024-09-20 07:17:36
0
To see more videos from user @cellmates_, please go to the Tikwm homepage.

Other Videos


About