Moving to the bottom of a range or list without scrolling

If you have a list of say 1000 items and you want to get to the bottom of it you would usually need to use the scroll bar or press the down cursor key and get finger ache!  Well providing you click somewhere within the list you can use ctrl and the down cursor key.  This will move you directly to the end of that particular list.  In the same way ctrl and up / left / right works.

Also if you combine this method by pressing shift at the same time it will move to the end of the list and also select the cells between where you started out from and the end.

Run a line through your text by adding a strike through quickly.

You can run a line through all the contents of a cell giving a clue that the item is complete of finished E.G.:


Normally this is a fiddly affair requiring many mouse clicks.  To do this quickly simply select the cell or cells you want to add the strike through to and press ctrl and 5.  This action toggles the strike through on and off.