The Office apps for Android are getting some interesting new features. Excel for Android has better sort and filtering. Galaxy Watch can now link to the Outlook app. At first for preview ‘Insiders’ and later to the publicly available Word, Excel, PowerPoint and Outlook apps. Here’s Microsoft announcement of the
Just one of the many tricks to get people to giveaway their password is a bogus ‘system delay’ email, supposedly from your network administrators. The fake login page is given extra credibility being hosted on a Microsoft server! It starts with a fake message from the ‘Excel Team’ saying you
Excel is getting a clever new way to quickly analyse your worksheets and pull out useful ideas or insights to quickly make PivotTables, PivotCharts and Charts. It’s now available in Excel 365 for Windows and Mac, Insiders and will eventually make it to public releases. It’s now called ‘Ideas’, previously
Microsoft is touting Application Guard as a defence against Office 365 macro viruses. What is it and will it truly prevent viruses in Word, Excel or PowerPoint documents? Application Guard is already in the Edge browser and Microsoft has announced that it will be extended into Office 365 sometime in
Here’s how to block .IQY web queries in Excel that are being used to infect machines with Buran ransomware. Yet again, a mostly forgotten part of Office is being used by hackers to get inside computers and networks. Suspicious Link (great name) found this nasty in an email. It pretends
A security vulnerability has been discovered in Excel for Mac. It’s been there for many years and affects Office 365, Office 2019, Office 2016 and Office 2011 for Mac. We have details and suggest a protection you can do yourself. It’s another problem with legacy support for an older Microsoft
The Microsoft Bluetooth Keyboard is one of two new models with dedicated Office key and Emoji key. What’s this new keyboard like … aside from those innovations? We bought a Microsoft Bluetooth Keyboard with our own money and gave it a long hard look. Source: Microsoft Note: this is the
Make your worksheets look more compact and focused by hiding unwanted columns or rows. Hidden rows/columns still work in calculations, they can be referenced in formulas etc. It’s pretty straightforward. Select the columns or rows, right-click and choose Hide. Keyboard shortcuts Type Control + 9 to hide a row. Control
Two new Microsoft keyboards have a dedicated Office key. Office-Watch.com has tested one of these keyboards to see how the new Office key really works. We have a full list of Office key shortcuts plus how it works inside Word, Excel and PowerPoint and geeky hardware info. Hard information about
3D Formulas in Excel allow you to make calculations using data from many different worksheets, including ones that don’t exist yet. This can be incredibly useful, when you have similar figures for different periods across worksheets and want to use data from all of those periods. For our example, we have a file with expenses for a number of
Soon, Office 365 will warn you when the document, worksheet or presentation uses a document format that doesn’t support modern accessibility features. Accessibility features like alt text in images, color contrast, heading consistency, table structures are only available with the modern Office document formats ( .docx .xlsx .pptx etc). Office
Microsoft is releasing two new keyboards with new keys; an Office key and a dedicated Emoji key. Back in June we talked about the plans for an Office key to go alongside the existing Windows key. Here it is … Source: Microsoft The Office and Emoji keys are on the
Excel has a huge range of charts available and endless ways to customize them, but after working to get it just right, you don’t want to have to go through the whole process again next time you want to make a similar chart. Fortunately, you don’t have to because Excel
The new iPad has a great price tag and good features but a hidden price trap for Microsoft Office users. It has a 10.2” screen with support for important accessories like an external keyboard and Apple Pencil. Source: Apple. The trap is in the screen size, at 10.2” it’s 0.1
It’s time again for the monthly drop of security updates for Windows and Office. Here’s what caught our eye; two Excel security bugs and a Windows update which kills VMWare Workstation. Commentators are calling this a ‘light’ month for security patches because there are a mere 59 patches instead of
Microsoft is pushing out a new Office app for iPhone and Android devices however most Office users won’t need to bother with it. Paid Office 365 subscribers already have better choices as part of their annual plan. The new app is called ‘Microsoft Office Mobile’ and it’s a single app
There are many situations where you need to split up text into separate columns. Names, phone numbers, dates, addresses and lot’s more can be managed with Excel’s Text to Columns, Text to Columns allows you take data from one column, and split it out into multiple columns. This can be
Outlook on the web is now blocking another 38 email attachments because they can be carriers of viruses. But Microsoft doesn’t block the most commonly used files for infecting computers. Far and away the most common infected email attachment is old-style Word documents, with .doc extensions. Excel .xls worksheets and
A recent forced disclosure by the US government demonstrates the use of NSL’s which access your personal data from Microsoft OneDrive and Outlook without a warrant or regular oversight, let alone notice to you. Microsoft, Google, Facebook and many other tech companies (including gaming services) have received National Security Letters
The Upload Center, that annoying little extra in modern Office is being closed down. It’s being replaced with ‘Files Needing Attention’ alerts within Word, Excel, PowerPoint, Publisher and Visio. The Upload Center controls documents being uploaded from Office to online storage like OneDrive and SharePoint. If you haven’t noticed Upload
As we suspected, there are more holes in the Office Document Inspector. Our clever readers came up with some possibilities for revealing secrets in documents, worksheets and presentations. Document Inspector is good but could be better. As you’ll see, there really should be a warning about objects with multiple layers.
Surface pens will now turn on the Draw tab in Word, Excel and PowerPoint automatically. When you pick up a Microsoft Surface Pen, the Draw tab in Office 365 will automatically appear to choose color, thickness of the digital ink. There are a few requirements, but they are pretty obvious:
The famous game, Civilization, has been impressively recreated in Excel as Solly’s Cellivization. Civilization was an early computer game that started in 1991 for MS-DOS and has undergone many reincarnations for Windows, Mac and gaming devices now almost forgotten. Here it is in Microsoft Excel … Even with the power
Here’s a list of the known Office install/update error codes with possible fixes. All thanks to a diligent and long-suffering Office Watch reader. Ron S has compiled these lists from web sites and forums based on experiences of other people. Doesn’t Microsoft have all this? Yes, they probably do but
