|
I don't have any other use for it other than in Excel and Access using tables or arrays.
As for explaining the Excel thing. If you use the arrow key to move around in Excel, the cell that is active ie the one you can edit moves in the direction you are hitting the arrow key. So if hit the arrow key to the right you will eventually move from a1 to b1 to c1 and so on.
Now sometimes you have a formula that has lots of references to other cells. Now you may find you have an error or want to check the formula. You go to the cell (let say a1) which allows you to see the formula in the formula bar at the top of the screen. You can then see all of the cells that you have referenced in the formula (let's say AZ1 and B129).
Then if you press scroll lock, you can use the arrow key to move around the spreadsheet as you did before so you can look and see if AZ1 and B129 are the correct cells to use in your formula. However, the active cell doesn't move this time - it still stays as a1 and it means you continue to look at formula (to see your cell references) and you can edit the formula by hitting the F2 key without having to go all the way back to highlight cell a1.
|