You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen data leaving the screen.
You can easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to unhide all hidden cells.
In the top menu of Excel select Data > Get Data > From File > From PDF. Browse your files and select the PDF with the table in it. Now select Import. Choose the table from the list that appears and ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results