Excel-related articles.
Excel’s status bar shows various statistics based on the values in the selected cell range (e.g. sum, average, max and min). Right-clicking on it opens the Customize Status Bar menu where you can choose what is featured. Microsoft stealthily snuck…
I’ve often wondered why the Format Cells window for conditional formatting only has half the border styles found in the standard one. I like the thick border styles because they stand out more. There have been numerous occasions when I’ve…
VBA lacks a keyboard shortcut for commenting. This is a standard feature in modern IDEs, however, the VBA Editor is not modern, so we are forced to tolerate its drawbacks. Comments are denoted using a single quotation mark (‘). Block…
Press Shift + Ctrl + A after a function to display all its arguments. Then put a leading single quote to signify text. I often find this useful if I need to retrieve the arguments of a function I’m explaining….
Wednesday’s announcement of 14 new Excel functions was welcoming news. However, despite switching to the BETA Channel yesterday, I am not one of the lucky ones who have access to the new batch yet. Nevertheless, I was particularly drawn to…
If you have a set of dates, you might also want their week numbers. These can be returned using the WEEKNUM or ISOWEEKNUM functions. What is the difference though? Function Syntaxes • serial_number — a valid date in serial number…
End of content
End of content
