Word, Excel and PowerPoint have options to stop people from changing a document, making them ‘read only’ in tech speak. These options protect your documents from unauthorized editing or even reading them at all. There are different levels of protection, they are all under File | Info | Protect Document.
There are some nifty tricks to inserting a picture of your signature into a Word or other document. Tips that make the result look realistic and professional. We’ve already explained the many ways to get a picture of your ink signature into Office. Now you have a picture of your
Adding your signature or signing a document digitally is possible in different ways using Microsoft Word or other Office programs. Before we start, let’s clarify some terminology because ‘signing a document’ can mean several things in the computer world: Adding a signature to a document. Inserting a copy of a
Word, Excel, Outlook and PowerPoint in Microsoft 365 have image and icon libraries plus stock images or ‘premium creative content’. Despite the ‘Stock Images’ name there are four types of extra content; Images, Cutout People, Icons and Stickers. We’re told there are ‘over 8,000’ images and icons with ‘more to
Type the ‘Plus or Minus sign’ ± into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Plus-Minus ± symbol isn’t just used for equations, it’s also used as a shortcut for ‘plus or minus’. In statistics you’ll often see results given as being
Back in August we told you about the interesting ‘Show Changes’ feature in Excel which tracks not only edits made to a workbook but who made them. Since then eager Excel users have wondered when it’ll appear in Excel 365 for Windows or Mac … and so are we. According
Check mark or tick has two options, normal ✓ or heavy ✔ to insert into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Checkmark ✓ symbol is used for bullet or check lists and other indicators. There’s also Heavy Check Mark ✔ which
Type one of the four diagonal cross Mark ✗, multiplication or ballot symbols into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. The X or Cross Mark ✗ symbol is used for bullet or check lists and other indicators. It’s the opposite of
There’s a useful and long-standing Office add-on for people who have many documents open at once and prefer them to appear in tabs (like web pages) instead of separate windows. Office Tab switches Microsoft Office for Windows from the usual ‘one document per windows’ view to ‘many documents in a
Microsoft Office 365 and Office 2021 let you save images to SVG format from either images/graphics, charts or whole slides from PowerPoint. Originally ‘Save As SVG’ was only in PowerPoint 365 Windows but it’s quietly spread to Word 365, Excel 365 and Outlook 365 as well as the Office 2021
Type the three different types of Ellipsis … marks in Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Ellipsis … symbol is used for a gap or break in some text, usually to drop out some irrelevant text or speech. The same applies
Like it or loath it but the comma ellipsis has arrived ,,, as an alternative to the more common ellipsis with dots. Here’s how to use it in Word and Office. The comma ellipsis is a modern, more casual version. It’s used as a more dramatic, even annoyed trailing off
The latest Microsoft Office 365 for Windows has a new and, to date, undocumented, toolbar or “personalized Office experience”. This ‘toolbar just for you’ is both more and less than it appears. The toolbar is an effort to declutter the top or title bar of the Office apps. Microsoft has
The simple and easiest way to convert text dates to Excel dates is using Text to Columns on the Data tab. It’s a simple ‘one off’ method that works well and takes you through the steps. If you need something more automated, for new text dates entered from time-to-time use
Today, 17 October, is Spreadsheet Day and Microsoft has joined the event with a fun example of what Excel is capable of. #spreadsheetday #spreadsheets #excel Microsoft Excel at Office-Watch.com The hidden trap in Excel’s DateDif()Better Excel formula converts days into Years, Months, DaysFour ways to make text fit in an
Type the Yen ¥ currency symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Yen is used for Japanese currency and the Chinese Renminbi / Yuan. Microsoft Excel also offers the Yen symbol for Mongolia even though the tögrög currency uses another
Excel Array formulas are useful for getting the result from a filtered list quickly with a single, simple formula. Continuing our series on Excel array formulas. Here’s a list of stocks with industries aka Table3. How many stocks are in the ‘Shop’ industry? The array formula in G5 has the
Array formulas are an important part of Excel and they are a lot more important now that dynamic array formulas are around. Don’t ignore arrays because they’re an unavoidable part of Excel for everyone. This is the start of a series to help you understand arrays in Excel. At the
Here’s a better Excel formula for converting a number of days into text for year, months and days. This formula leaves out zero values and proper singular/plural (e.g. not “1 Year 0 Months 27 Days” but “1 Year 27 Days”). And we’ll show an even better way to write the
If you look in folders that contain Office documents (Word, Excel, PowerPoint) you might see the occasional .tmp file. What are they? Could they be useful? How to look inside. Can they be safely deleted? The quick answers are: probably Word or Office document remnants, could be handy to recover
Here’s your four choices for making text fit within an Excel cell. About wrapping text, adding line breaks and merging cells in Excel. There are plenty of options to fit text in Excel but not all of them are obvious. At first, when you type text in a cell it
A small but very welcome change to the File menu in Office 365 for Windows to handle the overflow at the bottom of the window. It’s one of those changes that Microsoft doesn’t promote or even mention. Maybe because it’s quite small or perhaps because it fixes an embarrassing design
Did you know that the U.S has two feet? Meaning two different measurements for the term ‘foot’? That got us wondering how Excel’s Convert() handled the standard ‘foot’ and the US Survey ‘foot’. Excel Convert() supports the International Standard Foot and, indirectly, the US Survey Foot. America Has Two Feet.
Here’s how to apply the same formatting, borders and picture styles to more than one picture or graphic in Word, PowerPoint or Excel. There’s an unexpected and easy way to do it. Picture Format tools don’t have custom styles (Microsoft please note) only the in-built pre-sets. If you want to
