Do you want to delete all the hidden rows or columns from your workbook in Microsoft Excel 2016?. Here’s how you can do it. How to delete all hidden rows or columns in Microsoft Excel 2016 ? 1. Open your excel workbook in Microsoft Excel 2016 and then click File –> Info. 2. Pressing “Ctrl Shift +” on your keyboard is a shortcut for insert. “Ctrl” and the minus button “-” at the same time is the Excel shortcut for delete. If you select one cell in your spreadsheet and press “Ctrl Shift +” you will have a shortcut for inserting a cell. Apr 04, 2013 · If a sheet is hidden, rather than very hidden, a user will know because the Unhide command is enabled and if selected will display the Unhide dialog which contains a list of all hidden sheets. To my knowledge, there is no visual indication in the standard Excel user interface for very hidden sheets. Delete all Sheets except a couple specifically named Posted by Mark Farr on October 18, 2001 2:24 PM I am using a pivot table and when you drill down it opens a new sheet.