The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% Kutools for Excel, with more than 300 handy functions, makes your jobs more easier.
If you want to keep all first rows visible across multiple worksheets, you can use Freeze panes multiple worksheets utility of Kutools for Excel. Tip: If you want to cancel the freezing, click View > Freeze Panes > Unfreeze Panes. Now the first row has been frozen in active worksheet, and it will keep the first row being viewed. In Excel, you can go to Freeze Panes to freeze first row.Īctive the worksheet you want to keep its first row, and then click View > Freeze Panes > Freeze Top Row. Keep 1st row visible with Kutools for Excel Here I introduce the quick tricks to freeze the first row which can keep it to be viewed all the time in Excel. If you have a long data with multiple columns in a worksheet, and you may want to keep first row always visible when you scroll down to view the data. How to keep first row always visible in Excel?