Unanswered: make some columns static (no scrolling)
I'm trying to set up a table where the far left column will stay completely still, and I can scroll all the other columns when needed. The left column will be categories, and the right columns will be different sets of measurements for those categories.
Does anyone know how to do this? Thanks in advance
not sure what you mean if you mean scrolling down then probably not but if you want to replicate the behaviour vertically select the cell below where you wan't to freeze then freeze panes again otherwise it would probably have to be a macro