Excel Sheet Unhide Not Working

There is a hidden row on the spreedsheet.

Excel sheet unhide not working. Please do as follows. The hide rows function appears to work but not the unhide rows. Double click the excel document that you want to use to open it in excel. I have a spreadsheet and the unhide button for hidden sheets appears not to work i can see the sheets are there when i do alt f8 to open vba manager.

This wikihow teaches you how to force one or more hidden rows in a microsoft excel spreadsheet to display. If the first row row 1 or column column a is not displayed in the worksheet it is a little tricky to unhide it because there is no easy way to select that row or column. I know this is an old thread but i just discovered another way that rows can become un unhideable. We have received a number of queries saying the unhide rows is not working in excel.

You can also right click any one of sheet names in the sheet tab bar and select unhide from the context menu. Unhiding where row 1 is hidden. 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.

You can select the entire worksheet and then unhide rows or columns home tab cells group format button hide unhide command but that displays all hidden rows and columns in your worksheet which you may not want. To test the hide and unhide be working properly i have hidden rows 18 19 by right click hide and then unhide the whole worksheet. It is also not an unhiding issue. T here are certain situations when you can t unhide columns on the left and or rows at the top and it is not a sheet protection issue.

A macro has probably set the visible property of the sheets to xlveryhidden. It is caused by freeze panes. Can anyone help me unhide the sheets. 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.

When particular parts of the data were analyzed some of the columns were hidden and the analysis started to the right. It depends where you are when you set your freeze panes. There are generally a few reasons why the rows won t unhide. On the spreadsheet there is data that takes about 30 columns and 500 rows.

If rows are hidden from row 1 it is important to correctly highlight the rows and right click on the correct row. Open the excel document. That was one of the weird things i encountered in using excel. Try this code in a macro to make a sheet visible again.

Strange enough rows 18 19 are back but not rows 2 15. How to unhide rows in excel. If the page is scrolled up a little at the time that the freeze panes command is used on the ribbon under view window freeze panes then the rows that are off the top of the screen will be permanently hidden until the unfreeze panes command is used.