This would be useful if you wanted to change the orientation of the display of your data, but really didn’t want to retype it all. Copy all the original data first, find an empty area and click on a cell where you want to begin the copy. Go to Home > Paste > Transpose (you […]

When an input value starts with zero Excel will delete the zero(s) by default – try adding a single quote mark ahead of the first zero.

It’s common knowledge and instinctive to click on a different sheet tab in a workbook to activate it.  You can also use the keyboard; press Ctrl-Page Up and Ctrl-Page Down to go up and down the sheets. If your workbook contains a large number of sheets they may not all fit on the screen and it […]

How to split full names (in a single column) out into separate columns. Use functions: =LEFT(B4,FIND(” “,B4,1)-1) =RIGHT(B4,LEN(B4)-FIND(” “,B4,1))

Sometimes you might find a quick reminder of the formula syntax useful when working in Excel. If this is the case then type an equal sign followed by the function name and then Ctrl+Shift+A. For Example typing =Sumif and then using the keyboard stroke Ctrl+Shift+A will give you: =Sumif(range,criteria,sum_range). In 2010 you will find Excel […]

Say six months ago you wrote a formula similar to this: =10000+787-12*299.64. Now you find you just can’t remember what exactly each figure represents. Try writing yourself a reminder about the calculation and add a hidden note to your formula by using the N() function i.e. =10000+787-12*299.64+N(“Loan+Interest-12 months of loan repayments”). The N() function converts […]

Do you want to repeat data that’s already been used in the column? To enter Yellow in a new cell in the column Excel will bring it up anyway when simply typing Y – this is because there is only one data entry starting with the letter Y. Conversely if you need to enter Blueish, […]

A quick way to find the sum and average of cells in Excel 2010 is to select adjacent or non-adjacent cells and look in the status bar. Excel displays the average of the numbers, a count of the cells, and the sum.