Ability to both freeze colums AND rows at the same time
Ability to both freeze colums AND rows at the same time would be fantastic. Also, not just the top row or first colum, I want to be able to choose from where the freeze panes starts.
When scrolling down, the frozen colums can roll up. But when sliding sideways, the colum remains put and the frozen rows slide along. Can't be that hard, to do?
This is already supported. To freeze both rows and columns in Excel 2016, do the following:
1. Put your cell selection in the cell below the row you want “frozen” and to the right of the last column you want “frozen” (said another way – put it in the first cell that you want to be able to scroll either direction – C5 for instance)
2. On the View Ribbon, choose Freeze Panes > Freeze Panes.
That should do it.
5 commentsComments are closed
What a great site!
How about just making this easier? Why not highlight the selection you want frozen? Seems like a more intuitive way of doing it. I understand though since Engineers don't understand most people.
Fred Crowner commented
This is broken in Excel 2016. When I do a freeze, the split operation is used instead. If I wanted a split, I would have used a split. Freeze doesn't scroll a sub-window into other parts of the spreadsheet. When I'm teaching a class I'd really rather not scroll over and show student names with the grades-it defeats the usefulness of randomizing the student order in the gradebook.
It has worked since at least office 2010 and is a useful capability, even if it was not intended as a feature. I show it to about 150 to 200 college students a year, and find it much more useful than split.
Kenneth Barber commented
To do this, select the cell that you want to be the first cell of the non-frozen range and go to View tab → Freeze Panes → Freeze Panes.