7
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?
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