Custom Number Formats allow you to add text to numbers and still use those numbers in calculations. There is a workaround if you need to display the number and the text on separate lines within the cell.
(more…)
Check boxes are supposed to be used to allow multiple selections. But since they are now so easy to insert, you might want to use them to allow a single selection. Here’s one way to do that.
(more…)
The MIN and MAX functions are useful as for returning the first and last dates in a range. They have conditional versions as well MINIFS and MAXIFS which allow you to find the earliest and latest dates based on a condition.
(more…)I was working on another project and tried something that I thought always worked and it didn't. When you drag a cell with a number with the Fill Handle it copies. When you drag a cell with a number but hold the Ctrl key down it increments. Well the Ctrl key didn't work when I had a filter in place in a separate part of the sheet. Has that always been the case? I have never seen the Ctrl key…
Sometimes you like to point to a cell from the cell on the left using something like ===>. Here is an easy way to automate the length of the arrow based on the width of the cell.
(more…)