Can or should you open Office documents directly from removable storage like portable hard drives, USB ‘memory sticks’ or even floppy disks? Since we wrote about removable drives and drive letters we’ve had long time Office users asking about opening documents directly – should it be done at all. Many years ago, it wasn’t a […]
Sorting numbers in Excel looks easy but there’s traps if you’re not careful. Let’s look at an example of sorting gone wrong, how it’s easy to do but also fix. Finally how modern Excel has several features to warn you not to fall into a common mistake. This table popped up on Twitter (original source […]
The Ctrl+F6 shortcut in Excel doesn’t behave the same way as Word or PowerPoint. It changed a few years ago to behave differently from what most Office users expect. Ctrl + F6 will switch (cycle through) the open windows in Word or PowerPoint. It’s a quick way to move between different documents/slides. Since Windows doesn’t […]
Here’s how to get the Game of Thrones or House of the Dragon look in Word documents and PowerPoint slides. Plenty of people have borrowed the Game of Thrones or GoT look, including a certain US President. All these uses are contrary to various trademarks by HBO. Despite legal complaints there are many ‘tip of […]
The \s n switch inside the { SEQ } field code isn’t easy to understand so here’s an example of how it resets numbering after a Heading style. Use {SEQ \s n } to restart numbering from 1 after a chosen Heading style. E.g. { SEQ Identifier \s 1 } to reset after Heading 1 […]
