![freeze frame in excel 2013 freeze frame in excel 2013](https://support.content.office.net/en-us/media/48e72b73-32de-4e85-9ed3-216dfaf81f6b.png)
![freeze frame in excel 2013 freeze frame in excel 2013](https://contexturesblog.com/wp-content/uploads/2012/07/windowsettings01.png)
You need 2 files –the file you hopefully have downloaded from the Sticky Headers link above (I mean, why write it yourself?) and a jquery file, as the script is dependent on this. Overall, it’s a fairly easy thing to install. I haven’t tried to figure it out any further than that, but hope to come back and revisit this part again This is because the code is trying to determine the first visible row of data on the page to use with its calculations. One caveat I did run across is that with a ‘group by’ view, you have to expand out the very first group level completely for the headers to appear. In my case, I chose to color the headers blue so that they were differentiated from the rest of the screen.
Freeze frame in excel 2013 full#
Of course, you can tweak the css and other functionality since you have full control of the code and the styling. They remain visible until you scroll back to the top of the list when the standard headers are back on the screen. Regular SharePoint view headers look like this – plain and fixed in location.īut with these floating headers, as soon as you scroll down far enough for the standard headers to roll off the page, they will pop up, as shown here. After reading up on it (and reviews of it) it looked like it would more than suit my needs. The one that stood out to me as the best bet though was an open source script called Sticky Headers.
![freeze frame in excel 2013 freeze frame in excel 2013](https://www.technipages.com/wp-content/uploads/2016/06/Excel-Freezing-Top-Row.png)
Of course, I started with my usual searching of the ‘net, finding various options and snippets of code that claimed to do the job. Their quandary was that they had a couple of lists with lots of numerical columns and it was hard for them to keep up with what they were seeing. Have you ever been asked to freeze the column headers in SharePoint like you can in Excel? If so, then read on as I found there’s a nifty little way to handle this after one of our clients asked if it was possible.