Word lists have more power and, let’s face it, confusion hiding under the menus. How to start a new list, continue a previous list, reset the numbering and trying to figure out how a list numbering has been messed up. Many questions arising from our article on Word Autonumbering. Many
There’s a maximum of nine levels available in Word multi-level numbering. That’s enough for the seven dwarves plus two more. There’s a way to get more than nine levels. A Multilevel list setup shows 9 levels. Need more? Perhaps create a separate multilevel list with custom numbering starting at 10?
Word multi-level lists can get messed up with ‘wrong’ numbering appearing for no obvious reason. Here’s why it can happen, troubleshooting options and how to fix it. It’s too easy to mess up a seemingly normal multi-level list in Word. Options like ‘Start new list’ and ‘Continue from previous list’
Word has an amazing range of options for automatically numbering your document headings or paragraphs. Even more amazing is my visit to an office. I found staff going through a long document, laboriously numbering headings and sub-headings by hand! They been doing this for years and weren’t happy when shown this
There’s an obscure little Excel option that’s worth checking to give you a little performance boost. The choice is File | Option | Advanced | Print | “Include fonts that are stored on the printer” An obscure option that most people never bother with. “Printer fonts” are fonts in the
Excel 365 for Windows and web have a different font for the formula bar. The monospace font should be easier to read and understand. For as long as there’s been Excel, formulas have been shown in a proportional font. Probably to fit as much text into the available screen space.
Excel 365 for Windows and Web is getting a great new feature called Value Preview. You’ll be able to see the current value of any formula part just by hovering over it. It’s simple and most people won’t even notice it except by accident. Just hover the mouse over part
Selecting the exact color from a sample on the screen is best done with one of the PowerToys for Windows 11 and Windows 10 – Color Picker. Unlike the color selector in Office, the PowerToy Color Picker can choose from any visible part of the screen with a keyboard shortcut.
Office for Mac has quite different and extensible color selection options for text, shapes, pages etc. that are the envy of Office for Windows. We’ll explain them all, eyedropper, swatch, color wheel or sliders, palettes and even pencils. Choose from the same range of colors as Windows, but in many
Here’s all the match colors, color picking or color grab tools in Microsoft Office for Windows or Windows itself. While Office for Mac users have it a lot easier with one central ‘eyedropper’ to choose a color from the screen. Naming the color picking tool isn’t consistent in Microsoft Office,
The US Department of Defense (DoD) is now fully deploying an extra-special secret version of Microsoft 365 to high-ranking areas including the Secretary of Defense. Called ‘DOD365-Secret’ or ‘DOD365-Sec’, this Microsoft 365 plan is one of the DoD’s first moves into cloud computing and 21st Century collaboration. The new system
Need a Halloween emoji or symbol? Here’s a quick and searchable list of more than 30 spooky, scary emoji for documents, sheets, slides, emails or messages that you can use or copy. In Microsoft 365, Office 2021 and Office 2019 there are also Halloween icons and symbols for Word, Powerpoint
There are plenty of creepy Halloween themed fonts available for free to work on Windows or Mac with Word, PowerPoint or other Office apps. Here’s seven that caught our eye plus one that you probably already have. All of these work in both Windows and Mac, mostly TrueType fonts. They
Our exclusive Pumpkin Color Charts have the perfect ‘pumpkin’ colors you can use in Halloween documents, slides and graphics with their Microsoft Office compatible color codes including the five Pantone colors called ‘Pumpkin’. There are many Halloween ‘pumpkin’ colors to choose from depending on the variety and ripeness of virtual
Office has various options for graphics or images of skeletons or skulls – perfect for Halloween or other gory, scary uses in Word docs, PowerPoint slides or Outlook emails. We can’t offer a 12-foot skeleton, complete with creepy glowing eyes. For this 3.56 meter monster you have to hunt through
Create your own fun, satirical ‘Halloween costume’ pack in the style of a popular meme using just Microsoft Word or PowerPoint. Use this article as a year-round example of how to overlay one image over another plus adding text to a picture. Take a blank Halloween costume image, add an
Excel 365’s PowerQuery has many wonderful features but occasionally there are common needs that it can’t easily handle. One of those surprising complexities is removing older duplicates but retaining most recent row for each. We’ll explain the simplest solution then why it works. Here’s some sample data on the left
Microsoft PowerPoint’s Cameo lets you put a live camera feed into your slides. The camera feed can be moved, resized, cropped, and styled just like any other image. Designer in PowerPoint can also be used to add flair to slides that use cameo. Cameo is already in Windows and Mac
Microsoft is boasting about the coming ‘offline support’ for the new Outlook but a look at the detail shows its very limited offline access. The current Outlook desktop apps for Windows and Mac have excellent offline support, meaning you can work on your mail, calendar, contacts even when there’s slow
One of the most commonly used and confusing Excel functions is much better in Excel 365 and Excel 2021. Vlookup() has a new, better and easier replacement Xlookup(). It’s a truly good and useful addition to Excel, some might call it a godsend. Xlookup is available in Excel 365 for
A British medical office has made a right mess of selecting trainee anesthetists by the misuse of Excel. Let’s look at what happened and some ways you can avoid similar mistakes. As told in The Register, the UK Anesthetic National Recruitment Office (ANRO) had the job of selecting candidates from
Safe Mode is a special way for Office apps to run when things aren’t working properly. Here’s how to use Safe Mode, if Office doesn’t offer it automatically, and what Safe Mode does differently. Safe Mode is useful in situations where you cannot open files in normal mode because the
OneNote desktop will start getting AI tools, CoPilot, from November 2023. According to a Microsoft Roadmap entry, ‘general availability*’ of CoPilot in OneNote will start next month. Not ‘1st November’ as some are reporting but starting during November. Copilot in OneNote will be able to make lists, create a plan
Excel 365 is getting a simple way to add checkboxes into cells to easily set True/False, Yes/No, On/Off binary settings. You can hear the cries of “About bloody time” across the Excel world <g>. It’s long been possible to add a checkbox into an Excel worksheet but it’s a clumsy
