How to keep first column visible when scrolling in Excel

How to keep first column visible when scrolling
In this excel tutorial for beginners, I’ll show you how you can always keep the first column of your worksheet always visible even if you scroll. This is a simple tutorial yet very essential. If you have a long data set and with a lot of columns, whenever you scroll right the columns from the left becomes concealed. Let’s say you have employee name at the first column and the last column is country. But its important for you to check which employee is from which country. Now the best thing you can do is to freeze the first column and now if you scroll to the right the first column will still be visible.
I’ll be using freeze pane feature in this tutorial and let’s follow the simple steps below to learn how to freeze columns in excel.
Step 1: Click on the “View” Tab.
Step 2: Click on “Freeze Pane.”
Step 3: Click on “Freeze First Column.”
Done. This is how you keep first column visible in excel using freeze pane feature. Now no matter how much you scroll, the first column of your worksheet which is Column A will always be visible.
#Freeze #FirstColumn #Excel
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ
Here goes the most recent video of the channel:
bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Tutorial for Beginners: goo.gl/UDrDcA
Excel Case: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
All About Comments in Excel: bit.ly/excelcomments
Excel VBA Programming Course: bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial
Quora: bit.ly/3bxB8JG

[@aarontaylor6464]

Genius!
Thank you, after watching umpteenth videos. You answered my two day long search in less than a minute.

[@Excel10tutorial]

Glad I could help! Please subscribe and share.

[@mioortiz8225]

Thank you very much. This is exactly what I wanted. So helpful 😊

[@Excel10tutorial]

I'm so glad! Please subscribe and be with us

[@GardeBlaze]

Thank you! This is exactly what I had been trying to do!

[@Excel10tutorial]

You're most welcome! Please subscribe and be with us.

[@Zoli0329]

Thank you so much!

[@Excel10tutorial]

You're welcome!

[@nimascolari1508]

Useful and concise. Great video.

[@Excel10tutorial]

Glad you enjoyed it! Please subscribe and be with us.

[@jennayers1]

So helpful, thank you!

[@Excel10tutorial]

Glad it was helpful!

[@pearl.6574]

thank you so much. Easy to understand and useful

[@Excel10tutorial]

You are welcome!

[@amjadnaveed8979]

Thanks, bro...
Excellent...just to the point.

[@Excel10tutorial]

Glad it helped. Please subscribe and be with us

[@ORiordanJennifer17]

Super helpful! thanks ❤️

[@Excel10tutorial]

You're most welcome. Please subscribe and be with us.

[@kenethwepondi4181]

You are spot on. Thanks.

[@Excel10tutorial]

You are most welcome. Please subscribe and be with us.

[@tooks357]

Thank you, been looking for this

[@Excel10tutorial]

Enjoy it

[@michelledonati3816]

Thanks! I new that feature was available, but forgot where and what it was called. Very helpful.

[@Excel10tutorial]

I'm glad you like it.

[@aloukikam.shrestha7614]

Thanks for the video! It helped!

[@Excel10tutorial]

Glad to hear it!

[@mariameier7044]

Thank you! This had been bugging me for so long!

[@Excel10tutorial]

Glad I could help!

[@djr12345678910]

Thank you very much. God Bless

[@Excel10tutorial]

You're welcome.

[@KapimirTube]

That is so simple. TYSM

[@Excel10tutorial]

You're welcome!

[@kumclintontv]

Thank you, this was helpful

[@Excel10tutorial]

Glad it was helpful! Please subscribe and share

[@shoebkhan5558]

Thank you so much for making like this videos

[@Excel10tutorial]

You're most welcome. Please subscribe and be with us.

[@nasibhasanov7905]

Thank you!!!

[@Excel10tutorial]

You're most welcome! Please subscribe and be with us.

[@santiagocarreno5881]

Thank yOU!!!

[@Excel10tutorial]

You're most welcome. Please subscribe and share.

[@Alexdr28]

Nos has salvado, estamos agradecidos. - Toy Story 1

[@Excel10tutorial]

Gracias

[@flujensiosserwanji6624]

Thank you so much😍😍😍

[@Excel10tutorial]

Always welcome. Please subscribe and be with us.

[@itdepartment7678]

THANK'S BUDY😍

[@Excel10tutorial]

You're welcome.

[@dureshahwarmisbah8779]

Thank you.

[@Excel10tutorial]

You're welcome.

[@ahmedmahmoudnasrhassan2989]

Thanks ❤

[@Excel10tutorial]

You're welcome 😊 Please subscribe and be with us.

[@user-kv6yn2rm2r]

hey!! thank you for helping with this hack bro

[@Excel10tutorial]

Any time

[@BaekDojka]

Thank you

[@Excel10tutorial]

You're most welcome. Please subscribe and be with us.

[@Mayurbhagat123]

Thanks bro 😎

[@Excel10tutorial]

Most welcome. Please subscribe.

[@vishwanathp1857]

Tnk u bro

[@Excel10tutorial]

You're most welcome. Please subscribe and be with us.

[@nadinesrecipes]

thanks

[@Excel10tutorial]

You're welcome!

[@karthicka3184]

Thank you so much ❤️

[@Excel10tutorial]

You’re welcome 😊

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

[@Excel10tutorial]

Unfortunately not

[@EmmanuelOnitheoneandoni]

What if I want to freeze more than the first coloum??

[@Excel10tutorial]

Try this: ruclips.net/video/TNR_onNAYpo/видео.html