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.thecompanyrocks.com - to view all of the resources that I offer.
Danny Rocks
The Company Rocks

[@davidjaneski5896]

5:25 Freeze column and row both.

[@KellyTaylorCards]

God Bless You.

[@Hernanqwerty]

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

[@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!

[@jinggles5507]

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

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

[@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!!!

[@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 :)

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

[@MultiRamesh10]

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

[@littlepitt2000]

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

[@DannyRocksExcels]

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

[@monkeemash]

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

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

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

[@DannyRocksExcels]

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

[@avig144]

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

[@TheeMcDonger]

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

[@sant1811]

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

[@DannyRocksExcels]

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

[@nhi7a2]

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

[@relicfrombc]

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

[@mydeargracievideos]

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

[@jamessalman2445]

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

[@moon512ify]

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

[@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

[@iwarucilu]

Thanks, this really helps me out. Appreciated.

[@stephend]

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

[@nusaiba3832]

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

[@user-bc4sx5fl6k]

quick no nonsense explanation

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

[@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 😃👍.

[@kagayakuangel5828]

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

[@melissagrimes5736]

Thank you for a wonderful lesson! So very helpful

[@lovinglifegal]

THank you -- this helped me so much!

[@katrinadeal-mccall2065]

This video is very HELPFUL!!! Thank you!

[@studylink9218]

thanks danny , stay blessed

[@PrakashJ]

Thanks Danny, this video really helped.

[@damirpavlic4110]

Thanks for this very useful video. Helped so much.

[@y_p7]

thank you man!! saved lots of my time

[@salemmohammed8341]

Thank you Danny, it really helped .

[@SEXISTEPH79]

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

[@haniefsatria8124]

Thank you for the information, much appreciated

[@arcy9448]

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

[@Belgarath117]

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

[@marcosramos2490]

Hi, thanks for the video! I just have a question. Is it possible to freeze the top cell of a certain column but only for a number of rows?
For example, I want the G1 cell to remain visible for the first 500 rows, then freeze G501... and so on every 500 rows. Thanks a lot!... BTW, I use office 2007 and 2016.

[@erraasmuni]

Thanks Danny..Clear and helpful..

[@Batijko]

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

[@anaffe71]

Thank you for the very helpful tips

[@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

[@invsg5072]

Just what I wanted to learn, thanks😄

[@geitomusic5558]

extremely helpful thank you!!!

[@CookieZ3353]

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

[@myvcv6641]

Thank you so much!! Was very helpful!!

[@Queue.]

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

[@auindrilabiswas4127]

Thank you so much! Very helpful

[@FatherBenjamin]

Very helpful. thank you so much God bless you

[@zj9928]

VERY NICE TUTORIAL VIDEO,THANK YOU

[@manojchaudharysaaka4389]

thanks & how to set up formula for calculate automatically in excel ?

[@phalasambath5266]

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

[@komalwaghmare8195]

Thank you Sir, for sach Great Advice.

[@Ricks2Cents]

Thank you that was a Big Help!!!

[@hafiznazirahmad1965]

nice bundle of thanks

[@SuperGogi88]

Thank you sir... You helped me out.

[@tauqeerrizvi]

Very usefull option, thanks Danny

[@boshja]

Very helpful 👍 thank you !

[@frankmoyer8151]

Is there a way to move the Column numbers 1,2,3, etc down so it aligns properly with the first data cell like a name or date

[@syoung7911]

Thank you! Great tip--well explained!

[@casaniaintl]

good explanation, thanks!

[@erwinbernales1723]

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

[@sakthinava57]

Thanks a lot for this very useful video

[@aliz5338]

Very informative video thanks.

[@Sk-bu6ey]

Thank you Danny Rocks

[@brightonline_eduhelp]

Thank you very plenty sir for sharing this.

[@butak30]

Thank you very much Sir.

[@sankhulani]

Great video!!💗👏

[@marymuas]

Amazing!!!Thank you

[@AnnieAtRecess]

You DO rock!

[@gemechistamiru9906]

thank you very much great job

[@taraheels2579]

Very helpful. Thanks

[@mjm990]

thanks! it worked.

[@drewswizzle4413]

You da man! So helpful

[@shantanukanaskar1996]

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

[@douglasjacobs4463]

Thanks for the help

[@davehead4927]

overly explained but very helpful , Thank you !!

[@susansorongonabug5103]

great job. i,ll practice it.

[@Leo-pentos]

Thank you very much 😀

[@lawo3917]

Omg this is so smart thank you

[@carmalone91]

Thank you good sir :)

[@aducaale328]

Thank you... Mahadsanid

[@H2O_Atlanta]

6:20 - freeze multiple rows and columns

[@tusharnaik4710]

Thanks useful information

[@suzychannel7035]

Thank you so much.

[@skybox-101]

I know how to freeze the top row but when I try to filter column the top row also filters.Any tips?

[@joyprincy7195]

Super ... Very nice sharing..

[@SatnamSingh-pj6eh]

very fruitful for me thanx

[@hanafida179]

thank you so much :)

[@a2zap]

Thanks Danny

[@prosperesin]

Legend 👏🏾👏🏾👏🏾

[@pandey78413]

thanks Really helpfull...