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
edited Sep 26 '12 at 0:47
Der Hochstapler
67.3k49230284
asked Jun 25 '10 at 13:13
PerlDev
121112
migrated from stackoverflow.com Sep 26 '12 at 0:38
This question came from our site for professional and enthusiast programmers.
add a comment |
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
edited Sep 26 '12 at 0:47
Der Hochstapler
67.3k49230284
asked Jun 25 '10 at 13:13
PerlDev
121112
migrated from stackoverflow.com Sep 26 '12 at 0:38
This question came from our site for professional and enthusiast programmers.
3
Your question does not seem related to programming
– Dr. belisarius
Jun 25 '10 at 13:16
It's formating :-)
– PerlDev
Jun 25 '10 at 13:18
1
Select all rows, paste them into a new worksheet, all rows show up
– PerlDev
Jun 25 '10 at 13:19
could you maybe post a screenshot of your worksheet with the hidden rows? have you checked if there are any addins/vba-macros active - linkeWokrsheet_change? Could you add a screenshot of your VBE with the problematic workbook opended in?
– Jook
Sep 24 '12 at 9:52
add a comment |
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
edited Sep 26 '12 at 0:47
Der Hochstapler
67.3k49230284
asked Jun 25 '10 at 13:13
PerlDev
121112
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
microsoft-excel-2007
edited Sep 26 '12 at 0:47
Der Hochstapler
67.3k49230284
asked Jun 25 '10 at 13:13
PerlDev
121112
edited Sep 26 '12 at 0:47
Der Hochstapler
67.3k49230284
asked Jun 25 '10 at 13:13
PerlDev
121112
edited Sep 26 '12 at 0:47
Der Hochstapler
67.3k49230284
edited Sep 26 '12 at 0:47
Der Hochstapler
67.3k49230284
edited Sep 26 '12 at 0:47
Der Hochstapler
67.3k49230284
67.3k49230284
asked Jun 25 '10 at 13:13
PerlDev
121112
asked Jun 25 '10 at 13:13
PerlDev
121112
asked Jun 25 '10 at 13:13
PerlDev
121112
121112
migrated from stackoverflow.com Sep 26 '12 at 0:38
This question came from our site for professional and enthusiast programmers.
migrated from stackoverflow.com Sep 26 '12 at 0:38
This question came from our site for professional and enthusiast programmers.
3
Your question does not seem related to programming
– Dr. belisarius
Jun 25 '10 at 13:16
It's formating :-)
– PerlDev
Jun 25 '10 at 13:18
1
Select all rows, paste them into a new worksheet, all rows show up
– PerlDev
Jun 25 '10 at 13:19
could you maybe post a screenshot of your worksheet with the hidden rows? have you checked if there are any addins/vba-macros active - linkeWokrsheet_change? Could you add a screenshot of your VBE with the problematic workbook opended in?
– Jook
Sep 24 '12 at 9:52
add a comment |
3
Your question does not seem related to programming
– Dr. belisarius
Jun 25 '10 at 13:16
It's formating :-)
– PerlDev
Jun 25 '10 at 13:18
1
Select all rows, paste them into a new worksheet, all rows show up
– PerlDev
Jun 25 '10 at 13:19
could you maybe post a screenshot of your worksheet with the hidden rows? have you checked if there are any addins/vba-macros active - linkeWokrsheet_change? Could you add a screenshot of your VBE with the problematic workbook opended in?
– Jook
Sep 24 '12 at 9:52
3
3
Your question does not seem related to programming
– Dr. belisarius
Jun 25 '10 at 13:16
Your question does not seem related to programming
– Dr. belisarius
Jun 25 '10 at 13:16
It's formating :-)
– PerlDev
Jun 25 '10 at 13:18
It's formating :-)
– PerlDev
Jun 25 '10 at 13:18
1
1
Select all rows, paste them into a new worksheet, all rows show up
– PerlDev
Jun 25 '10 at 13:19
Select all rows, paste them into a new worksheet, all rows show up
– PerlDev
Jun 25 '10 at 13:19
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
Sep 24 '12 at 9:52
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
Sep 24 '12 at 9:52
add a comment |
9 Answers
9
active
oldest
votes
Select the Sort & filter icon from the home menu bar, uncheck the Filter button.
To me, it looks like bug in Excel filters.
edited Aug 5 '14 at 8:19
Jens Erat
12.5k114459
answered Aug 5 '14 at 7:58
arik android_senior
11122
add a comment |
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.
answered Sep 21 '12 at 20:40
statueuphemism
1413
add a comment |
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.
answered Jun 25 '10 at 13:34
James O'Sullivan
1011
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
Jun 25 '10 at 13:51
Tried all the solutions listed in spreadsheets.about.com/od/excelformatting/qt/…, none of them works.
– PerlDev
Jun 28 '10 at 13:24
add a comment |
I removed my filter from the whole worksheet and everything appeared. Then I highlighted everything I wanted filtered and re-applied the filter.
add a comment |
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.
add a comment |
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.
add a comment |
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.
answered Oct 27 '14 at 17:05
SeanC
3,28411425
add a comment |
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'.
answered Sep 20 '16 at 12:27
user3658961
1
add a comment |
- 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
answered Jun 21 '17 at 21:53
Derek
1
add a comment |
protected by Community♦ Dec 12 '18 at 17:55
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
9 Answers
9
active
oldest
votes
9 Answers
9
active
oldest
votes
active
oldest
votes
active
oldest
votes
Select the Sort & filter icon from the home menu bar, uncheck the Filter button.
To me, it looks like bug in Excel filters.
edited Aug 5 '14 at 8:19
Jens Erat
12.5k114459
answered Aug 5 '14 at 7:58
arik android_senior
11122
add a comment |
Select the Sort & filter icon from the home menu bar, uncheck the Filter button.
To me, it looks like bug in Excel filters.
edited Aug 5 '14 at 8:19
Jens Erat
12.5k114459
answered Aug 5 '14 at 7:58
arik android_senior
11122
add a comment |
Select the Sort & filter icon from the home menu bar, uncheck the Filter button.
To me, it looks like bug in Excel filters.
edited Aug 5 '14 at 8:19
Jens Erat
12.5k114459
answered Aug 5 '14 at 7:58
arik android_senior
11122
Select the Sort & filter icon from the home menu bar, uncheck the Filter button.
To me, it looks like bug in Excel filters.
edited Aug 5 '14 at 8:19
Jens Erat
12.5k114459
answered Aug 5 '14 at 7:58
arik android_senior
11122
edited Aug 5 '14 at 8:19
Jens Erat
12.5k114459
edited Aug 5 '14 at 8:19
Jens Erat
12.5k114459
edited Aug 5 '14 at 8:19
Jens Erat
12.5k114459
12.5k114459
answered Aug 5 '14 at 7:58
arik android_senior
11122
answered Aug 5 '14 at 7:58
arik android_senior
11122
answered Aug 5 '14 at 7:58
arik android_senior
11122
11122
add a comment |
add a comment |
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.
answered Sep 21 '12 at 20:40
statueuphemism
1413
add a comment |
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.
answered Sep 21 '12 at 20:40
statueuphemism
1413
add a comment |
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.
answered Sep 21 '12 at 20:40
statueuphemism
1413
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.
answered Sep 21 '12 at 20:40
statueuphemism
1413
answered Sep 21 '12 at 20:40
statueuphemism
1413
answered Sep 21 '12 at 20:40
statueuphemism
1413
answered Sep 21 '12 at 20:40
statueuphemism
1413
1413
add a comment |
add a comment |
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.
answered Jun 25 '10 at 13:34
James O'Sullivan
1011
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
Jun 25 '10 at 13:51
Tried all the solutions listed in spreadsheets.about.com/od/excelformatting/qt/…, none of them works.
– PerlDev
Jun 28 '10 at 13:24
add a comment |
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.
answered Jun 25 '10 at 13:34
James O'Sullivan
1011
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
Jun 25 '10 at 13:51
Tried all the solutions listed in spreadsheets.about.com/od/excelformatting/qt/…, none of them works.
– PerlDev
Jun 28 '10 at 13:24
add a comment |
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.
answered Jun 25 '10 at 13:34
James O'Sullivan
1011
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.
answered Jun 25 '10 at 13:34
James O'Sullivan
1011
answered Jun 25 '10 at 13:34
James O'Sullivan
1011
answered Jun 25 '10 at 13:34
James O'Sullivan
1011
answered Jun 25 '10 at 13:34
James O'Sullivan
1011
1011
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
Jun 25 '10 at 13:51
Tried all the solutions listed in spreadsheets.about.com/od/excelformatting/qt/…, none of them works.
– PerlDev
Jun 28 '10 at 13:24
add a comment |
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
Jun 25 '10 at 13:51
Tried all the solutions listed in spreadsheets.about.com/od/excelformatting/qt/…, none of them works.
– PerlDev
Jun 28 '10 at 13:24
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
Jun 25 '10 at 13:51
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
Jun 25 '10 at 13:51
Tried all the solutions listed in spreadsheets.about.com/od/excelformatting/qt/…, none of them works.
– PerlDev
Jun 28 '10 at 13:24
Tried all the solutions listed in spreadsheets.about.com/od/excelformatting/qt/…, none of them works.
– PerlDev
Jun 28 '10 at 13:24
add a comment |
I removed my filter from the whole worksheet and everything appeared. Then I highlighted everything I wanted filtered and re-applied the filter.
add a comment |
I removed my filter from the whole worksheet and everything appeared. Then I highlighted everything I wanted filtered and re-applied the filter.
add a comment |
I removed my filter from the whole worksheet and everything appeared. Then I highlighted everything I wanted filtered and re-applied the filter.
I removed my filter from the whole worksheet and everything appeared. Then I highlighted everything I wanted filtered and re-applied the filter.
answered Apr 7 '11 at 22:06
Joni Durden
add a comment |
add a comment |
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.
add a comment |
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.
add a comment |
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.
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.
answered Jun 24 '11 at 14:17
Jason
add a comment |
add a comment |
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.
add a comment |
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.
add a comment |
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.
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.
answered Feb 23 '12 at 20:58
Helper
add a comment |
add a comment |
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.
answered Oct 27 '14 at 17:05
SeanC
3,28411425
add a comment |
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.
answered Oct 27 '14 at 17:05
SeanC
3,28411425
add a comment |
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.
answered Oct 27 '14 at 17:05
SeanC
3,28411425
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.
answered Oct 27 '14 at 17:05
SeanC
3,28411425
answered Oct 27 '14 at 17:05
SeanC
3,28411425
answered Oct 27 '14 at 17:05
SeanC
3,28411425
answered Oct 27 '14 at 17:05
SeanC
3,28411425
3,28411425
add a comment |
add a comment |
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'.
answered Sep 20 '16 at 12:27
user3658961
1
add a comment |
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'.
answered Sep 20 '16 at 12:27
user3658961
1
add a comment |
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'.
answered Sep 20 '16 at 12:27
user3658961
1
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'.
answered Sep 20 '16 at 12:27
user3658961
1
answered Sep 20 '16 at 12:27
user3658961
1
answered Sep 20 '16 at 12:27
user3658961
1
answered Sep 20 '16 at 12:27
user3658961
1
1
add a comment |
add a comment |
- 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
answered Jun 21 '17 at 21:53
Derek
1
add a comment |
- 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
answered Jun 21 '17 at 21:53
Derek
1
add a comment |
- 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
answered Jun 21 '17 at 21:53
Derek
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
answered Jun 21 '17 at 21:53
Derek
1
answered Jun 21 '17 at 21:53
Derek
1
answered Jun 21 '17 at 21:53
Derek
1
answered Jun 21 '17 at 21:53
Derek
1
1
add a comment |
add a comment |
protected by Community♦ Dec 12 '18 at 17:55
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
3
Your question does not seem related to programming
– Dr. belisarius
Jun 25 '10 at 13:16
It's formating :-)
– PerlDev
Jun 25 '10 at 13:18
1
Select all rows, paste them into a new worksheet, all rows show up
– PerlDev
Jun 25 '10 at 13:19
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
Sep 24 '12 at 9:52