How to make freeze columns or rows | Excel Tips and Tricks #13
Join this channel to get access to perks:
https://www.youtube.com/channel/UC3XH...
#ExcelForBeginners #ExcelTipsAndTricks #ExcelTutorials2020
Hello my friend today I going to show you How to make freeze row or column, If you not understand or need more video please drop comment below, I'll make the video for you. I hope my video tutorials is can help you, Please like and subscribe to get new video. Thank you for watching.
This is introduction : How to make freeze row or column
Freeze rows or columns
To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
Freeze the first column
1- Select View
2- Freeze Panes
3- Freeze First Column.
The faint line that appears between Column A and B shows that the first column is frozen.
Freeze the first two columns
1- Select the third column.
2- Select View
3- Freeze Panes
4- Freeze Panes.
Freeze columns and rows
Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
1- Select View
2- Freeze Panes
3- Freeze Panes.
Unfreeze rows or columns
1- On the View tab
2- Window
3- Unfreeze Panes.
For more information about technology, software download, computer tip, game, video tutorial and Hollywood movies. Please go to my blog : https://bigboxsoftware.blogspot.com/ or https://bigboxsoftware.net/
Check out my previous video :
- How to Join and Separate text in difference column | Excel Tips and Tricks #12 : https://youtu.be/g-IukC3pF-0
- How to Highlight Auto the Active Row and Column in a Data Range | Excel Tips and Tricks #11: https://youtu.be/KPkYWsNnznM
- How to create Bar Code in excel | Excel Tips and Tricks #10 : https://youtu.be/zQgq0PJKHtA
- How to turn off Protected View in Excel | Excel Tips and Tricks #09 : https://youtu.be/qXcPM7j51Tw
- How to insert pages number in excel | Excel Tips and Tricks #08 : https://youtu.be/WWtjeiL51NQ
Check out my popular playlist :
- Excel tutorials 2020 : https://www.youtube.com/playlist?list...
- Blogger tips and tricks : https://www.youtube.com/playlist?list...
- Google Form : https://www.youtube.com/playlist?list...
- General Knowledge: https://www.youtube.com/playlist?list...
- Technology tips and tricks: https://www.youtube.com/playlist?list...
- Game : https://www.youtube.com/playlist?list...
Computer tips and tricks : https://www.youtube.com/playlist?list...
If you would like to know something about computer tips track, Please drop comment below I will make video to reply you. Also do not forget to subscribe my channel to get new tips about computer, mac, phone, game, app … My channel is creating video refer to technology and video tutorial about computer for you upper 2 video a week.
Thank you for your time, And hope all my video is helpful for you, Have a nice day !
