Excel Sheet Unhide Shortcut

The need to unhide sheets.

Excel sheet unhide shortcut. If you want to unhide your spreadsheet columns by using a code then you can use the following macro for this task. In this article we will see an outline on how to unhide sheets in excel. As with hiding worksheets excel has no keyboard shortcut for unhiding a sheet but you can still use the ribbon. I have a post on 3 ways to unhide multiple sheets in excel that explains techniques for unhiding sheets with a macro.

Excel s unhide option only allows you to select one sheet at a time. We can apply the unhide sheet feature to unhide a hidden worksheet at a time in excel. Select one or more worksheet tabs at the bottom of the excel file. Click the home tab on the ribbon.

1 click home format hide unhide unhide sheet see screenshot. Another way to hide worksheets in excel is by clicking the hide sheet command on the ribbon. Yes we can unhide the sheet using the shortcut key. Introduction to unhide sheets in excel.

Click the ok button and now the unhide column shortcut key will start working in excel. Select the sheet s you want to hide. Please do as follows. You can also right click any one of sheet names in the sheet tab bar and select unhide from the context menu.

Keyboard shortcut to hide excel sheets. Unfortunately unhiding multiple sheets is not directly possible in excel. Hiding multiple worksheets in an excel workbook is quite easy however unhiding them can be tedious. How to use shortcut keys or the context menu to hide and unhide columns and rows in excel for a cleaner spreadsheet.

Updated to include excel 2019. Unhide columns in excel using a macro. We can unhide multiple sheets one by one in excel or use a vba code to unhide all of these in one go. Using excel shortcut key.

Under visibility point to hide unhide and click hide sheet. This resolution is suggested in the microsoft knowledge base article. Now comes a more efficient one i e. As usual select the worksheet that you want to unhide and click on ok it will unhide the selected sheet.

This is an exceptionally useful feature as it allows us to store data in a sheet such as lists and tables but keep the user of the workbook from seeing manipulating and more importantly corrupting the information on the hidden sheet. In excel 2016 excel 2013 excel 2010 and excel 2007 go to the home tab cells group and click the format under visibility point to hide unhide and then click unhide sheet note.