In Excel 2016, if the application crashes, the AutoRecovery pane will not necessarily appear immediately when the program is restarted.

The Custom Lists dialog box (File -> Options -> Advanced -> Edit Custom Lists) allows you to add filter lists, with multiple items entered using the ENTER key between items. Recently, it has been reported that the ENTER key stopped registering properly and does not function as expected.

Have you used the AREAS function? Let’s see if this function will come in handy for you…

When you try to save or export your document as a PDF file, Excel 2016 crashes (in fact, this happens for Word 2016 too).

A question that keeps cropping up is the question, “What version of Excel do I have?” so we thought we ought to help out....

Spreadsheet users have noted that workbooks that have multiple sheets containing list-based Data Validation sometimes get corrupted or have a drop-down list which gets duplicated.

Now this is more like it. We finally get to one of those useful Excel functions you simply cannot live without...

Users have reported that HTML files with .xls extensions are not opening outside Protected View in Excel 2010, 2013 or 2016.

Some users have reported that when you try to open an .xls or .xlsx file in Excel 2016, it does not recognise the file extension. Consequently, it is not opened as an Excel file and, worse, Excel may not appear in the list of applications to choose from.

With bills to pay, mouths to feed and fun to have, in these uncertain times, it’s good to be in a steady job. What better way than to make yourself indispensable?