Double Clicking in a cell to take you directly to the source of data of the formula is possibly one of the most useful tricks available when working with a spreadsheet with multiple worksheets and many formulae.
Copying cells and pasting them in to visible cells can be a problem. This is a problem when you drag the cell contents down as well as copying and pasting cell values only (i.e. not affecting the formatting).
We often analyse files containing many hundreds or thousands of rows, with multiple columns of data. With this amount of data it can be difficult to make sense of the information contained within the file.
Do you have a problem that sometimes your fingers can't type at the same speed as you would like? Well I do, whether its simple words like 'eb' instead of be, 'ahve' instead of have or longer words such as 'consoildation' in...