Keep top row pinned to top?

%3CLINGO-SUB%20id%3D%22lingo-sub-860003%22%20slang%3D%22en-US%22%3EKeep%20top%20row%20pinned%20to%20top%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-860003%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20keep%20the%20top%20row%2C%20my%20column%20labels%2C%20pinned%20to%20the%20top%20of%20my%20spreadsheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-860003%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-860187%22%20slang%3D%22en-US%22%3ERe%3A%20Keep%20top%20row%20pinned%20to%20top%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-860187%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F410635%22%20target%3D%22_blank%22%3E%40ks0010%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20do%20that%2C%20go%20to%20the%20View%20Tab%20--%26gt%3B%20Freeze%20Panes%20--%26gt%3B%20Expand%20it%20and%20choose%20Freeze%20Top%20Row.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132287iCD9EA271490066E8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Freeze%20Top%20Row.jpg%22%20title%3D%22Freeze%20Top%20Row.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-860525%22%20slang%3D%22en-US%22%3ERe%3A%20Keep%20top%20row%20pinned%20to%20top%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-860525%22%20slang%3D%22en-US%22%3EThanks!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-860660%22%20slang%3D%22en-US%22%3ERe%3A%20Keep%20top%20row%20pinned%20to%20top%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-860660%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F410635%22%20target%3D%22_blank%22%3E%40ks0010%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20welcome!%3C%2FP%3E%3CP%3EYou%20may%20now%20mark%20your%20question%20as%20Solved%20by%20accepting%20the%20post%20which%20resolved%20it%20as%20a%20Best%20Answer%2FResponse.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-860907%22%20slang%3D%22en-US%22%3ERe%3A%20Keep%20top%20row%20pinned%20to%20top%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-860907%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20can%20also%20use%20%22Insert%22--%26gt%3B%20%22Table%22%20to%20the%20desired%20range%20so%20that%20the%20headers%20will%20be%20shown%20as%20column%20names%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861013%22%20slang%3D%22en-US%22%3ERe%3A%20Keep%20top%20row%20pinned%20to%20top%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861013%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F232473%22%20target%3D%22_blank%22%3E%40erol%20sinan%20zorlu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20mean%2C%20converting%20a%20range%20into%20an%20Excel%20Table%20freezes%20the%20header%20row%20and%20remains%20visible%20when%20you%20scroll%20down%20the%20page%3F%20Did%20you%20try%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861070%22%20slang%3D%22en-US%22%3ERe%3A%20Keep%20top%20row%20pinned%20to%20top%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861070%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyes%2C%20if%20you%20click%20on%20any%20cell%20in%20the%20table%20the%20headers%20will%20be%20visible%20as%20column%20names.%20see%20the%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861204%22%20slang%3D%22en-US%22%3ERe%3A%20Keep%20top%20row%20pinned%20to%20top%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861204%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F232473%22%20target%3D%22_blank%22%3E%40erol%20sinan%20zorlu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20see%20now%20what%20you%20were%20talking%20about.%3C%2FP%3E%3CP%3EYes%2C%20that%20can%20also%20be%20an%20approach%20provided%20user%20is%20willing%20to%20convert%20the%20data%20into%20an%20Excel%20Table.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

How do I keep the top row, my column labels, pinned to the top of my spreadsheet?

7 Replies
Highlighted

@ks0010 

To do that, go to the View Tab --> Freeze Panes --> Expand it and choose Freeze Top Row.

Freeze Top Row.jpg

Highlighted
Thanks!
Highlighted

@ks0010 

You're welcome!

You may now mark your question as Solved by accepting the post which resolved it as a Best Answer/Response.

Highlighted

@Subodh_Tiwari_sktneer 

 

you can also use "Insert"--> "Table" to the desired range so that the headers will be shown as column names

Highlighted

@erol sinan zorlu 

Do you mean, converting a range into an Excel Table freezes the header row and remains visible when you scroll down the page? Did you try that?

Highlighted

@Subodh_Tiwari_sktneer 

 

yes, if you click on any cell in the table the headers will be visible as column names. see the attached file.

Highlighted

@erol sinan zorlu 

I see now what you were talking about.

Yes, that can also be an approach provided user is willing to convert the data into an Excel Table.