I think only Lotus 1-2-3 actually used it, but Lotus 1-2-3 was literally the entire reason to use early PCs. With Scroll Lock active, in Lotus the movement keys would shift the whole spreadsheet, keeping the current cell highlight steady on the screen, rather than move the current cell highlight.