Office 2021 is the personal and small business ‘perpetual licence’, non-subscription version of Microsoft Office. For Windows and Mac.
Office LTSC (Long Term Servicing Channel) is the volume licence ‘perpetual licence’, non-subscription version of Microsoft Office for organizations, companies and governments. Also for Windows and Mac.
The features in Office 2021 and Office LTSC are very similar, if not the same.
All the ☝Up pointing hands in Word and Office
Word and Office have several up “pointing hand” symbols available in some fonts. Here’s the Unicode options explained and shown with the codes and shortcuts to type them in Excel, PowerPoint and Outlook too. There are various Up pointing hand options in Unicode: Index – a pointing index finger with palm facing.Backhand Index – pointing […]
Avoid embarrassing typing mistakes in Word
A slip of the typing fingers can be funny, insulting or embarrassing, turning an innocent word into a naughty one. There are features in Word to help avoid these mistakes which have improved over the years but they aren’t 100% reliable It only takes a single letter to turn an innocent remark into something quite […]
Google Sheets gets 10 million cells, not enough to beat Excel
Google has just doubled the cells available in their Sheets spreadsheet, taking it to 10 million cells. Still well short of Excel’s 17 million cells. Sheets can now stretch to 18,278 columns (column ZZZ) for all Google Workspace customers, as well as legacy G Suite Basic and Business customers. Excel has 17 million cells Since Excel […]
Word Bug: Headings Inside Tables Go Missing
A long-standing bug in Microsoft Word quietly breaks your document navigation when you place Heading styles inside a table. The Table of Contents shows all your headings correctly, but the Navigation Pane silently drops any heading that lives inside a table cell. The same broken behavior ripples into PDF Bookmarks and the Insert Link dialog. […]
2001 A Space Odyssey – in Word and PowerPoint
As long time space and SF nerds, Office Watch can’t resist putting the look of 2001: A Space Odyssey into Word documents and PowerPoint slides. We’ll show you how to make a ‘close match’ using just the fonts and features in Microsoft Office. We’ll also explain the details behind that choice and some alternatives, both […]
Why Windows Character Map is better than Office
Character Map is a Windows feature that’s very useful for Microsoft Office users. It lets you insert symbols and, importantly, find them which is not possible within apps like Word. Windows Character Map has been around for as long as we’d like to remember and it’s mostly done right. If only the equivalent in Office […]
Free color selector in your browser
Google has a color selector among the many features in their home page. It’s free, works in any browser and it’s easy to copy color codes into Office. Search for ‘Color picker’ or https://www.google.com/?q=color+picker then move the two circles to choose the exact color and shade you want. The HEX and RGB color codes are […]
Fancy gridlines to make Excel look great or at least different.
Gridlines are on every spreadsheet in Microsoft Excel workbooks. Did you know those grey lines can be colored to make them fancy, more obvious or more discreet? Let’s look at two ways you can make colored gridlines in Excel. Here’s what it looks like with the pink, black and red in comparison to the default […]
Easy Table of Figures in Word
Microsoft Word can generate a list of all the images, graphs, tables or equations in a document – called a Table of Figures. Just like a table of contents, this list can include page references or links to each figure or picture. A Table of Figures can be useful for creating a proper appendix of […]
Automatic Capitalization fixes in Word
Word has settings to automatically change the case of words that you type, fix common capitalization typing problems add items of your own to have capitalized the way you want them as you type. Word also has options to manually Change Case in Microsoft Word. The settings are in the AutoCorrect dialog at File | […]
Where are Word styles saved – document or template
Styles can be saved in a Word document but are most effective when saved in a template. Changing the style in a template will affect any document that uses the same template. At the bottom of the Modify Style dialog are two choices for where to save the style. Microsoft has reworded the choices to […]
Law & Order title card in PowerPoint and Word
Here’s how to make a lookalike for the Law & Order TV show title card in either PowerPoint or Word. Last week we showed how to make the Law & Order opening screen image and how to use that look in slides or documents. Many readers asked why Office-Watch.com didn’t do the main title card. […]
Law & Order titles and sound in PowerPoint and Office
One way to open a PowerPoint presentation could be to copy the opening of the Law & Order TV shows. Here’s how to get the same look in your PPT slides or Word documents plus the distinctive sound. The same formatting can be used in Word, maybe as a callout to highlight some text. But […]
Can’t edit a document in Teams? Try these workarounds
Sometimes a document can’t be edited in Teams for no good reason. Here’s some things to try and workaround the problem. Teams uses SharePoint to manage documents and sometimes the technology doesn’t behave the way it should. A document that you should have full access to, can only be viewed. Before becoming overly frustrated with […]
Free and secure conversion of .doc .xls or .ppt to the newer Office formats
Here’s how to convert an older .doc .xls or .ppt into a safer and smaller .docx .xlsx .pptx even if you don’t have Microsoft Office. Any smart computer user is wary of documents received in the old .doc .xls .ppt formats because they are regularly used to transmit viruses. The new document formats are much […]
Flash Fill Magic in Excel
Flash Fill is a simple way to split and join text automatically in Excel for Windows or Mac. Flash Fill was added in Excel 2013 for Windows. It’s both useful and looks good in the demonstrations. In Excel there’s often need to join, separate or reformat strings of text. Flash Fill copies your actions at […]
