How to keep Row Headings at the Top when scrolling in Excel
This tutorial will demonstrate how to make the Top Row stay visible in Excel.
When you work with a large Excel worksheet, it's often difficult to remember exactly what kind of data, columns or rows contain once you begin scrolling around the sheet.
An easy way to do that is to freeze a row (or column), so it stays in a fixed location while the rest of the spreadsheet scrolls up and down (or side to side).
To keep the column headers viewing means to freeze the top row of the worksheet.
Enable the worksheet you need to keep column header viewing, and click View - Freeze Panes - Freeze Top Row.
Whenever you lock rows or columns, the Freeze Panes option turns into Unfreeze Panes for you to quickly unlock the row or column.
Now, when you scroll through the spreadsheet, the top row that was visible will remain fixed while the rest of the spreadsheet scrolls under it.
If you find this useful, please drop a 👍 on the video and subscribe 🥰
Timestamp:
00:00 Intro
00:12 The header doesn't freeze
00:52 Freeze the header
01:35 This is how you do it!
🔴 RECOMMENDED VIDEOS/PLAYLISTS
🎥 Financial functions: • 💰 Compound interest calculator templa...
🎥 Common errors: • 🚨 How to solve the #DIV/0! error in E...
🎥 How to tutorials: • How to use UPPER in Excel
🎥 Regular functions explained: • BASIC EXCEL FUNCTIONS
Feeling generous? I like coffee.🤗
☕ https://www.buymeacoffee.com/cogwheel