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...

Пікірлер: 56

  • @lilynguyen354
    @lilynguyen3549 күн бұрын

    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 😍😍😍

  • @adam346
    @adam3465 жыл бұрын

    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

    @kinjalchauhan7501

    5 жыл бұрын

    hahaha

  • @joyxu7563

    @joyxu7563

    5 жыл бұрын

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

  • @gbuforfaith9677
    @gbuforfaith96776 жыл бұрын

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

  • @michaelpoole909
    @michaelpoole9098 ай бұрын

    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.

  • @iamnumber_0981
    @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. 💙

  • @davidedwards3361
    @davidedwards33612 жыл бұрын

    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.

  • @CCJohannaJames
    @CCJohannaJames3 жыл бұрын

    .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

    @godwinuche4669

    2 жыл бұрын

    Split is confusing i prefer the freeze Paine

  • @larissaaboh1679
    @larissaaboh1679 Жыл бұрын

    I really enjoyed it .Your a good teacher.

  • @axelace5136
    @axelace51363 жыл бұрын

    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 🤗🤗🤗🤗

  • @honeysharma2817
    @honeysharma28172 жыл бұрын

    This was so much help, love from India 🤗

  • @GinMiko
    @GinMiko6 жыл бұрын

    Great info. Thanks for posting.

  • @nahidbanu5511
    @nahidbanu55113 жыл бұрын

    Thank you for the most useful tutorials

  • @waynestewart1919
    @waynestewart19192 жыл бұрын

    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!

  • @ivanpantic185
    @ivanpantic1852 жыл бұрын

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

  • @TheHortie
    @TheHortie4 жыл бұрын

    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.

  • @Adrian-ub7im
    @Adrian-ub7im6 жыл бұрын

    Thanks, learned something new 👍

  • @uraaxeecaqligaaga4890
    @uraaxeecaqligaaga48905 жыл бұрын

    I like you Mr synthpop you are the smartest.

  • @oliveray8996
    @oliveray8996 Жыл бұрын

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

  • @raisaoffice490
    @raisaoffice4906 жыл бұрын

    Thanks , Keep up the good work

  • @tumelo3703
    @tumelo37035 жыл бұрын

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

  • @user-lk8he7bb3b
    @user-lk8he7bb3b10 ай бұрын

    Very helpful video. Thankyou so much sir ❤

  • @alainlasquety5958
    @alainlasquety59583 жыл бұрын

    got it! thank you!

  • @southernbelle6564
    @southernbelle65648 ай бұрын

    Thank you! You are awesome!🙏

  • @wisdomarthur4653
    @wisdomarthur46532 жыл бұрын

    Great Tutorials

  • @Super_Judith
    @Super_Judith Жыл бұрын

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

  • @titserRider
    @titserRider3 жыл бұрын

    Thats a huge mouse pointer you got there!

  • @AndreaNobili84
    @AndreaNobili843 жыл бұрын

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

  • @elizabeth-tu7qz
    @elizabeth-tu7qz Жыл бұрын

    very very helpful!

  • @Hamza-yv6uy
    @Hamza-yv6uy3 жыл бұрын

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

  • @collinsnzuya999
    @collinsnzuya9999 ай бұрын

    thank you

  • @janethrodrigues4576
    @janethrodrigues45762 жыл бұрын

    What i great video exactly what i needed.

  • @salzebrahim9527
    @salzebrahim95272 жыл бұрын

    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!

  • @glisten_skin
    @glisten_skin2 ай бұрын

    Good as usual

  • @imanlam8829
    @imanlam88295 жыл бұрын

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

  • @danishiqubal4516
    @danishiqubal45163 жыл бұрын

    Thnx a lot

  • @emperoy8
    @emperoy86 жыл бұрын

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

  • @dineshbhagtani8030
    @dineshbhagtani80303 жыл бұрын

    Thanks

  • @mpmithun
    @mpmithun2 жыл бұрын

    Thanks sir

  • @charlesmiano2725
    @charlesmiano2725 Жыл бұрын

    All great

  • @ravindurukshan8765
    @ravindurukshan87652 жыл бұрын

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

  • @ibraklay9343
    @ibraklay93436 жыл бұрын

    👍🏼

  • @jaimevilaplana3691
    @jaimevilaplana36914 жыл бұрын

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

  • @nassimabed
    @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.

  • @michaelsmith1076
    @michaelsmith10762 жыл бұрын

    can you split columns

  • @eldonzeta
    @eldonzeta2 жыл бұрын

    this is different from Split text into column, right?

  • @trishnashrestha5649
    @trishnashrestha56495 ай бұрын

    can you provide the workbook

  • @herijust3824
    @herijust38243 жыл бұрын

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

  • @abbyboyone
    @abbyboyone Жыл бұрын

    DM#1

  • @iZacq
    @iZacq2 ай бұрын

    How to undo it ?

  • @cinephile9346
    @cinephile93463 жыл бұрын

    where is the file?

  • @godwinuche4669

    @godwinuche4669

    2 жыл бұрын

    Same thing I asked

  • @alias1180
    @alias11804 жыл бұрын

    Stop selling synthpop otherwise tq for the vid

  • @neilcargill1555
    @neilcargill15553 жыл бұрын

    thank you

Келесі