Freeze Panes In Excel Column And Row
Freeze Panes In Excel Column And Row
Hello Viewer in this video I have shown How to Freeze Rows and Columns in Excel
Learn how to freeze rows and columns in Excel
When you're working with a lot of spreadsheet data on your laptop, keeping track of everything can be difficult. It's one thing to compare one or two rows of information when dealing with a small subset of data, but when a dozen rows are involved, things get unwieldy. And we haven't even started talking about columns yet. When your spreadsheets become unmanageable, there's only one solution: freeze the rows and columns.
Freezing rows and columns in Excel makes navigating your spreadsheet much easier. When done correctly, the chosen panes are locked in place; this means those specific rows are always visible, no matter how far you scroll down. More often than not, you'll only freeze a couple of rows or a column, but Excel doesn't limit how many of either you can freeze, which can come in handy for larger sheets.
This how-to works with Microsoft Excel 2016 as well as later versions. However, the this method also works with Google Sheets, OpenOffice and LibreOffice. Ready to get to work? Here's how to freeze rows and columns in Excel
How to freeze a row in Excel
1. Select the row right below the row or rows you want to freeze. If you want to freeze columns, select the cell immediately to the right of the column you want to freeze. In this example, we want to freeze rows 1 to 5, so we've selected row 6
2. Go to the View tab. This is located at the very top, inbetween "Review" and "Add-ins."
3. Select the Freeze Panes option and click "Freeze Panes." This selection can be found in the same place where "New Window" and "Arrange All" are located.
That's all there is to it. As you can see in our example, the frozen rows will stay visible when you scroll down. You can tell where the rows were frozen by the green line dividing the frozen rows and the rows below them.
If you want to unfreeze the rows, go back to the Freeze Panes command and choose "Unfreeze Panes".
Note that under the Freeze Panes command, you can also choose "Freeze Top Row," which will freeze the top row that's visible (and any others above it) or "Freeze First Column," which will keep the leftmost column visible when you scroll horizontally.
Besides allowing you to compare different rows in a long spreadsheet, the freeze panes feature lets you keep important information, such as table headings, always in view.
----------------------------------------------------------------------------------------------------------------------------------------
Subscribe: | 🔔Make sure to enable ALL push notifications 🔔
---------------------------------------------------------------------------------------------------------------------------
Watch our latest video= Brain Up
_____________/Connect With Me On Social Media\____________ ►
Facebook:➜ / ►
or Business Queries:[email protected]
-----------------------------------------------------------------------------------------------------------------------
🎬 Production Credits
✍️ Edited by: @brainup
📷 Filmed by: @brainup
💡 Produced by: @brainup
ℹ️ Video Title: Freeze Panes In Excel Column And Row
-----------------------------------------------------------------------------------------------------------------------
Join Fiverr Now- https://www.fiverr.com/s2/7655628794
Download Sky Email Extractor-- https://bit.ly/2WguUvk
Tubebuddy- https://www.tubebuddy.com/brainup
Vidiq- https://vidiq.com/brainup
Grammerly- https://grammarly.com/?q=spelling
---------------------------------------------------------------------------------------------------------------------
▶️ Other Similar Content:
Fiverr Series- https://www.youtube.com/playlist?list...
Fiverr Free Tools-https://www.youtube.com/playlist?list...
Playlist- https://www.youtube.com/channel/UCSbq...
Web Scraping- https://www.youtube.com/playlist?list...
Email Collection- https://www.youtube.com/playlist?list...
I Earned $30 on Fiverr - https://www.youtube.com/watch?v=W-bWH...
I Earn $50 Easily on Fiverr - https://www.youtube.com/watch?v=Xalt-...
Secret Method to Earn Money from Linkedin- https://www.youtube.com/watch?v=f8vIe...
---------------------------------------------------------------------------------------------------------------------------
📜 About Brain Up
My Name is Mukesh and I am From India. I mostly create videos related to online earning. I am a Level 2 seller on Fiverr. Basically, I created this channel to share my knowledge as much as I know I like to share with my viewers so that they as can apply the tips and tricks and make money online in some of the freelancing websites like Fiverr, Upwork, Guru. etc. I hope I am been helpful to my viewers and I would like to share more in the upcoming days with more interesting videos.
#freezeExcelColumnAndRow #freezeExcelrowAndColumn #FreezePanesInExcelColumnAndRow
Watch video Freeze Panes In Excel Column And Row online without registration, duration hours minute second in high quality. This video was added by user Brain Up 26 June 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,466 once and liked it 40 people.