💻 Software
Fixing the first row as sortable title in Excel 2007
Fresh7 days ago
Mar 15, 202652268 viewsConfidence Score0%
0%
Problem
I know this is super easy, I just couldn't find it. I'd like the first row in an excel document to be the "title" field. I want that: Whenever I scroll down, this row will remain fixed I can sort and filter according to the different columns. How do I accomplish that?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Fixing the first row as sortable title in Excel 2007
Low Risk
To fix the first row select it and then select "Freeze Panes" from the "View" ribbon. To get sorting and filtering select the first row and then "Filter" from the "Data" ribbon.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix