Import PDF’s into Excel and refresh later
Excel 365 for Windows is getting a long-wanted option to import PDF’s into worksheets. Microsoft has gone ‘one better’ and Read More
Microsoft Excel
Pinned Save folders in Microsoft 365
Word, Excel and PowerPoint 365 for Windows are getting better control over what appears on the new-style Save dialog. Folders Read More
Showing 12 PM as 'noon' in Excel
Excel shows midday or noon as 12:00 PM which doesn’t suit everyone, here’s how to change the defaults to a Read More
Coronavirus global statistics, Excel workbook update
A friend of Office Watch has enhanced our latest COVID-19 global statistics workbook and offered to share it with all Read More
Action Pen, a renamed feature in Word, Excel and PowerPoint
The Ink Editor button in Word 365 has gone, replaced with the ‘Action Pen’ on the Draw tab in Word Read More
Combined Drawing Tools in Word 365 and other Office programs
The Drawing Tools in Word 365 is now larger with separate tools like Lasso and Eraser now in a single Read More
Get in line for Money in Excel
Microsoft is testing a new feature or template, Money in Excel. You can apply to be one of the first Read More
Gradient Effects and Text in Word - in depth
Adding color gradient effects to your text, shapes and borders is a good way to give it a bit more Read More
Excel worksheet protection is not encryption
Hiding and protecting an Excel worksheet is NOT the same as full encryption. Protected workbooks can be encrypted and not Read More
X Æ A-12 in Microsoft Word and Office
Elon Musk and partner have named their child X Æ A-12 (no kidding) how do you type Æ in Microsoft Read More
Excel automatic refresh and recalculation tricks
There are several ways to make Excel automatically refresh data connections and recalculate a worksheet. These tricks are more important Read More
Workbook Statistics finally in Excel
A long last, Excel is getting a quick summary of the workbook statistics including the bounds of the sheet, tables, Read More
Excel worksheet with global COVID-19 stats - update
We’ve updated our workbook that imports the latest COVID-19 statistics and combines with population data through Excel 365’s Stock Data Read More
Moving Average in Excel Charts
Adding a moving average line to an Excel Chart is very easy, just a few clicks, with many options. Any Read More
Per Thousand / Per Mille sign ‰ in Word, Excel and PowerPoint
How to type the Per Thousand (or it’s official name ‘Per Mille’) sign ‰ into Microsoft Word, Excel or PowerPoint. Read More
Does an Office licence work for two users on a computer?
Microsoft Office rules might let two users or more use the same copy of Office on a computer. It depends Read More
Search My Files is the better way to find files, PDF and Office documents
Nirsoft’s SearchMyFiles has received a major boost. It can now search inside Office documents and PDF’s. SearchMyFiles is the Windows Read More
Why Old Office documents should be banned
After last week’s article, it’s clear some folks haven’t changed or still accept the older .doc .xls or .ppt files Read More
Format Painter with Shapes and gradients
Format Painter in Office will work to copy formatting between shapes which is very useful for complex Gradients. But they Read More
Hex color code advantages in Office
Hex color codes in Office 365 for Windows and Office for Mac aren’t just good for HTML coders, it’s a Read More
Office Watch
Office for Mere Mortals
Twitter
Facebook