Until late 2022 an annoying omission from Excel and VBA was a simple way to combine or merge arrays into a single array. Here’s how to do it with VBA for older Excel releases. Excel 365 for Windows and Mac now have HStack() and VStack() which will combine dynamic arrays or ranges. The VBA method […]
Your deadline is in four hours, you’ve got pages to write and BAM! a letter key breaks on your keyboard …. What do you do? There are at least six different workarounds available in Word, Windows and Mac. A broken key happened to Colin Chambers, a University of Buffalo student when a drink spilled on […]
Is there one space or two between sentences? Word lets you check the sentence spacing or ignore it completely. It’s a useful option for those of us who learnt on manual typewriters where double sentence spacing was standard. Switching to single spacing is hard for your fingers to remember. One Space or Two People can […]
‘Punctuation required with quotes’ is the most commonly changed Microsoft Word grammar and style setting. It checks is for the location of commas etc. when used with a quotation. Here’s two similar sentences to demonstrate: In US usage, the sentence punctuation mark go inside the quotation marks. In standard British /Commonwealth usage, the comma is outside […]
Microsoft Word can check for the Oxford Comma in your lists and it now uses that name in Word 2016 for Windows or Mac. Sadly, Word 2016’s options have been degraded from earlier versions. Word 2016 can only warn you if the Oxford Comma is NOT there … good for people who prefer the ‘Comma required […]
