There are several ways for an Excel table to be transposed (rows and columns) but none of the online suggestions work very well with tables. We’ve found a solution which transposes one table into a ‘swapped’ table i.e headers become column A and column A becomes the headers. Along the way we’ll explain a clever […]
You can make it easier to see your current place in a workbook by dynamically highlighting the selected row, column, cell or headings. Here’s obvious and more subtle highlighting options plus the downside of highlighting, real world tips and debugging tricks if you’re having trouble. There are many different variations on this method; two colors, […]
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 new features with their images: […]
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 can’t ‘Open Excel or any […]
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 known as ‘Insights’ (a more […]
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 early 2020. They’ve not said […]
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 to be a forwarded message […]
We’ve completed our series on ‘Hidden’ options in Word, Excel and PowerPoint. How to hide text, images, cells, slides etc within documents. Hiding is a useful option and avoids deleting content that might be needed later. It lets you make a different version of a document/sheet/deck without the hassle of maintaining two very similar documents. […]
A new Excel add-in converts an Excel 365 worksheet into a Visio diagram. You don’t need to buy Visio to use the Microsoft Visio Data Visualizer in its simple form, just Excel 365 for Windows/Mac or Online. It’s an interesting tool and worth checking out if you make diagrams or flowcharts. The add-in inserts example […]
A new Office app for Android a single ‘all in one’ app for Microsoft Office. We’ve done our own look at the new app, not relying on Microsoft’s hype to check out the Home panel, Actions, Word, Excel and PowerPoint features, PDF viewing and options, ‘image to text’ features and how to bypass a major […]
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 Office feature. In this case […]
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 Microsoft Bluetooth Keyboard released in […]
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 + 0 to hide a […]
If you have data in Excel that you don’t want to be visible, but you still need to be able to use it in calculations, there are two ways to hide cells. It’s another case of Office having an official and unofficial hiding option. Here we’re talking about hiding individual cells or ranges. There are […]
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 the new key has been […]
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 years, a different worksheet for […]
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 365 for Windows from Insider […]
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 right of the spacebar. Source: […]
Like it or loath it but the comma ellipsis has arrived ,,, as an alternative to the more common ellipsis with dots. Here’s how to use it in Word and Office. The comma ellipsis is a modern, more casual version. It’s used as a more dramatic, even annoyed trailing off of a thought, compared to […]
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 allows you to save your […]
