Excel’s Fill Handle has a lot of cool tricks. This short video demonstrates a couple of them.
Monthly Archives: February 2016
Returning a Blank Cell
You can’t use a formula to return a truly blank cell. It may look blank, but it isn’t.
Blanks cells are selected when you use GoTo Special Blanks.
Typically you want to convert cells containing only spaces into blank cells.
Note: this technique assumes the other cells in the range don’t have spaces.
You can select the range press Ctrl + h and type a space in the Find Box and click the Replace All button.
This converts all the cells with spaces into really blank cells.
Related Posts
Outlook and Word Quick Tip
Better than AutoCorrect
Do you use the same sentence or paragraph in emails or letters? Well, I may just make your day with a new option in Outlook and Word.
Days in Month Formula
If you need to calculate how many days in a month, you can use two functions together.
Assuming cell A1 has a date within the month, you can use
=DAY(EOMONTH(A1,0))
Flexible Hyperlinks in Excel
Using the HYPERLINK Function
Hyperlinks are a great way to navigate around large spreadsheets. Unfortunately they each take a few clicks to create and can be easily broken. You can use a function to easily create multiple, flexible hyperlinks.
Remember there’s no such thing as a small act of kindness. Every act creates a ripple with no logical end.
Scott Adams
Excel Variance Analysis
An alternative charting technique
It is common in accounting to compare numbers. Either Actuals vs Budget or this year vs last year. There are different charts that people use for this comparison. How about plotting the variance instead?