.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!
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 😍😍😍
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.
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. 💙
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.
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.
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!
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!
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.
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
hahaha
hahah that's one of the best ways to do so
.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!
Split is confusing i prefer the freeze Paine
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 😍😍😍
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.
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. 💙
Thanks sir, im a big fan and you make excel so easy for me. From Nigeria
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.
This was so much help, love from India 🤗
I really enjoyed it .Your a good teacher.
thank you it's helpful and so easy
thank u again.
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.
Thanks a lot your videos have really been helpful 👍
You're a good teacher
Very helpful video. Thankyou so much sir ❤
I like you Mr synthpop you are the smartest.
Thank you! You are awesome!🙏
Thank you for the most useful tutorials
Thank you 🙏🙏🙏🙏
Great tutorial! Maybe you should explain how split defers from freeze panes if it does.
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 🤗🤗🤗🤗
Thanks , Keep up the good work
Than for the tutorial !!! And great music collection...Ulver are for true expert ;-)
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!
Great Tutorials
Great info. Thanks for posting.
very very helpful!
that dude who disliked this did it because he/ she wanted to be the first to do so lol
Good as usual
Thank you once again. Your videos are very helpful.
Please do you also have tutorials on Ms word and power point?
What i great video exactly what i needed.
Thanks, learned something new 👍
Wow I didn't even know about that function thanks man the good work...
got it! thank you!
thank u so much
can we able to print the data using split. like you said i need to get the data on ''z row''
Thank you for this enriching sharing , is it possible that this split can be independent ? One completes the other without having duplications.
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!
Please can I get more of your videos on excel
Yes, please. If you go to my channel homepage, there are many playlists about Excel for you to explore.
Thanks sir
thank you
All great
Thanks
Thnx a lot
Great Job. Do you have any tutorial on Google Certificate Level 2?
can you provide the workbook
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.
this is different from Split text into column, right?
hi everyone , where are information these columns? thanks !!
can you split columns
How to undo it ?
Kindly allow to use your patron from all over the world. I hope you got what I mean
DM#1
👍🏼
where is the file?
Same thing I asked
Stop selling synthpop otherwise tq for the vid
thank you