Excel 2002 introduced the Text -To - Specch feature. It's an interesting one, you can get Excel to call out back to you the contents of a range of cells, or call out the cell contents as you type...
Recent Posts
If you use the file auto recover/ save option in Excel, which I suggest you do. (I learned the very very hard way years ago whilst doing some analysis for my Thesis, my file corrupted after a hefty...
Here's a great shortcut you may not have heard of or maybe you have. I know I was really pleased when I was shown it, and those people who like to use the mouse a lot to navigate will like it as...
When you format cells in Excel as percentages, Excel will then automatically format the cells as you type into them. All is well and good if your figure is under 1, once you start to enter figures...
Excel easily keeps track of the last files you have edited, these are often referred to as it's Most Recently Used Files (MRU). You can change how many you want Excel to display, you may just want...
You probably know already know how to use the Find & Replace function in Excel. All you need to do is hit CTRL+F and you are able to look for just about anything on your Excel spreadsheet. I...