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
The newer File | Open panes include a Search option to quickly find Recent Documents by name. That means it’s practical to expand the Recent Docs list to a higher or maximum value in Word, Excel or PowerPoint. In any of the three programs go to File | Options |
Here’s this months non-security bug fix updates.for Office 2016 and Office 2013. They are only for .msi installs, not ‘Click to Run’ modern installations. For most systems, they’ll be applied automatically. This is the full list with extra notes on a few fixes which caught our eye. Office 2016 updates
The error messages on Office 365/2019 setup and update are notoriously unhelpful, so here’s a guide to fixing Office install or update problems that work out here in the real world. Error messages like the infamous ‘Something went wrong” should be taken with a large pinch of salt. The error
If you get an error message when installing or updating Office 365 or Office 2019 there’s little help available beyond Microsoft telling you ‘Something went wrong’. What looks like specific error message are general statements that don’t identify the problem. These troubles aren’t any surprise to experienced Microsoft Office users.
The venerable SUM() function in Excel is simple, really too simple. It just adds up a range of cells with no way to filter or limit what’s included. SumIF selects what to add-up from a longer list. SumIf sometimes confuses people because they, understandably, expect the range to be SUMmed
Microsoft and some contractors listen to Skype calls but that shouldn’t be a surprise to anyone. And Microsoft’s response was quite typical – they refuse to stop. Microsoft can and does let it’s ‘associates’ listen and read from Office documents and voice data. Word, PowerPoint and Outlook users are also
There are two similar text formatting options in Excel. The well-known Merge & Center and the hidden away Center across selection. Both have their advantages, the choice is yours. Merge & Center Most Excel users know ‘Merge & Center’ because it’s atop the Merge list at Home | Alignment |
A recent Windows update is causing VBA code to fail in Excel, Access and other VBA parts of Office. The culprit isn’t Office, but the version of Windows that it’s running on. After the 2019-08 Cumulative Update KB4511553 is applied, some VBA code will stop working. The patch bug is
The desperately needed feature is coming to Microsoft Office … the ability to search for Icons. Microsoft added Icons to Office 365 and even more a few months ago … 300 more icons in Office, but which ones and where? The problem has always been finding the right icons from
Office now has sensitivity options to label Word, Excel, PowerPoint docs plus emails. Not ‘touch-feely’ sensitivity like ‘loving’ or ‘compassionate’ but instead corporate, privacy labels. It’s a new feature for Office 365 corporate hosted E3 or E5 accounts and the admins have enabled Sensitivity options. Sensitivity appears on the Home
