See the ‘simplified’ Office toolbar for Microsoft 365
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 crowded out the title bar […]
Simple text with day, month and year to Excel date conversion
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 one of the formulas at Converting […]
Happy Spreadsheet Day 2022 with Excel
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 Excel cellCheck Performance – inside […]
Yen ¥ symbol in Word, Excel, PowerPoint and Outlook
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 symbol. ¥ symbol is easy […]
Array Formula with IF filter in Excel
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 answer from the formula: =COUNTIF(Table3[Industry],G4) […]
Excel Array formulas for everyone
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 very least, you’ll know what […]
Better Excel formula converts days into Years, Months, Days
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 formula in Excel 365, 2021/LTSC […]
What are .tmp files in MS Office document folders?
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 a lost document but otherwise […]
Four ways to make text fit in an Excel cell
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 just keeps going across the […]
File menu change for the better in Office 365
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 flaw. The File menu scrolled […]
America has two feet … does Excel?
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. It’s About to Lose One […]
Easily apply the same picture format to many images in Word or PowerPoint
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 apply the same formatting to […]
Reference Mark ※ in Word, Excel, PowerPoint and Outlook
Put the Reference Mark ※ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Reference Mark ※ or reference symbol is used in Asian writing (Chinese, Japanese, Korean) like the Asterix * in western languages. It marks some additional notes to text. It’s called komejirushi (Japan) , chamgopyo (Korea) or […]
Why you must use the Microsoft Office Document Inspector
Why you must use the Microsoft Office Document Inspector … and why you can’t completely trust it. The Office Document Inspector is an important tool for anyone who shares or sends out Office documents. It helps prevent legal troubles and personal embarrassment. Inspect Document is only in Office for Windows (not Mac). Microsoft Office 365, […]
Check Performance – inside the new Excel tool
A new Excel tool might help with very large, sluggish workbooks but don’t expect a lot despite the promising name “Check Performance”. It took us just minutes to find some undocumented strangeness in this cautious addition to Excel. “Check Performance” looks for unnecessary formatting, metadata and styles that might be cluttering up a large workbook. […]
Quickly type Euro € sign in Word, Excel, PowerPoint and Outlook
Quickly type the Euro € currency sign into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Euro € symbol is easy on some keyboards but for other keyboards there’s no specific key for Euro. You can [copy content=”€” text=”click here to copy Euro € to clipboard 📋” copied-text=”Euro […]
