One of the best features in Excel is the ability to plug in a formula ... Watch to learn how to use the $ sign to lock in formulas. Produced by Daniel Goodman Read next Jump to ...

If you're using Microsoft Excel on a Windows PC and enjoy using keyboard shortcuts to improve your productivity, you should definitely learn the many ways in which F4 can save you lots of time. To ...

Each cell in a worksheet has a unique reference that describes its position – for example A1. In a spreadsheet, there are two types of cell reference – 'relative cell reference' and 'absolute ...