Share via

unhide rows function not working in Excel

Anonymous
2018-04-08T13:56:18+00:00

There is a hidden row on the spreedsheet.  The hide rows function appears to work but not the unhide rows.  Both hide and unhide columns is working.  On the spreadsheet there is  data that takes about 30 columns and 500 rows. When particular parts of the data were analyzed some of the columns were hidden and the analysis started to the right.  The analysis took many fewer columns and rows.  When the analysis was copied, one row was omitted when pasted on a new sheet.  This omitted row was at the hidden row site.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2018-04-09T17:22:04+00:00

It may not be hidden but may just have a very small height. Select the rows above and below that row, then change the row height to something larger.

Was this answer helpful?

10+ people found this answer helpful.
0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2018-04-12T19:12:14+00:00

    you are correct. Thanks

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments