A recent update to Excel has made a slight change to the AutoCalculate feature. You can copy a value by simply clicking on it.
Tag Archives: calculation
Stopping the Clipboard from being cleared in Excel VBA
How to check if the clipboard is empty
It is common knowledge (or it should be) that running a macro clears the undo list. In general you can’t undo a macro. However some macros also clear the clipboard which can stop you copying and pasting. I have found a workaround for the clipboard problem.
Status Bar Calculations in Excel
Quick and easy calculations
Excel has had an AutoCalculation feature for many versions. This means you can see the result of common functions without typing a single formula.
Summing Coloured Cells in Excel
A SUBTOTAL trick worth learning
In my training sessions I sometimes get asked about summing cells based on their colour. A SUMIF based on colour.
Speeding Up Excel Macros
Tips and tricks for faster macros
There are two commands you can insert at the top of your code to speed up your macros.
Counting Characters in Excel
Another useful SUMPRODUCT technique
If you need to know how many characters are in a cell then use the LEN function. What if you wanted to know how many characters were in a range?
Calculating Excel
F9 shortcuts and tips
When you set calculation to manual in Excel you have turned off calculation. You can press F9 at any time to update the calculations. F9 doesn’t turn on calculation, it just does a recalculation.
How and why you should use Check Boxes in Excel
Make it stick with a tick
Check boxes make selections easy. Excel has a number of useful controls that can be added to sheets to improve the user interface. These include check boxes (tick boxes), option buttons and spinner controls.