The slow way to the end of Excel
Some people have way too much time on their hands …. and this was pre-lockdown! Hunter Hobbs decided to find out how long it takes to scroll down to the very bottom row of Excel. That’s row 1,048,576. It only takes a moment and two keystrokes to get there, but Hunter decided to take ‘the […]
Office 2010 updates are still available, here’s how
0Patch is stepping in where Microsoft has left by offering continued security updates for Office 2010 after official support was dropped a few months ago. Newly discovered high risk security bugs in Office 2010 will get micropatches from 0Patch. These unofficial updates change the existing program files to prevent the new security lapses troubling your […]
Putting a Command on the Quick Access Toolbar
The Quick Access Toolbar (QAT) is located on the left side of the Word, Excel, PowerPoint or Outlook title bar. You can add commands, options and even symbols for easy and quick obvious access By default, the QAT only has Save, Undo, Redo and Touch/Mouse commands but you can cut down on unnecessary keystrokes by placing […]
Quickly add any special characters in Office
One of the eternal questions to Office Watch is about adding characters to an Office document. Symbols and characters not on the keyboard. The most common requests are for adding currency symbols like Pound £ Euro € or Yen/Renminbi ¥ but can also include the @ symbol which can, even these days, be missing from […]
Excel is getting better Conditional Formatting with much needed improvements
Excel’s Conditional Formatting is getting two small but much needed changes that will make it a lot easier to use. According to Microsoft, the latest Insiders releases of Excel 365 for Windows has two changes to the Conditional Formatting Manager dialog. Resizable The dialog is now resizable from the handle at bottom right. That means […]
Illustrations, new graphics in Microsoft 365 Windows and Mac
Illustrations are a new graphics option coming to Microsoft 365 that supplements the existing Icons with a wider range of visual aids for documents, emails, worksheets and slides. They’ve appeared, without any mention, in preview versions of Microsoft 365 for Windows (version 13415.20002) and Microsoft 365 for Mac (v16.43 20102102) On the same dialog box […]
Sound Recording Copyright ℗ symbol in Word, Excel, PowerPoint and Outlook
Put the Sound Recording Copyright ℗ or Circled P character into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Sound Recording Copyright ℗ symbol (aka Circled P ) is used to mark musical copyright. The ‘P’ stands for ‘Phonogram’ or the modern ‘Phonorecord’ (a broad term for any […]
Quickly add continent maps to your Office documents
Adding a continent map is easy in Word, Excel or Powerpoint, in fact there’s a few ways to get them for the Americas, Europe, Africa, Asia, Australia and Antarctica. It depends on the quality you need and version of Office. Continental Icons Among the many icons are silhouettes of all the continents – at least […]
Paste Icons or SVG from Office documents to other apps
Microsoft is expanding their support for SVG graphics by allowing these ‘Icons’ to be copied from Office documents into other third-party apps. Users can take an Office Icon or SVG and easily copy it to another app to use or change beyond Office’s in-built features. There’s no special menu item or feature, it’s part of […]
Now you can handwrite directly into Excel cells
Writing into cells is now possible in Excel for Windows using the Action Pen in a new way. Sadly, as we’ll see, the implementation is a bit clumsy and lacks documentation. Action Pen was introduced earlier this year as a way to edit documents with digital ink gestures. Action Pen handwriting into a cell Draw […]
Office dropped onto Windows computers, in a new way
Microsoft is trying a new way to push Office or Microsoft 365 to new customers by dropping links into the Windows Start Menu. We’ve seen this on the Start Menu of Windows 10 preview releases. It’s a group of icons for Word, Excel, PowerPoint, Outlook, OneNote and Skype. Most of the links are to the […]
Microsoft bug fixes have October Outlook surprise
There are 87 different security breaches fixed in this months rollout of Microsoft bug fixes, including an important one for Windows. Also a Critical fix for Outlook and patches for Word, Excel. We’ll start with a very critical Windows bug that’s important to patch right away. Vital Windows 10 bug fix It’s possible to run […]
Is Excel ready for negative interest rates?
Are your Excel worksheets ready for negative interest rates? The world is seeing historically low interest rates. So low that they can drop to zero or even lower rates. Not only can Excel worksheets break with unexpected negative percentages but modelling can accidently move into negative territory. Interest rates might get more precise going to […]
8 tips for great Excel Sparklines
Excel’s Sparklines have a good range of options for highlighting high and low values, text or calculated overlays, changing axis and handling blank or zero values. Sparklines are in Excel for Windows and Mac. Excel Mobile (iPhone, iPad, Android) shows existing Sparklines made elsewhere but they can’t be changed, only resized or deleted. Even the […]
Better management of large databases in Excel
Excel isn’t the best way to store a large database but it’s a great way to sort, filter, analyse, chart and PivotTable from it. Here’s the best way to import and update a large database into Excel. The standard way to store a list in Excel is to import CSV’s or other data into a […]
What happened with UK COVID tracking and Excel?
The UK has been embarrassed (again) with the news that around 16,000 COVID-19 test results were missing from the official database and so contact tracing wasn’t done. The culprit? Excel. Or, to be fair, bad use of Excel is to blame. Not understanding it’s limits and how to workaround them. We’ve tried to figure out […]
