Close workbook but not Excel (2013, 2016 and up)

One of the problems with the new versions of Excel is that you often need to close Excel down completely to start afresh. In earlier versions you could close the workbooks in such a way that you end up with a grey screen (Excel open but no open workbooks) and you could open a new workbook from there. Two ways to achieve the same things in Excel 2013 and up i.e. close the workbook but not Excel.

YouTube Close workbook but not Excel

The ShortCut

The shortcut to achieve this is to use CTRL + W. So with your last workbook open click CTRL + W.

You will end up with this. You can now open a workbook or start a new one (CTRL + N opens a blank workbook).

Close workbook but not Excel

The Menu option

You can achieve the same thing with the close menu option under the File menu. In the last workbook, instead of clicking the x in the top right (which would close Excel down), click on the File Ribbon and click on the Close option as shown below.

Close workbook but not Excel

You will get back to the grey screen

Close workbook but not Excel

Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course  or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.

Speed up the opening or closing of an Excel file that recalculates

SUMIFS returns VALUE when linked workbooks are closed

Excel won’t insert a column or row