Platform: Linux, FreeBSD, macOS, Windows (beta).This is more the fault of Microsoft’s convoluted file formats than anything else, but it’s something to be wary of if you need pixel-perfect document layouts. You can import and export Microsoft-format documents, but note that it can cause formatting mistakes. There are mobile apps for Apple and Android devices, so you can access your documents from all your devices wherever you are.Ĭollaboration is also excellent, so you can seamlessly work on the same documents with colleagues without stepping on each other’s toes, and there’s robust versioning so you can roll back to previous versions of documents if need be. The tools work well in any modern web browser, which makes deployment across an organisation a cinch. These tools include Gmail (email), Drive (cloud storage), Docs (word processing), Sheets (spreadsheets), Slides (presentations), and Meet (video conferencing). It’s an amalgamation of 12 Google tools for a monthly subscription that starts at £4.14 per user a month.
Note that in Excel 2016, the shortcut to close the Excel help dialogue box is CTRL + Spacebar + C.Īlt + F4 can also be used outside of Excel – it is a universal shortcut for Windows that will close any application.Google Workspace, previously known as G Suite, is a cloud-based productivity suite from internet giant Google. However, ALT + F4 will conveniently close this dialogue box – just as quickly as it was opened. While pressing the Escape key will typically close a dialogue box in Excel, in this instance it has no effect. If you are a frequent user of the F2 key, you have likely accidentally pressed F1 – which of course brings up the Excel help dialogue box. We also like ALT + F4 for the following common issue in Excel.
Note that in Excel 2013 and later, Alt + F4 will either close the current workbook (if there are many workbooks open), or close the current workbook and Excel itself (if it is the only workbook open). If you would like to close all workbooks that are open, as well as Excel itself, the shortcut that will achieve this is Alt + F4. Both CTRL + W and CTRL + F4 will close the current workbook. However, there are many different ways to close workbooks. Most people know that CTRL + N will create a new workbook in Excel. This includes the creation of new workbooks right up to and including the closing of these workbooks – or even the closing of Excel itself. At Marquee, we are strong advocates of using the keyboard for all things Excel.