How to Keep Row and Column Labels in View When Scrolling a Worksheet

This is Part 1 in a series of Tutorials focused on the commands of the VIEW Tab of the Ribbon in Excel 2007 and Excel 2010. These same commands and tips will work for all versions of Excel.
I demonstrate how to use the Freeze Panes Commands to Freeze either the Top Row Labels, the First Column Labels or Both.
When you want to freeze more Rows or More Labels, use the Split Bar Commands. Using Split Bars give you addition, independent Navigational Scroll Bars so that you can focus on a specific part of your worksheet.
I invite you to visit my secure online shopping website - shop.thecompany... - to view all of the resources that I offer.
Danny Rocks
The Company Rocks

[@jinggles5507]

Eight years later and your video continues to help others. Thank you so much , you have a new sub

[@davidjaneski5896]

5:25 Freeze column and row both.

[@KellyTaylorCards]

God Bless You.

[@Hernanqwerty]

Thank you... no need to drag the video that much 🤷🏻‍♂️

[@chasingpowder200]

Thank you, this video changed my life. My marriage has never been better, my children started respecting me, and I became independently wealthy and no longer have to work. I also learned how to freeze the first column on an excel spreadsheet.

[@krisbakerco]

Yes! I'm so relieved now. It's been a while since I took a class on Excel. Now it's so easy to see my personal and business books. Thank you!

[@lafemmefatalle]

Thanks. At first I was a bit bored. I then remembered that I wanted only 1 specific thing and had to wait patiently until you got to what I needed. This is actually BRILLIANT!!! Very well explained. Thanks!!!

[@JL-by4xu]

Thank you, quick easy and to the point, took three videos before I found yours that explained exactly what I was trying to do.

[@leepinnguin9682]

Wonderful, thank you!!! I just could not remember, this was a big help. You made an old man happy today.

[@taipan185]

Over 8 years after this video was posted and its still useful as hell. Thanks :)

[@avig144]

You really helped me today - God Bless! You're information is very good and well delivered!

[@mydeargracievideos]

for YEARS i've tried to figure this out by reading online .. thank you!!

[@TheeMcDonger]

you are a genius sir. I would never have figured that out in 1,000,000 years

[@MultiRamesh10]

Thank you Danny.....even small kids can understand the way you explained. Well done

[@technova98]

I never expected I could find this video easily. actually I searched " column forwarded to an excel sheet" : ) I know I am dump but it worked

[@DannyRocksExcels]

@littlepitt2000 Thank you for your kind words. I am pleased that you enjoy my tutorials. Danny Rocks The Company Rocks

[@timprangley6907]

Thank you, thank you, thank you... I have been trying to figure this out for a long time. Each time I would give up within minutes, but you do a wonderful job in your video.

[@user-bc4sx5fl6k]

quick no nonsense explanation

[@DannyRocksExcels]

@sharpnmild My pleasure. I am glad that you enjoyed my tutorial. Thanks for adding your comment. Danny Rocks The Company Rocks

[@cainabel6356]

Thank you. I was trying to remember how to do these things for a simple solution to see the 1 column and so forth when scrolling left.

[@SEXISTEPH79]

Omg thank you. Feel so stupid that I didn't know this. Thank you for making it simple

[@nusaiba3832]

Thank you so much...you save my times and energy :)

[@pauls7056]

Brilliant. For some reason I was finding I could freeze a row OR a column. But the answer was just to place the cursor in the second row down, freeze pane and bingo - it worked. Thanks for your help.

[@kagayakuangel5828]

You have frozen my work pains. 😂🤣 Thank you! :)

[@studylink9218]

thanks danny , stay blessed

[@DannyRocksExcels]

@tauqeerrizvi Thanks! I am pleased that you like this video tip! Danny Rocks The Company Rocks

[@katrinadeal-mccall2065]

This video is very HELPFUL!!! Thank you!

[@monkeemash]

Thank you thank you thank you!!! Before finding this video about freezing, figuring this out was a pain! :P

[@Ricks2Cents]

Thank you that was a Big Help!!!

[@stephend]

I never understood the 'based on current selection' option - until now! Thanks!

[@y_p7]

thank you man!! saved lots of my time

[@jamessalman2445]

Thank you very much. I was confused but now you solved the problem. Thanks.

[@nhi7a2]

Thank you. I've been searching for it everywhere. Very useful

[@Belgarath117]

Thanks for this, I always forget how to do this when I need to.

[@Queue.]

Thanks for this! Info everyone is looking for around 2:16

[@relicfrombc]

You rock Danny! Thanks so much; it worked the first time.

[@zj9928]

VERY NICE TUTORIAL VIDEO,THANK YOU

[@helpfuljinx]

Amazing information. Thank you. I just needed a quick refresh. I haven't used excel in a few years and it has changed quite a bit.

[@Lana-kk5vh]

Thank you Danny for the wonderful tips. I'll visit your website for more tips 😃👍.

[@iwarucilu]

Thanks, this really helps me out. Appreciated.

[@moon512ify]

This is just I wanted to know . Very useful tips. thank you very much, sir.

[@sant1811]

finally I found the split command!! after office remove the shortcut from the side thank u so much!

[@phalasambath5266]

Thank you so much for this advised . have a nice day

[@shantanukanaskar1996]

Thank you very much. I got the thing which I came here for.

[@auindrilabiswas4127]

Thank you so much! Very helpful

[@littlepitt2000]

Thanks Danny. Your tutorials are always so helpful. I always look forward to them!

[@damirpavlic4110]

Thanks for this very useful video. Helped so much.

[@invsg5072]

Just what I wanted to learn, thanks😄

[@sweetdreamsound8708]

What a great class that would have cost me lots of money to learn, I got it for free, now am going to subscribe to your channel for more classes, thanks for sharing this.

[@corlissasouther5368]

TTu que se ttytttttt

[@corlissasouther5368]

F tf f ft

[@corlissasouther5368]

Cy

[@corlissasouther5368]

Cy

[@FatherBenjamin]

Very helpful. thank you so much God bless you

[@davehead4927]

overly explained but very helpful , Thank you !!

[@casaniaintl]

good explanation, thanks!

[@erraasmuni]

Thanks Danny..Clear and helpful..

[@melissagrimes5736]

Thank you for a wonderful lesson! So very helpful

[@Batijko]

That is such a nice clip. Thank you very much.

[@Sk-bu6ey]

Thank you Danny Rocks

[@PrakashJ]

Thanks Danny, this video really helped.

[@lovinglifegal]

THank you -- this helped me so much!

[@CookieZ3353]

great tutorial. wish you were teaching me photo shop instead of my current on-line instructor!

[@arcy9448]

Thank you so much sir. This is very helpful to me.

[@sakthinava57]

Thanks a lot for this very useful video

[@tauqeerrizvi]

Very usefull option, thanks Danny

[@SuperGogi88]

Thank you sir... You helped me out.

[@aliz5338]

Very informative video thanks.

[@lawo3917]

Omg this is so smart thank you

[@brightonline_eduhelp]

Thank you very plenty sir for sharing this.

[@rigelfish3378]

THANKS A BUNCH!

[@joyprincy7195]

Super ... Very nice sharing..

[@sankhulani]

Great video!!💗👏

[@Leo-pentos]

Thank you very much 😀

[@douglasjacobs4463]

Thanks for the help

[@salemmohammed8341]

Thank you Danny, it really helped .

[@taraheels2579]

Very helpful. Thanks

[@anaffe71]

Thank you for the very helpful tips

[@drewswizzle4413]

You da man! So helpful

[@tusharnaik4710]

Thanks useful information

[@mjm990]

thanks! it worked.

[@syoung7911]

Thank you! Great tip--well explained!

[@SatnamSingh-pj6eh]

very fruitful for me thanx

[@prosperesin]

Legend 👏🏾👏🏾👏🏾

[@komalwaghmare8195]

Thank you Sir, for sach Great Advice.

[@kimyuung]

Thank you!

[@Shivgsedu]

Thank you veryy muchhh sir...

[@neppoliyansou5354]

very useful to my docs in excel....

[@yashmadlani3854]

Thank you sir....

[@balamurugesh]

Thank you! Mr. Danny Rocks for your Information Keep rocking

[@tylerdignan8135]

Thank-you!

[@H2O_Atlanta]

6:20 - freeze multiple rows and columns

[@simonntebalengtsamago3479]

Thank you very much

[@a2zap]

Thanks Danny

[@erwinbernales1723]

thank you sir...great tips. keep it up.

[@butak30]

Thank you very much Sir.

[@miroslavnerandzic5439]

Thank you.

[@tahamaqsood8531]

Thanks dude

[@MrX3room]

Thx so much!

[@FarhanAli-kb2qx]

Thank you very much,

[@jinalpatel9427]

Thank you very much my problem is solved

[@marymuas]

Amazing!!!Thank you

[@shripujasiddamsetty]

Love you thanks

[@suzychannel7035]

Thank you so much.

[@jyothisuresha]

Thank you

[@rroge5]

this was extremely helpfull to me for the purpose of doing my income and ammount to settle with my taxi operator and for taxes... i am using the smartphone app but everything is in the same spot its just not the same gui.