#UNHIDE ROWS EXCEL FOR MAC HOW TO#

Select all the row numbers and columns letters by clicking on the grey block on the top left of your spreadsheet.But this method works with larger sets too): In such cases, here’s how you can find out if there are hidden rows in the dataset (to help you understand the concepts easily, we have kept the dataset in our images small. If you have a larger database, however, it may be harder to spot the arrows. The above method is fine if you can clearly see which rows are hidden.

#UNHIDE ROWS EXCEL FOR MAC HOW TO#

How to Unhide Rows in Google Sheets (for larger datasets) Your hidden rows should now become visible again. To unhide the rows, all you need to do is click on one of the two arrows.Secondly, if you look at the rows in your sheet carefully, you should notice two arrows on consecutive rows (as the ones are shown below) to signify that there are hidden rows in between.As you can see in the image below, you get rows 1, 2, and then it skips to row 5. The obvious giveaway is the absence of certain consecutive row numbers.Here are some tell-tale signs that there are hidden rows in your Google Sheet: So, it’s a good idea to check for hidden rows in the sheet. If you’re looking at a worksheet and you feel like some data is amiss, there’s a possibility that some rows are hidden. How to Unhide Rows in Google Sheets (for smaller datasets) How to Unhide Rows in Google Sheets (for larger datasets).How to Unhide Rows in Google Sheets (for smaller datasets).

Unhide rows excel for mac