Excel Tutorial - Using the Split Option to See Your Data

Learn how to split the view in Excel so that you can look at any two parts of a spreadsheet at the same time. #exceltutorial
***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...
See below for more information about the bands mentioned in the video:
Talk Talk - The Colour of Spring: amzn.to/2xkFuUV
Talk Talk - Triple Album Collection: amzn.to/2shLZSx
Blume - Ashes: amzn.to/2slinDG
***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...

[@gbuforfaith9677]

Thanks sir, im a big fan and you make excel so easy for me. From Nigeria

[@iamnumber_0981]

thank you! I accidentally did this on my excel at work and i dont know how to undo it. I tried to but it was already saved. I'll try this tomorrow to fix it. Hope it works. You don't know how much this helps me. Keep your content. 💙

[@michaelpoole909]

This was a life saver. My Excel has a buggy freeze panes, so I am going to use the split option to effectively freeze columns and rows. It is a little more confusing than freeze panes, but at least I don’t have to buy a new MacBook to overcome the freeze panes bug.

[@davidedwards3361]

I am using an old version of Office (that's all I need), and I have done thif before, but forgot the old terminology.
I got about 20 seconts into the video and I had all the info I needed
Thanks.

[@larissaaboh1679]

I really enjoyed it .Your a good teacher.

[@honeysharma2817]

This was so much help, love from India 🤗

[@ivanpantic185]

Great tutorial! Maybe you should explain how split defers from freeze panes if it does.

[@TheHortie]

I love your soft propaganda of music taste ;)
...and movies in the other videos - yes I am watching 'em all -- better be professional by the end of the week :p
I also want to say thank you for your guidance, and like many others, your voice is just perfect for this kind of learning, the sound is great, your speech is at a good speed and you don't say too much that would be confusing.
Great teacher, thank you again.

[@adam346]

the more i watch these, the more i swear he's just doing this to get people hooked on his music... good tutorials none the less

[@kinjalchauhan7501]

hahaha

[@joyxu7563]

hahah that's one of the best ways to do so

[@oliveray8996]

Thanks a lot your videos have really been helpful 👍
You're a good teacher

[@uraaxeecaqligaaga4890]

I like you Mr synthpop you are the smartest.

[@axelace5136]

Thank you so much, I've been watching your excel videos from the start and I'm learning a lot thank you so much for sharing your knowledge 🤗🤗🤗🤗

[@Super_Judith]

Thank you once again. Your videos are very helpful.
Please do you also have tutorials on Ms word and power point?

[@southernbelle6564]

Thank you! You are awesome!🙏

[@Adrian-ub7im]

Thanks, learned something new 👍

[@GinMiko]

Great info. Thanks for posting.

[@tumelo3703]

Wow I didn't even know about that function thanks man the good work...

[@imanlam8829]

that dude who disliked this did it because he/ she wanted to be the first to do so lol

[@elizabeth-tu7qz]

very very helpful!

[@glisten_skin]

Good as usual

[@janethrodrigues4576]

What i great video exactly what i needed.

[@alainlasquety5958]

got it! thank you!

[@Hamza-yv6uy]

Thank you for this enriching sharing , is it possible that this split can be independent ? One completes the other without having duplications.

[@collinsnzuya999]

thank you

[@salzebrahim9527]

Hi. I like your videos. I am an online teacher and find using excel a great way to plan my many lessons with my students. I basically plan 10 lessons at a time which lasts a month. However, sometimes, I plan extra so end up writing more in a cell than the previous lesson. This causes a problem because I need to adjust the column or rows (by making them bigger) to fit all my information. Now I am ending up having a messy lessonplan on excel as some cells are big with very little information on them. Now sure if this makes sense… I need help!

[@favoursimeon5717]

Please can I get more of your videos on excel

[@techteachersandstudents]

Yes, please. If you go to my channel homepage, there are many playlists about Excel for you to explore.

[@emperoy8]

Great Job. Do you have any tutorial on Google Certificate Level 2?

[@dineshbhagtani8030]

Thanks

[@mpmithun]

Thanks sir

[@eldonzeta]

this is different from Split text into column, right?

[@titserRider]

Thats a huge mouse pointer you got there!

[@ibraklay9343]

👍🏼

[@cinephile9346]

where is the file?

[@godwinuche4669]

Same thing I asked

[@alias1180]

Stop selling synthpop otherwise tq for the vid

[@lilynguyen354]

I'm practicing Excel and improving my English skills simultaneously. I'm so glad I found your channel; your voice is very nice. Love the music you share. Thank you 😍😍😍

[@JohannasHair]

.I came here to re-learn how to use the split screen option, but then as you mentioned the freeze panes, it came back to me that I could just use the freeze pane option instead. Thanks a mil!

[@godwinuche4669]

Split is confusing i prefer the freeze Paine

[@ravindurukshan8765]

can we able to print the data using split. like you said i need to get the data on ''z row''

[@raisaoffice490]

Thanks , Keep up the good work

[@trishnashrestha5649]

can you provide the workbook

[@iZacq]

How to undo it ?

[@charlesmiano2725]

All great

[@abbyboyone]

DM#1

[@nassimabed]

Split never worked for me. It brings in the disadvantage of duplicating without the advantages I need: I want to scroll down for columns A to L and keep seeing the top rows of columns M through Z. Couldn't figure how to do that in split. Also want to group/ungroup rows for columns A to L but without grouping rows for columns M to Z. I have no idea how to do that. Usually I just go on different sheets and link them but now I need to change things on one side and immediately see results on the other side.

[@AndreaNobili84]

Than for the tutorial !!! And great music collection...Ulver are for true expert ;-)

[@herijust3824]

Kindly allow to use your patron from all over the world. I hope you got what I mean

[@GranthamLifesciences-b9k]

Very helpful video. Thankyou so much sir ❤

[@jaimevilaplana3691]

hi everyone , where are information these columns? thanks !!

[@waynestewart1919]

I use LibreOffice in Linux and this feature is in there. I remembered this from one of my college courses (Office 2013) and wanted to be able to do this on an accounting sheet. Thanks!

[@nahidbanu5511]

Thank you for the most useful tutorials

[@michaelsmith1076]

can you split columns

[@wisdomarthur4653]

Great Tutorials

[@danishiqubal4516]

Thnx a lot

[@neilcargill1555]

thank you