Unhide row doesn't work

One worksheet doesn't show the first 15 rows. I tried the followings, neither worked, even in full-screen mode

Step 1: F5 (Ctrl+G) to define & select 1:15, set row height to 20 and "unhide row", they are still hiding;
Step 2: Put cursor in A16, then up.. till A1 (invisible), select entire row (Ctrl+Shift+→), hold on Shift key, press ↓, till all 15 rows selected, set height and unhide row, still doesn't work!

How can I get them back?

microsoft-excel-2007

PerlDev

Posted 2010-06-25T13:13:45.810

Reputation: 171

Click a row number at far left, press ctrl a to select all rows, right click row numbers on left, right click, click "unhide". – Joe Flack – 2020-02-17T01:38:21.417

3Your question does not seem related to programming – Dr. belisarius – 2010-06-25T13:16:45.790

It's formating :-) – PerlDev – 2010-06-25T13:18:57.310

1Select all rows, paste them into a new worksheet, all rows show up – PerlDev – 2010-06-25T13:19:45.377

could you maybe post a screenshot of your worksheet with the hidden rows? have you checked if there are any addins/vba-macros active - linke Wokrsheet_change? Could you add a screenshot of your VBE with the problematic workbook opended in? – Jook – 2012-09-24T09:52:12.487

Answers

Select the Sort & filter icon from the home menu bar, uncheck the Filter button.

To me, it looks like bug in Excel filters.

arik android_senior

Posted 2010-06-25T13:13:45.810

Reputation: 151

I had the issue you were describing and found that the rows were unhidden, but the row height was zero. So, unhide the rows as you describe and then hover over the row symbols on the side (in between the two rows where your rows are hidden) and then click and drag to expand the row height manually.

There's probably a visual basic script to do this that you could code up as well.

statueuphemism

Posted 2010-06-25T13:13:45.810

Reputation: 141

Also, be careful that you haven't got a frozen pane. This can cause all sort of problems.

From View, look under Window and for Freeze Pane, there's an Unfreeze Pane option.

This one drove me nuts for half an hour until I realized what was going on. Unhide on its own didn't work. Neither did changing row height. Frozen panes are very subtle.

Jason

Posted 2010-06-25T13:13:45.810

Reputation:

If you select all the rows and click 'unhide' and they do not show up, then they are filtered and not hidden. Click the Sort & Filter button on the Home tab of the ribbon and then click 'clear'.

user3658961

Posted 2010-06-25T13:13:45.810

Reputation: 1

Select GOTO (CTRL+G)
Select the hidden rows only... if hidden rows are 3 to 100, then 3:100
In the menu bar select Format > Row Height The hidden rows should all have a value of "0".
Change and set the height of the rows to what you want... ie 15
All of the hidden rows should now be visible

Derek

Posted 2010-06-25T13:13:45.810

Reputation: 1

Try the following:

Type the first cell reference A1 in the Name Box and press enter. On the Home tab, click on the Format icon Choose Hide & Unhide from the dropdown menu then select Unhide Rows.

You should be able to unhide all of the rows inbetween after that.

James O'Sullivan

Posted 2010-06-25T13:13:45.810

Reputation: 101

Nope, it doesn't work either. I tried the following VBA code, not work either:

` Sub test() Dim rng As Range

For i = 1 To 15
    Set rng = Rows(i)
    rng.Locked = False
    rng.RowHeight = 20
    rng.Hidden = False
Next
Set rng = Nothing

End Sub ` – PerlDev – 2010-06-25T13:51:42.557

Tried all the solutions listed in http://spreadsheets.about.com/od/excelformatting/qt/070814unhiderow.htm, none of them works.

– PerlDev – 2010-06-28T13:24:28.857

I removed my filter from the whole worksheet and everything appeared. Then I highlighted everything I wanted filtered and re-applied the filter.

Joni Durden

Posted 2010-06-25T13:13:45.810

Reputation:

Highlight the rows you want unhidden. Double click on the space between the rows in the numbers column, (on the left side) your mouse pointer icon will change from a pointing right symbol to an expansion symbol. The hidden rows will show themselves.

Helper

Posted 2010-06-25T13:13:45.810

Reputation:

I know it's an old question, but there is a way to get the rows back.

use ALT+F11

If you can't see a window labelled Immediate Window then press CTRL+G to get there.

In that window, type (or copy) the following code, adjusting for the rows you want unhidden, and the sheetname

for x=1 to 15:sheets("WorkSheetName").range("A"&x).entirerow.rowheight=17:next

This sets the height of all 15 rows to a height of 17, and you can then manipulate them how you wish.

SeanC

Posted 2010-06-25T13:13:45.810

Reputation: 3 439