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
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
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
An Outlook.com or Microsoft hosted mail storage quota can be anything from 2GB to 100GB. Here’s a full list of the mailbox limits, how to check your current usage and total allowed size. We’re talking here about Microsoft mailbox hosting services including Outlook.com. NOT the various and confusing types of
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.
What happens to all the different windows open in Outlook for Windows when the software crashes? How can you restore the open windows when Outlook restarts? In case you didn’t know, it’s possible to have many windows open in Outlook. Many people don’t realize that because Outlook first starts with
Microsoft’s mail service Outlook.com might move Office Watch or Office for Mere Morals to Junk Email. Here’s how to stop it doing that for any email, The same advice applies to other newsletters and emails that are wrongly marked as Spam / Junk Email. The famous UK newsletter, Popbitch, is
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
Microsoft Word has almost all you need to make ‘hand written’ notes and letters for a fraction of the cost of a special service. Dig into some of the lesser known Word font and line spacing settings to get that ‘written by hand’ effect. The New York Times has a
Insert the Phi uppercase Φ, and Phi lowercase φ / φ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Phi (uppercase Φ / lowercase φ / φ) is the 21st letter of the Greek alphabet. The uppercase symbol has various uses, such as the cumulative distribution function of standard normal deviation in
Microsoft is working on extending OpenAI features like ChatGPT to help people write Word documents based on a short suggestion. And there’s a lot more possible given Microsoft’s investment in OpenAI, even a koala poem ‘written’ by Dorothy Parker. Office Watch has been looking at ChatGPT’s ability to write Office
How to insert the Upwards arrow ↑ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. The upwards arrow ↑ symbol is used for various purposes. It can notate a mathematical symbol for ‘undefined’, for very large integers or in medical notation it can mean increased. Of course, there are plenty of uses in
Insert the Banana 🍌 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. There’s also a Banana icon in modern Office apps. How Banana 🍌 looks in different fonts. Only two Segoe fonts support the Banana emoji; Segoe UI emoji (color or
Get ChatGPT or Copilot to show working Office VBA code to select and open a Word, Excel or PowerPoint document. It’s an example of how to work with ChatGPT to get the code you need and its limitations. In episode 1 of this saga, Office Watch showed how to use
To make data entry simpler in Excel, form controls such as checkboxes can be added. A checkbox can be used to select or deselect an option. Checkboxes are useful for forms that have multiple options. The trick is using Excel’s Developer tab which holds the checkbox control. See How to get the Developer Tab in
How to insert the Sigma upper case Σ and Sigma lower case σ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Sigma (uppercase Σ / lowercase σ) is the eighteenth letter of the Greek alphabet. In mathematics, the uppercase sigma symbol is used
A Microsoft Word text box can have rounded corners instead of the default square corners. It’s remarkably easy once you know the simple trick. Word Text Boxes always start with square corners, no matter which default you choose from the gallery. But once it’s inserted, a Word text box can
Insert the Double Dagger ‡ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Double Dagger ‡ symbol is used to mark a third footnote after the asterisk and dagger in a Word document. How Double Dagger ‡ looks in different fonts. Here’s some
Word 365 Mobile for iPhone and iPad have Read Aloud or Speak options to make a voice read the document to you. The Microsoft Office options are almost the same for both devices. Read Aloud in iOS is similar to the feature in Word for Windows with the same little
How to change the look of Word mail merge data like dates and dollar amounts to exactly what you want to see in the documents. Nancy M asks: “I try to merge data (such as amount, PO#, to whom, as well as the date) from an Excel database. In the
How can you put percentages into a Word mail merge? There are several methods including the one we like because it’s reliable and simple. Following our article on importing Excel data into a Word mail merge, here are the options for using percentages. Excel might show a percentage but the
Here’s how to check how many days are left before Microsoft 365 needs an online ‘license check’ to confirm your license. Microsoft calls this a ‘grace period’. Also what’s the maximum possible offline access period. See Restart or renew Microsoft 365 licence before going offline Microsoft 365 software and apps check
Microsoft has made some ‘under the hood’ improvements to the combo ‘IF’ and ‘IFS’ functions like SumIFS(), SumIF(), CountIF() to make them faster than before. Just don’t believe Microsoft’s excessive boasts. The functions themselves behave the same but they now have a cached index for the range. That index is
Consider switching to SumIFS, it’s much the same as the older Excel function, SumIf() but easier to expand as your needs change. It can add up values according to more than criteria like a name and date range. We’ve talked about SUMIF and how its parameter order is a little
