I said there are at least six tricks with the Excel Name Box and that’s before you get into using named rangers and objects. The Name Box lets you select a cells and give them a name or jump to an existing named range. It’s the same as going to Formulas | Define Name | […]
I found at least six uses for the Excel Name Box beyond just displaying the current cell address. The Name Box is an unassuming little box at the top of your Excel worksheet that you may not have thought about much, but it has a powerful range of uses for selecting and moving around a […]
Microsoft Word’s Sort feature is OK but has its limitations. We humans insist on variations of the simple ‘first and last’ name that confuse a computer. Here’s some name sorting traps and workarounds. For short lists, it’s probably enough to do a Word surname sort then manually adjust the list for any anomalies. Longer lists […]
A full and searchable list of the measurements and multiplier prefixes available for Excel’s CONVERT function. This is a table of the abbreviations used in the Excel CONVERT() function. The basic units inbuilt to the function are all listed plus some of the common measures available using the Multiplier prefixes. Below that are a list […]
Converting SVG icons into JPG is essential for older Word and Office versions that don’t have native icon/SVG support. Here’s some options for conversion or sourcing alternatives. SVG’s are great with many advantages for Office 365 and Office 2021/2019 users. Not everyone has the latest Microsoft Office or shares documents with others who have earlier […]
