Do you need to clear just the numbers from your Excel worksheet?. I know I do this regularly if I have a worksheet I want to re -use for example a generic input form and I want to keep all of the...
Tag: Formula
Do you ever get reams of paper printing at the end of your worksheet? I have been asked about this a few times, even if users have deleted their empty rows that they no longer use, when they hit...
This tip I find useful in converting the Irish/UK take on temperature in comparison to the USA temperatures, I usually like to see the trends of temperatures of where I am going on my regular road...
How To Count Unique Items In A Range Of Cells Using Advanced Filtering
Whilst using Excel there will be a good number of scenarios where you want to find the number of unique values you have in a range of cells. this could be Customer Names, Invoice Numbers, Order...
Sometimes you may want to limit the access of a user to a particular range of cells in a worksheet, for example you may have a worksheet set up that only a certain range can be modified or activated...
Restrict The Number Of Characters A User Can Enter In An Excel Cell
Sometimes it's necessary to limit the number of character entries into cells, for example account codes or user names. You may want to limit an account code to 6 characters. This cuts down on...