Posted on December 2nd, 2008 by Joseph Harris
There are times when it is useful to remove all formulas from a worksheet. It may simplify a sort or perhaps you do not want to show the world your method of calculation. The quickest and easiest method of doing this is using paste special. Select the cells or entire worksheet you would like to [...]
Posted on November 20th, 2008 by Joseph Harris
To quickly ad the $ symbol around your cell references simply select the cell references in the formula bar and press f4. For example, if you have =A1 in the formula bar and you highlight and then press f4, the result will be =$A$1. A quick way to create an absolute cell reference. Joseph Harris [...]
Posted on November 11th, 2008 by Joseph Harris
How to create list for data validation on different sheets than the sheet that contains the data validation.
Posted on October 24th, 2008 by Joseph Harris
There are times when you may have a workbook that has 20 sheets with external links and you are forced to wait after every small change you make due to the size of the workbook. When those times occur, you may want to turn on manual calculation. Manual calculation turns off automatic calculation until you [...]
Posted on October 23rd, 2008 by Joseph Harris
Vlookup
Posted on October 23rd, 2008 by Joseph Harris
If you have ever had to change the same thing on 50 workbooks, then you probably have already discovered the Excel macro recorder. The macro recorder will record your every click which you can then play back to repeat the task you just performed. It is an easy way of automating task. To use the [...]
