Home

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
ks0010
New Contributor

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

7 Replies

@ks0010 

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

Freeze Top Row.jpg

Thanks!

@ks0010 

You're welcome!

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

@Subodh_Tiwari_sktneer 

 

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

@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?

@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.

@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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies