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
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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies