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
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
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
Excel users are rightly interested in Lambda() a very powerful addition to Excel. Lambda lets you create user-defined functions without VBA. No need for .xlsm files with all the security concerns they entail. A long formula can be written once then referenced anywhere in the workbook by a short name of
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
Make the same drive letter or patch appear for the same removable drive, plugged into Windows computers. Keep Microsoft Office Open menus working for external drives. Jenny N writes: “I have a problem with Word when working with documents on my flash drive. If I insert the drive days later
Handwrite direct into Office apps for iPad, converting your writing into text right away, courtesy of the iOS Scribble feature. What you’ll need, how to setup and the new thing to look for on the Draw tab of the Word, Excel and PowerPoint apps. Microsoft has integrated the Scribble feature
Microsoft has dropped down hard on a UK teacher with a little bit of plastic helping dyslexic students read. It seems the company can’t learn from past mistakes. “Word Windows” is a small plastic reading tool which makes a little window so readers can focus on a word or letters
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 }
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
When the Stock and Geography data types disappear from the Data ribbon in Excel here’s how to fix and restore Linked Data Types. The Data ribbon is missing the entire ‘Data Types’ section. We’ve had several reports from Office-Watch.com readers who start Excel 365 and find that their Stock and
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
We have recently discussed how to show hidden formatting characters in Word, but it is also possible to hide text and even images in Microsoft Word, as long as you are using Word desktop on Windows or Mac. See Find and Remove Hidden Text in Word Hidden text positioning and formatting
Cell Margins and Cell Spacing are two important settings in any Microsoft Word Table but they aren’t used much and not well understood. Cell margins are the spaces between your text and the edge of the cell. They can be set separately for the top, bottom, and either side of
Microsoft charges quite different prices for Office 365 Home/Microsoft 365 Family, depending on the country. Some countries residents pay more for Microsoft 365 than others and the differences can be large. We decided to see how cheap or expensive Office 365 Home/Microsoft 365 Family plan can be, depending on where
How long do you have to work to afford Microsoft Office? That’s the question we asked after compiling a list of Office 365 prices across the globe, Office 365 Home and Office 365 Personal. For most people it’s not long but there’s a lot of variation from less than one
Microsoft has announced a new Symbols Server for Microsoft Office which is a good move but not what most people think of when they see the word ‘Symbols’. These symbols are NOT characters like £ € ™ nor emoji such as ❄️❤️🎂 or the infamous eggplant🍆 😁 The new symbols
You have an Apple iPad but do you know all the different ways that Microsoft Office can run on an iPad. There are four different options, some free and others you have to pay for. Why bother? Surely you just install the Office mobile apps and that’s it? Sadly no,
Making unique (not duplicated) list in Excel is possible in three ways that update automatically. One is headspinningly hard. One has some minor quibbles. The best option is a lot easier and relatively new in Excel. We’re talking here about making a list of unique (non-duplicate) values which update automatically
