Title Row that moves with the page

%3CLINGO-SUB%20id%3D%22lingo-sub-1100794%22%20slang%3D%22en-US%22%3ETitle%20Row%20that%20moves%20with%20the%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1100794%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20a%20a%20row%20at%20the%20top%20of%20the%20page%2C%20with%20about%2010%20different%20columns.%20I%20enter%20data%20every%20day%2C%20so%20the%20column%20gets%20longer%20and%20longer.%20But%20then%20I%20can%20not%20see%20the%20title%20to%20each%20column%20and%20have%20to%20scroll%20back%20to%20the%20top%20%2C%20check%20the%20title%20and%20then%20scroll%20all%20the%20way%20to%20the%20bottom%20of%20the%20page%20to%20enter%20the%20data.%3CBR%20%2F%3EIs%20there%20a%20way%20I%20can%20get%20the%20title%20to%20stay%20in%20view%20on%20the%20page%3F%20regardless%20to%20where%20on%20the%20column%20I%20am.%3CBR%20%2F%3EIf%20so%20how%20do%20I%20do%20it%20please.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1100794%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-1100809%22%20slang%3D%22en-US%22%3ERe%3A%20Title%20Row%20that%20moves%20with%20the%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1100809%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F513135%22%20target%3D%22_blank%22%3E%40Plenty11%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EClick%20just%20under%20the%20heading%20and%20then%20choose%20Freeze%20Panes%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164682i94EA7E1F4F3E48A8%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EHope%20that%20helps%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EWyn%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EMVP%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EAustralia%20(UTC%20%2B%20%3CLI-EMOJI%20id%3D%22lia_smiling-face-with-sunglasses%22%20title%3D%22%3Asmiling_face_with_sunglasses%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CSPAN%20style%3D%22font-style%3A%20italic%3B%22%3EIf%20this%20answer%20was%20the%20best%20response%20please%20click%20the%20button%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CSPAN%20style%3D%22font-style%3A%20italic%3B%22%3EI%20also%20happily%20accept%20likes%20%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1100813%22%20slang%3D%22en-US%22%3ERe%3A%20Title%20Row%20that%20moves%20with%20the%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1100813%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F513135%22%20target%3D%22_blank%22%3E%40Plenty11%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnother%20option%20is%20to%20turn%20your%20data%20into%20a%20Table%20by%20higlighting%20it%20all%20and%20pressing%20Ctrl%20T%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThen%20you%20can%20always%20see%20what%20column%20your%20in%2C%20and%20your%20table%20automatically%20gets%20longer%20as%20you%20type%20underneath%20it%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164683iC1A3A4C839B598BF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hi,

I have a a row at the top of the page, with about 10 different columns. I enter data every day, so the column gets longer and longer. But then I can not see the title to each column and have to scroll back to the top , check the title and then scroll all the way to the bottom of the page to enter the data.
Is there a way I can get the title to stay in view on the page? regardless to where on the column I am.
If so how do I do it please.
2 Replies

@Plenty11 

 

Click just under the heading and then choose Freeze Panes

 

clipboard_image_0.png

 

Hope that helps

 

Wyn

MVP

Australia (UTC +

 

If this answer was the best response please click the button

I also happily accept likes

@Plenty11 

 

Another option is to turn your data into a Table by higlighting it all and pressing Ctrl T

 

Then you can always see what column your in, and your table automatically gets longer as you type underneath it

 

clipboard_image_0.png