Freeze Panes in Excel, so Rows and Columns Always Remain Visible!
If you need to see the top row of an Excel spreadsheet while viewing the bottom rows at the same time, then you need to Freeze Panes. In this video, I demonstrate how to freeze the top row, the first column, and any area in between! If you use Excel, then knowing how to Freezing Panes is a must-have skill. It’s so easy to do, yet so powerful!
I have a series of Excel spreadsheet tutorials posted on my channel. I post new videos periodically, so subscribe to my channel to become an Excel aficionado. Once you learn more about Excel, you’ll be hooked! I promise you! Here's a link to the tutorial playlist: bit.ly/3usMvMl
#FrankMLoSchiavo #ExcelAficionado
The Frank Show Starring Frank M. LoSchiavo features educational videos packed with lots of great information! Like an old-fashioned general store, my channel has something for everybody. Many of my videos feature lectures on statistics and psychology, but there are bonus videos on a variety of other topics, so subscribe today and join the fun!
SUBSCRIBE: / frankmloschiavo
MY FACULTY WEBPAGE: bit.ly/faculty-webpage-FML
MY GOOGLE SCHOLAR PROFILE: bit.ly/google-scholar-FML
SUPPORT MY CHANNEL: If you find my videos helpful, please like them, share them, and tell all your friends to check out my channel!
* CONSIDER A VENMO DONATION: @Frank-M-LoSchiavo
* CONSIDER A PAYPAL DONATION: bit.ly/paypal-FML
Пікірлер: 4
What about freezing a row or two on the bottom as well as the top?
@FrankMLoSchiavo
2 жыл бұрын
Great question. I don't know of a specific Excel option for freezing BOTH the top and bottom row at the same time. That said, if you google it, you'll find some workarounds that are effective. For example, you can open the same sheet twice, arrange the two windows horizontally, and then freeze the top rows in the top window and the bottom rows in the bottom window. Another option is to create a table for your data, and then in the VIEW menu use the SPLIT option to freeze the bottom rows. So, you have some options.
Nothing new
@FrankMLoSchiavo
Жыл бұрын
Well, duh. But many people want to freeze panes in Excel and don't know how. This video helps those people. That's my goal...to help people :)