The Apple command ⌘ symbol can be typed into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Apple command ⌘ symbol appears on Mac and iPad keyboards but only as a command option, not as a symbol to type. The ⌘ symbol predates
The wonderful Excel Formula Bot has a new look, more features and has gone ‘pro’ with paid subscriptions. The whole site https://excelformulabot.com/ has been revamped with a cleaner, clearer look. Excel Formula Bot is certainly up-to-date, as you can see above, it already ‘knows’ about the new Image() function despite
There are some great and editable Periodic Table of Elements options available in Microsoft Office – Word documents, Excel spreadsheets and PowerPoint slides There are many Periodic Table ‘documents’ on the net but most are PDF’s or images that can’t be changed. We’re looking for editable Word documents and Excel
After more than a decade of apathy, Word users were supposed to get a document To Do list feature. In 2018 Microsoft listened to customers – but not for long. Update: Word’s To Do list ended up as a ‘dead end’. The feature appeared in Word 365 beta/Insiders releases in
Insert the North West or Top Left Arrow ↖ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. North West Arrow ↖ or “Top Left Arrow” can be used for directions on a map (naturally) or pointing to ‘top left’ in a Word
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
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
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
‘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
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
Which version of alphabetical order does Microsoft Word use? I thought that alphabetical order was, well, alphabetical order. That’s what I was taught at school and apparently I was taught wrong. There are at least three ways, two used by dictionaries, another by Microsoft and that’s for English alone! Reading Sue
There’s a right way and wrong way to send invitations from Outlook. ” I tried your tip about sending calendar appointments to other people but it doesn’t work. I write an email invitation then add a calendar item. The receiver doesn’t see the Accept, Decline etc buttons above the message,
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
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
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
Microsoft 365 and Office 2021 for Windows can make images transparent in Word, Excel, PowerPoint and Outlook. Text or other graphics can show through the picture. Pictures can be made transparent to reveal what’s behind in lower layers of the document, slide or worksheet. For any image go to Picture
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
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 }
Get the most from the SEQ (Sequence) field code in Microsoft Word using these options and switches. Office-Watch.com has tested all the {SEQ} features and found a few things that are different from the official Office documentation. To start with {SEQ } check out Why Word’s SEQ code is a
Old email addresses or people have an annoying habit of appearing in Outlook, even after you’ve deleted the address or person from the Contacts list. Here’s why obsolete emails keep appearing and how to remove these unwanted and dangerous strays. Here’s an example of Outlook’s problem with ‘sticky’ and unwanted
Microsoft Outlook was blamed for a 2015 leak of passport details of world leaders, including President Obama, according to a report in The Guardian. Here’s what happened then, how it can still happen now and what you can do to avoid the same trap. The details where emailed to the
Microsoft Word has many supplied Bibliography formats or styles to choose from. You can add your own custom formats to suit your needs (or your professors). First, a quick look at how Word figures out how to format or arrange a citation. See: Add a Bibliography to Word documents Citations for
Type the Orthodox Cross ☦ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Orthodox Cross or Russian Othodox Cross ☦ symbol is widely seen in Russia and in particular the Russian Orthodox Church. There’s also a Christian or Latin Cross ✝ symbol
Type the Marriage Symbol ⚭ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Marriage Symbol ⚭ symbol is two interlocked circles with obvious symbolism. It can be used for any situation you like, perhaps when two items or groups merge or an
